Calculated Result Is Not Displayed
If calculated result is not displayed, possible causes are as follows.
- You later added or edited the Calculated field but did not update the record.
- You did not specify a field of correct field type.
Refer to the following topics on how to solve these problems.
You Added or Edited the Calculated Field Later but Did Not Update the Record
If you add Calculated field or change formula after creating a record, such setting is not reflected in the existing record. You need to update the record so that formula setting is reflected in that record.
Follow one of the following procedures to update the record.
Update Records One By One in the Record Details Screen
For detailed steps, see the "Editing Records" page.
Exporting and Importing a CSV File to Bulk Update Records
First, export record data to a CSV file.
Open the app.
Click the option icon on the upper right of the screen, and then click Export to File.
Select "Include header row".
Specify the Record number field and a field of your choice as items to export.
Click the setting icon on the upper right of the field name, and then click Delete for unnecessary fields.
Click Export on the upper left of the screen.
Click the file name in the "Exported Files Ready for Download" section and save it.
You can also refer to the following page regarding file export.
Exporting Data to a File
Then, import the CSV file.
Open the app.
Click the option icon on the upper right of the screen, and then click Import from File.
Click Browse and select the CSV file.
When you are prompted with "Select Data Scope" (First row is header or data), select Yes.
Associate the fields in the app with the columns in the file.
Example setting: * Specify "(None)" for fields that are not updated.
* If you select "Key to Bulk Update" for the Record number field, record of which number matches is overwritten.
Click "Import" on the upper left side of the screen.
You can also refer to the following pages regarding file import.
Create/Update Records in Bulk: Importing a File
Creating and Updating Records Including Tables in Bulk
You Did Not Specify a Field of Correct Field Type
If you set a formula to concatenate strings in the Calculated field, #CONVERT! error is displayed.
If you want to concatenate strings, you need to set a formula in the Text field.
You need to add a field of correct field type again.
You can also refer to the following page regarding the way to fix errors.
Errors Which Are Displayed for Formulas