Knowledge Base
Pricing
About
Home
Free sign up
How can we help?
Ragic Plans and Billing
If a user is in different accounts, how is pricing calculated?
I have a lot of users outside my company that use our DB once in a while, how can I save on user licenses?
Do reports count as sheets?
What's the difference between Lite and Professional version?
How do I upgrade or start my subscription?
Account Billing Information and History
Can I change my plan?
Will I lose free trial days if I subscribe early?
How is mass SMS fee charged in Ragic?
If I don’t need to use my Ragic database temporarily, can I cancel my subscription or downgrade to the free plan?
How do I cancel my account?
Can I upgrade my plan or buy more users after I purchased a subscription?
Do you have a free plan?
Can I get an account trial extension?
Do you provide other forms of billing and payment?
Pricing changes with the number of users
Can I have a discount?
Templates and Use Cases
Templates
ERP template structure
Customer Service Tickets Template
How to modify templates?
Dropbox Integration in Ragic
Use Cases
Reminder of min. inventory requirement
How to Apply Multiple Currencies In Your Ragic Sheet Design?
Key Concepts
How do I delete a sheet or tab?
Hotkeys in Ragic
Learning Ragic
Toggle between the listing and form pages in the design mode
Deleting a field
What's new in Ragic?
Using the Enter and Tab keys while entering data
Loading automatically saved drafts
What does Ragic mean?
Creating an Identification Field (Key Field)
How does full-text search work?
Actions on Multiple Fields
Adding a column to the listing page.
Glossary
Normal Process of Developing a Sheet
How do I undo changes to the design?
Looking for entries and field values
Deleting Entries
Adding new fields
Mobile Device
Does Ragic have a mobile app?
Creating / editing entries on mobile app
How to filter entries on the iOS App?
How to change the field order on form page for mobile App?
Information Security
Is my data secure?
Where does Ragic host?
Is there a way to download a database that we've created on Ragic?
How do I backup my data?
Account-Related
Changing your account e-mail
Changing your account name
Setting up a Custom Domain
Setting up a Custom Login Screen
Setting up a Custom Splash Screen
Setting up Custom Security Policies
Deleting your Ragic account
Adding your company logo to Ragic
How many users can be in my account?
Personal Settings
How do I change e-mail for a user?
Can I use my Google account (or other OpenID account) to sign up or sign in to Ragic?
Configuring Notification Settings
Features
Formulas
Nested conditional formulas
Why wasn't my edits to the formula reflected in the database records?
Automatic daily recalculation
Rounding numbers to the nearest two decimal points
Usage of the TEXT() formula
Getting string values before and after a specified character in Ragic
Why is TODAY() formula returning the wrong value?
Usage of the SPELLNUMBER formula
Automatically recalculate formulas after saving the record
Usage of the WEEKNUM() formula
Using "\" in Formulas
Why do two date fields with the format yyyy / mm / DD have a decimal point when they are subtracted by a formula?
How to set text to sentence case with formulas in Ragic?
How do I calculate the difference between two dates or times?
Can I use conditional formulas in the formula fields?
Using strings in formulas
Embedding on Website
How can I make the embedded form display static text descriptions?
What is the difference between the new and old version of "embedded database form"?
Get my external users to pull up a site and access a link on a form to upload documents.
How I can get embed Ragic sheets in an iframe?
Can I create databases and embed on my Weebly / Wix / Jimdo website?
How to create an autofill web form for users to fill out from an existing Ragic sheet?
How do I embed a single entry to a web page?
Barcode
Can I use a barcode or RFID reader to enter data in Ragic?
How to let users open the entry by scanning the QR code?
Linking Sheets
Referencing two sheets at once
Switch to a different version of an entry
Create a full entry in a linked subtable
Repopulating loaded fields from their source sheet for link & load
Updating a calculation in multiple versions without displaying constants in one copy
Entering data into linked fields
Automatically re-execute all sets of link & load after saving the record
Why "show references from existing sheets" says "no field linked to this form" while there are links in the subtable?
How can I load user information into certain fields?
Which features require triggering, and which don’t?
How do I add a new field from another existing duplicated sheet?
Usage of the Link & Load type Sheet Linking Option
Action Button
Adding action buttons "Download as Excel file" or "Printer Friendly" to your sheet.
Calculating a running balance in Ragic
Adding a button to formula recalculate a single record
Creating an action button for opening the printer friendly version of a sheet
Adding a button to formula recalculate all records in a sheet
How do I add frequently used tools as custom buttons?
Open different page with action button
How to prevent users from clicking the convert record button more than once?
E-mail
Sending out a reminder on a certain day of the week
E-mailing entries
Creating an entry from a received e-mail
Sending mass e-mail
Hiding e-mail history of the sheet
What is {{RECORD_ID}} in e-mail template and how does it work?
Can Ragic create alerts, reminders, schedules, email notifications etc?
Creating a custom automatic e-mail notification
Setting Reminders
Layout
Changing the number of entries in listing page
Styling field headers
Setting the title field for your sheet
Download custom banners
How to move subtable fields?
Hide assignment status
How do I create great looking forms?
How do I change the width or height of a row or column?
How do I change the layout of my web embed table views? ex. to make rows taller
BBCodes in Ragic
Moving and rearranging tabs and sheets
Setting form rules
Adding a default image on a form
Fields Displayed in the Listing Page
Approval
How to Use Formulas to Obtain and Determine the Value of the Approval Status Fields?
Can I add approval to the form?
Others
Integrating date fields in your Ragic database with your Calendar application
Formatting phone numbers to send SMS messages through Ragic
Custom date field formatting in Ragic
Hiding the left sidebar
Advanced full text search syntax (top search bar)
Copying database applications you built to another account
Right panel
How can I view all edits on one record?
How to make major design changes to live production systems
Manually editing the Field ID
Querying by using special parameters on the URL of your sheet
Restoring a sheet to the state in a saved backup
Creating a new account with the same sheet designs
Hiding fields from the left sidebar search tool
Creating a traffic light status indicator in Ragic
Viewing the history of a record
Previewing files on the right panel
How to turn off the fly-in panel?
How to copy / duplicate all sheets under a tab?
How to archive old entries?
How to send mass SMS through Ragic?
What is the SMS character limit?
How to prevent subtable row deletion?
How can I Mass Update Selection Field Values?
How do I enter default value information for my existing entries to a new field added to a sheet?
How to reset sequence number in subtable?
Generating last modification date & time of a specific field in the entry
How to set up a checkbox field as a radio button?
How do I query for empty values?
How to copy a sheet with data?
How to lock entry when criteria match?
How to pop up a warning but still allow saves when users input duplicate values?
What if I can’t write regular expression?
Will I be able to erase the current auto generated field so it starts at "1"?
How to set validation for a cell on how many characters inputted?
How do I create multiple contacts for one supplier / client / customer on a Ragic sheet?
How to add a longish paragraph text to a record?
How do I ensure that user fills in a field in certain language?
Can I store files, pictures, and videos on Ragic?
Mass editing entries through the listing page
Making a field read-only
How to search for data in a subtable
On-Premise
How do I configure / access the API on my on-premise server?
How do I configure SSL, mail server on my on-premise server?
How to update Ragic files on QNAP?
How to do a manual update on my on-premises installation?
My on-premises server won't start, error message: java.net.BindException: Address already in use: bind
Ragic On-premises update procedure 2020
Using SAML Protocol to Allow Your Users Log In to Ragic Using Single Sign-On With AD (Active Directory)
How do I configure LDAP or Active Directory integration on my on-premises server?
Can I get Ragic installed on my own servers?
For Developers
Math Objects supported in Ragic
Do you have integration with zapier?
Guide to server-side Javascript Workflow
How to remove the "Powered by Ragic" footer from an embedded sheet?
Adding or removing manual attributes to a field
How to use RequestBin to diagnose API call issues
Find out which process is using which port
How do I retrieve detailed user information with HTTP API?
How does Wordpress integration work?
Can I fetch data in Ragic with Java, C#, perl, PHP, RoR or other languages?
How do I use Ragic as a backend database for my Android or iOS app?
I want only few rows of data based on queries and not the full database to be returned in Json format
My curl HTTP API call always creates an empty row
Can I embed a sheet into my website or blog?
Can I issue SQL queries?
I would like to create a directory application on my Joomla / Drupal website
Can I link my SQL database and use Ragic?
Finding the field ID while using API
Where is the Server-side Javascript Workflow Module?
How do I create an HTML form that saves its data to a Ragic form?
Access Rights and Data Sharing
How to let non-SYSAdmins access Design Mode?
How to let other people see the data on my sheet?
Access rights for features
How do I add my team members to my database?
How do I set my database to be publicly viewable?
Can some fields be visible only for certain groups of users?
How do I set my database so that anyone can create entries?
External user management (accounts created before Sept. 2015)
Can I set entries to be viewed or edited only by certain users?
Locked Records
What's the difference between having your sheets public and setting external users?
How can I allow guests query and view the data without granting them access rights?
How to specify fields when using publish to the web?
Download filtered records in Excel, CSV, or printer friendly via URL
How can we get the entry/record URL?
How do I make things viewable only to certain people?
How to prevent "Admin" users from creating entries in a specific sheet?
How to manage access rights?
I want some of my users to only be able to view some of the records
How do I let other users in my account design new forms or edit form designs?
How can I add external users?
Levels of Access Rights Explained
Granting administration privileges to a user
Granting admin privileges for a certain user group on a specific sheet
Adding Internal Users
Troubleshooting
What happens when two users try to update the same entry?
Slow database connection troubleshooting
What happens when I try to save the same value with the unique setting checked?
Troubleshooting slow loading on the listing page
Unable to link grayed out field
Why can’t I delete a sheet or field?
Whitelisting Ragic email IPs to avoid messages not getting through
Cannot find suggested result in the full text search box
Conditional formatting doesn't work as expected.
List of browser extensions that's currently known to interfere with Ragic
I cannot see the sheets I created or any data entries in my database!
Customer Support Options
Restore accidental deletion
Import / Export
Importing into multiple selection fields
Creating a new Ragic sheet with your spreadsheet file
My import file might have duplicates. How do I prevent from importing everything twice?
Configuration of printer friendly version
How to import from the Excel file stored in OneDrive or Google Sheet?
Print documents with fixed title and page numbers on each page
How do I import a Google Sheet?
How to import from Excel or CSV into Ragic?
How do I migrate my existing spreadsheet Excel data into database?
Mass Update by Importing
Importing data to your existing subtables
Can I save my data as Excel or print it out?
Have dates to display in the correct format after importing
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Ragic Pricing
Applications
Keep in touch:
Blog
Facebook
YouTube
Ragic, Inc.
1-888-666-8037
Terms
Privacy
info@ragic.com
PERSONAL
Change Password
Language:
English
繁體中文
简体中文
日本語
español
Sign Out
RESOURCES
User Guide
Ragic Intro Slides
Developer API
Glossary
What's New?
1
IMPORTANT CONCEPTS
How to get started?
Listing & Form
Subtables
Formulas
Link & Load
Multiple Versions
Mass Editing
FAQ
✕