- 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
- 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
- Information Security
- 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
- 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
- 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?
- Formulas
- 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
ERP template structure
There are many sheets in the ERP template that can be installed into your account from Start tab > Install Templates > ERP.
Here is a flowchart showing how these sheets are linked to each other.
