How Task Forms Handles Deleted Parent Rows

Symptoms: A parent row (e.g., "Phase 1") was deleted from Smartsheet, but it still appears in the form dropdown for some users, causing errors on submission. Or, it has disappeared entirely, and you need to know where the existing child rows went and how to recover the structure.

Technical Explanation

SmartSyncApp's Task Forms performs a "Validation Scan" every time the form interface is loaded. If a row ID no longer exists in Smartsheet, its corresponding reference name is stripped from the cached list. This prevents "Orphaned Submissions" where a child row is created with no parent to attach to, which would otherwise clutter your sheet and break reports.

Root Causes and Fixes

1. Stale Browser Content: If a user had the form open in a browser tab *before* the parent was deleted in Smartsheet, the dropdown will still show the old value. Fix: Instruct the user to refresh the page. This triggers a fresh scan of the Smartsheet structure and updates the parent list.
2. Accidental Deletion Recovery: If your parent row was deleted, any child rows it previously had will likely become "Top Level" rows at the bottom of the sheet (depending on Smartsheet's native cleanup behavior). Fix: Use the "Undo" button or "Activity Log" in Smartsheet to restore the parent and its hierarchy immediately.
3. Orphan Row Prevention: SmartSyncApp will NEVER create a row if the target parent is missing at the moment of submission. The user will receive an error. This protects your sheet from becoming a disorganized list of floating entries that are excluded from roll-up calculations.

Advanced Resolution Steps

• Update References: If you intentionally deleted a parent and want to replace it with a new one, ensure the new row has a unique reference value in your lookup column and refresh the SmartSyncApp tool configuration.
• Check Archive Sheets: If you moved the parent to an archive sheet, Task Forms can no longer see it because it targets specific Sheet IDs. You must configure a new form for the archive sheet if you wish to continue collecting data under those archived headers.
• Data Mesh/Bridge Interference: If you use external tools to move rows, ensure they aren't deleting and recreating rows, as this changes the Row ID and breaks the Task Forms reference.

Proactive Prevention

Use Conditional Logic in your Smartsheet (e.g., a checkbox for "Archive") and configure Task Forms to only show parents where Archive is unchecked. This way, you can "Hide" parents from the form dropdown without deleting them from your project history, ensuring both archival integrity and form reliability for your field teams.