Why Didn’t My Data Save After I Entered It?

Whether you enter data manually or input it via formulas, Link & Load, Convert Records, or import, you might encounter issues like:

"I filled in a cell, but after saving, the field remains empty."

"I imported an Excel file to create a new sheet; the sheet was created successfully, but no data appears."

"My Excel file has complete data, so why can’t a specific field’s value be imported correctly?"

If you experience these problems, first check the following common causes:

Field Type Issues

Check the Field Type or Fields Formatting set for the field that didn’t save data. If the entered value doesn’t match the Field Type, the system may fail to save it.

For example, if a field is set as Image Upload, File Upload, or Date but you enter text, the system cannot save the value correctly.

This issue is rare since fields default to Free Text, which accepts any format. However, if you accidentally change a Field Type to a restricted format (e.g., number, date, or file/image upload) during sheet design or testing and enter data that doesn’t match, the value won’t save.

Selection and Select From Other Sheet Fields

Another common issue involves Selection-Type fields. If a Selection field has options like A, B, and C, users can only choose from those predefined options.

Although Selection fields support "typing to search (autocomplete)", manually entering "D" or attempting to convert "D" into the field won’t work—since "D" isn’t on the list, the system won’t save it.

The same applies to Select From Other Sheet fields. For example, if the "Customer ID" field in your "Orders" sheet is linked to "Customer ID" values 1–10 in the "Customers" sheet, entering "11" won’t work because customer "11" doesn’t exist.

Note: If "Allow User to Add New Option"s is enabled for a Selection field, users can add new options by entering values not in the list.

For Select From Other Sheet fields, users with the proper access rights can add new records directly in the popup from the linked sheet.

If this process isn’t followed, entering values not in the option list will not be saved.

Validation Issues

If a field has Validation rules set, the system will block saving if the input doesn't meet the criteria. Check the field’s settings or review the error message shown during saving to identify the issue.