Knowledge Base
Pricing
About
Home
Free sign up
How can we help?
Full Site Search
Ragic Plans and Billing
I have a lot of users outside my company that use our DB once in a while, how can I save on user licenses?
What's the difference between Lite and Professional version?
How do I upgrade or start my subscription?
Will I lose free trial days if I subscribe early?
What is upload storage? And What happens if I reach storage limit?
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 switching plan or the number of users
Can I have a discount?
If a user is in different accounts, how is pricing calculated?
Do reports count as sheets?
Account Billing Information and History
What’s inside the Ragic Enterprise Plan?
If I don’t need to use my Ragic database temporarily, can I cancel my subscription or downgrade to the free plan?
How to obtain a receipt from Stripe or an invoice from Ragic after making a payment? Can I know the format in advance?
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
Can Ragic be used for e-commerce? Such as a shopping cart or membership system?
Key Concepts
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
Hotkeys in Ragic
Learning Ragic
Toggle between the listing and form pages in the design mode
What does Ragic mean?
Deleting a field
What's new in Ragic?
Using the Enter and Tab keys while entering data
Loading automatically saved drafts
Creating an Identification Field (Key Field)
How does full-text search work?
Actions on Multiple Fields
What is Field ID?
Can I change the URL of the sheet?
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
How do I backup my data?
Security at Ragic
Is there a way to download a database that we've created on Ragic?
Where does Ragic host?
What third party Subprocessors does Ragic use to provide service?
Account-Related
How do you change a user’s email address?
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
Can I use my Google account (or other OpenID account) to sign up or sign in to Ragic?
Features
Formulas
How do I calculate the difference between two dates or times?
Can I use conditional formulas in the formula fields?
Using strings in 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 to make formulas in numeric fields return as empty values instead of 0 ?
Embedding
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?
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"?
How to embed content from other websites on your account homepage?
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
Can I link the data between different forms?
How do I add a new field from another existing duplicated sheet?
Usage of the Link & Load type Sheet Linking Option
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?
Action Button
Adding action buttons "Download as Excel file", "Download as PDF 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
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?
How to mark an entry as "Converted" ?
How to create relations when an entry is converted?
E-mail
Can Ragic create alerts, reminders, schedules, email notifications etc?
Creating a custom automatic e-mail notification
Setting Reminders
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?
How to Set Your Google Account as Your Ragic Database’s SMTP Server?
Layout
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
Setting form rules
Adding a default image on a form
Fields Displayed in the Listing Page
Changing the number of entries in listing page
Styling field headers
How do I create great looking forms?
Setting the title field for your sheet
Download custom banners
How to move subtable fields?
Hide assignment status
Approval
Can I add approval to the form?
How to Use Formulas to Obtain and Determine the Value of the Approval Status Fields?
How to make a field editable or be set with not empty when a certain approval step is reached
How to unlock and modify records that have been approved?
Others
Can I store files, pictures, and videos on Ragic?
How do I enter default value information for my existing entries to a new field added to a sheet?
How do I query for empty values?
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?
Mass editing entries through the listing page
Making a field read-only
How to search for data in a subtable
Integrating date fields in your Ragic database with your Calendar application
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
Translating Ragic into your Own Language
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 prevent subtable row deletion?
How can I Mass Update Selection Field Values?
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 to copy a sheet with data?
How to lock entry when criteria match?
What if I can’t write regular expression?
How to create and manage test environments?
Set fields to "Not Empty" when criteria matched.
How to pop up a warning but still allow saves when users input duplicate values?
On-Premise
Can I get Ragic installed on my own servers?
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
How do I configure LDAP or Active Directory integration on my on-premises server?
How to update system default sheets in your local environment?
How to to replace the SSL certificate?
Mail Merge is Slow on On-premise Databases
For Developers
Can I embed a sheet into my website or blog?
How do I create an HTML form that saves its data to a Ragic form?
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 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?
Math Objects supported in Ragic
Guide to server-side Javascript Workflow
How to remove the "Powered by Ragic" footer from an embedded sheet?
How to use RequestBin to diagnose API call issues
Find out which process is using which port
Using SAML Protocol to Allow Your Users Log In to Ragic Using Single Sign-On With AD (Active Directory)
Add Ragic as a Non-Gallery App in Azure Active Directory and Configure SAML SSO Login
Add Ragic as a app in AWS IAM Identity Center and set up SAML SSO login
Other SAML Attributes
Add Ragic as an app in Okta and set up SAML SSO login
Access Rights and Data Sharing
How to let other people see the data on my sheet?
How do I add my team members to my database?
Can some fields be visible only for certain groups of users?
Can I set entries to be viewed or edited only by certain users?
How do I make things viewable only to certain people?
How to set up the visibility of certain records for each individual?
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
How to let non-SYSAdmins access Design Mode?
Access rights for features
How do I set my database to be publicly viewable?
How do I set my database so that anyone can create entries?
External user management (accounts created before Sept. 2015)
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 to prevent "Admin" users from creating entries in a specific sheet?
How to manage access rights?
Troubleshooting
What happens when two users try to update the same entry?
Cannot find suggested result in the full text search box
I cannot see the sheets I created or any data entries in my database!
Customer Support Options
Restore accidental deletion
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
Conditional formatting doesn't work as expected.
List of browser extensions that's currently known to interfere with Ragic
If you mistakenly imported or modified multiple records, how can you fix it?
How to check the status of your Ragic server?
How to restore manually entered field values that were lost due to triggering Link and Load sync or formula recalculation?
How can I ensure that the entries in the subtable extend downward without disrupting the layout of the regular fields below the subtable?
Import / Export
How to import from Excel or CSV into Ragic?
Can I save my data as Excel or print it out?
How do I migrate my existing spreadsheet Excel data into database?
Mass Update by Importing
Importing data to your existing subtables
Have dates to display in the correct format after importing
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 Display the First Zeroes of Phone Numbers and IDs of Exported CSV Files in Excel?
Why does the date format in the ROC date format from Ragic forms display as AD date format when exported to Excel?
Can I set up additional settings with Mail Merge as I do with Action Buttons?
Software Integration
Do you have integration with zapier?
How to create a click-to-chat link to messaging apps?
Can I issue SQL queries?
Ragic does not support direct SQL access.
But you can issue your queries via our
HTTP API
to integrate Ragic with your own applications.
Top of Page
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
✕