Reference Field Selection for Smart Form

The reference field is the column Smart Form uses to identify which row a user wants to update. SmartSyncApp lets you designate any text or number column as the reference field, giving you flexibility to match your existing data model.

How It Works

During Smart Form setup, you select the reference column from the available columns in your Smartsheet sheet. When a user opens the form, they enter a value into the reference field. SmartSyncApp searches the designated column for an exact match. If found, the form loads that row's data. If not found, the user receives a clear error message.

Common Reference Field Examples

• Employee ID for HR forms
• Ticket Number for support workflows
• Order ID for fulfillment tracking
• Vendor Code for supplier management
• Student ID for educational institutions
• Asset Tag for equipment tracking

Key Benefits

• Works with any unique text or number column in your sheet.
• Exact match lookup prevents ambiguity in large datasets.
• Users are guided to enter the correct value, reducing errors.
• No changes needed to your existing Smartsheet column structure.

Best Practices

• Choose a column with truly unique values. If duplicate values exist, the form may return the wrong row.
• Use short, memorable identifiers that users can easily recall or look up.
• Add validation to the reference column in Smartsheet to prevent duplicates at the source.