With the field ID, the system can distinguish fields even if your fields have the same names. In Ragic, action buttons, email templates, mail merge, and many other tools support using field ID as the parameter.
Only SYSAdmins can view the Field ID of fields. There are two methods:
Method 1: Right-click on a field to enter its Field Info page, and you’ll find its field ID in the first row.
Method 2: Enter the design mode, click a field, and you’ll find its field ID under its field name.
In some cases, different fields on different sheets may share the same field ID. For example, when you build sheet relationships using multiple versions or new sheet from subtable, some fields will be in sync because they share the same field ID. In this situation, when you update a field on one sheet, it will also reflect on the respective field on the other related sheet or multiple versions sheet.
Generally, the field ID of fields added by users would start with 1000. For fields in template sheets, the field ID would start with 2000 for English templates or 3000 for Chinese templates.
In the design mode, you can double-click on the grey “field ID” text to change a field’s field ID. However, unless there is a very special reason, the field ID should not be modified because it is an important reference tool. On the other hand, fields should not share the same field ID unless they are the same field on different related sheets or multiple versions sheets. To prevent unexpected errors in your database, we suggest not modifying the field ID unless under the guidance of Ragic Support or Ragic documents.