- 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?
- 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 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?
- Templates and Use Cases
- Templates
- 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?
- 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?
- 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
- BBCodes in Ragic
- 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.
- 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?
- 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
Custom date field formatting in Ragic
You can change the formatting in Ragic for most field types, including date fields.
If none of the date formats fit your requirements, you can write your own formatting with the table below:
| Field | Full Form | Short Form |
| Year | yyyy (4 digits) | yy (2 digits), y (2 or 4 digits) |
| Month | MMMM (full name Ex. January), MMM (abbr. Ex. Jan) | MM (2 digits), M (1 or 2 digits) |
| Day of Month | dd (2 digits) | d (1 or 2 digits) |
| Day of Week | EEEE (name) | E (abbr.) |
| Hour (1-12) | hh (2 digits) | h (1 or 2 digits) |
| Hour (0-23) | HH (2 digits) | H (1 or 2 digits) |
| Hour (0-11) | KK | K (1 or 2 digits) |
| Hour (1-24) | kk (2 digits) | k (1 or 2 digits) |
| Minute | mm (2 digits) | m (1 or 2 digits) |
| Second | ss (2 digits) | s (1 or 2 digits) |
| AM/PM | a |