The Ragic Guide
Transforming the way your business works with IT software and cloud services
Follow us on Social Media!
Trending
Applications
Case Studies
What is Ragic
Talking Ragic
Facebook Twitter YouTube
Product
Guide
About
Trending
Applications
Case Studies
What is Ragic
Talking Ragic

Search in your Ragic application

By Jeff Kuo

Databases are made for searching. What’s the point of putting your data in a database if you can’t find your data efficiently? Ragic provides two ways to search for your data: the traditional database query, and the full text search.

Traditional database query: Two ways you can use the traditional database query, by clicking on the arrow of the field header in a listing page, this works the way it works on Excel. Or you can click the “filter” button at top right. And then you can filter each fields according to whether it’s a string, date, or number field.

What’s interesting about our query function is that you can query fields in the subtables. Like when a single employee have several degrees and work experience. You can issue queries to search for employees that has a masters degree.

Full Text Search: Using the full text search box at the top left corner, you can find all entries in the whole database that contains your search term. This can be quite convenient if you have a pretty specific term that you’re looking for.

One trick that you can make use of the full text search function: when you enter text no matter in the form or the comments, you can use brackets [] to denote the term inside the bracket refers to an entry in the database. For example, when you enter [Joe Smith], it will become a hyperlink after you save it. When users click on this link, Ragic will use its full text search function to find entries that are related to this search term, and take the user to it. This way you can save people a good amount of time when referencing between forms and entries.

Powered by Ragic! : #1 No Code tool for digitalizing your business processes
Keeping business data on Excel is not only a big productivity drain, it's error prone and provides no adequate trail of audit. As your team grows, managing data with spreadsheets become increasingly painful.
Create your first database now!

Start Ragic for Free

Sign up with Google