Problem: Form Submission Failure Despite Extensive Troubleshooting

[dayalmazumdar]

I am facing a persistent issue with form submission failure in my AppSheet app, despite trying various troubleshooting steps. The app is designed to manage budget entries with features such as Business ID, Campus ID, Account ID, Project ID, and a Final Allocated Budget that includes Initial Allocated Budget and Budget Adjustments.

App Background:

• The app was built recently and interacts with a Google Sheet to manage budget data.
• Key tables: Business Budget and Budget Change History.
• Columns include: Business ID, Campus ID, Account ID, Project ID, Initial Allocated Budget, Budget Adjustments, and Final Allocated Budget (calculated field).

Problem Summary:

Despite multiple attempts, I am unable to successfully submit the form in the app. No error messages are shown to the user in the interface, and the submission simply fails. There is no relevant information in the Audit History either, making the issue difficult to track down.

Steps Taken to Troubleshoot:

1. Validation and Formula Review:

• Checked all "Valid If," "Required If," and "Editable If" conditions for hidden constraints in the key columns (Business ID, Campus ID, Account ID, etc.). All conditions were either removed or simplified.
• The Final Allocated Budget formula was temporarily removed, and we tested manual input for the field:
  appsheet

  Copy code

  [Initial Allocated Budget] + IF(ISNOTBLANK([Budget Adjustments]), [Budget Adjustments], 0)
  Even after removing the formula, submission failed.

2. Table Structure Issues:

• Initially, there was a column mismatch between the Google Sheet and the AppSheet table schema, which we resolved by regenerating the table structure. The mismatch error was corrected, but the form still did not submit.

3. Bots and Workflows:

• Disabled all bots and workflows that might be interfering with form submission. Even with all automation turned off, the form submission still failed.

4. Testing Simpler Form Submissions:

• Created a simplified form view with only the key fields (Business ID, Campus ID, Account ID, Project ID, Budget Adjustments) and removed complex dependencies. This was done to check whether complexity was causing the issue, but the form still could not be submitted.
• Tested form submission with entirely new data (new Business ID, Campus ID, etc.), but it still failed.

5. Sync and Cache Issues:

• Performed a full sync of the app to ensure all data was properly synchronized, and there were no sync errors.
• Tried to force the app to sync with full data, but the issue persisted.

6. Google Sheet Integrity Check:

• Checked the underlying Google Sheet for locked cells, formula errors, or hidden columns, but no issues were found.
• Permissions and data types between the Google Sheet and AppSheet were verified, and no data integrity issues were detected.

7. Column Type and Key Review:

• Verified that all column types (e.g., text, number, ref) matched between the Google Sheet and AppSheet.
• Confirmed that each row had a unique key (using UNIQUEID()), and no duplicate row keys were found.

Additional Details:

• I reverted the app to an earlier version that was known to work, but the issue persisted in the older version as well.
• No relevant errors are appearing in the Audit History or error logs, making it difficult to pinpoint the exact cause.

Request:

I need help diagnosing this issue further, as I have gone through extensive troubleshooting steps without success. Are there any deeper diagnostics or potential solutions that I may have overlooked? I would appreciate any guidance on resolving this persistent form submission failure.

[WillowMobileSys]

---

@dayalmazumdar wrote:

I am unable to successfully submit the form in the app. No error messages are shown to the user in the interface, and the submission simply fails.

---

We need to understand what this means.  How do you know it fails if no errors are shown?  Do you mean that you tap Save and all seems ok but no row appears in the datasource?  If so, any possibility you are looking at the wrong datasource??

Can you show, through video or images, what you are seeing?

[dayalmazumdar]

Thank you for your response. I appreciate your willingness to help.

To clarify the issue in more detail:

What I’m Seeing When I Tap “Save”:

• When I tap the Save button on the form, it appears to process normally with no visible errors or warning messages in any field except for the top of the table. I have attached the screenshot of the error message in this reply.

Correct Datasource:

• I have verified that I’m looking at the correct Google Sheet, which is linked to the app. All syncing and data source paths have been confirmed multiple times.
• Additionally, I have checked the AppSheet schema and regenerated the column structure to match the Google Sheet, resolving any column mismatch errors that had initially occurred. After resolving this, the form still doesn’t submit correctly.

No Errors in Audit History:

• One key point is that nothing shows up in the Audit History as a failure or error after attempting to submit the form. This makes it hard to understand why the data isn’t reaching the Google Sheet, as there is no feedback from AppSheet indicating what went wrong.

Steps Already Taken:

• I’ve simplified the form by removing complex formulas and validation rules, temporarily disabled all automation (bots, workflows), and even tried submitting with only basic fields (e.g., Business ID, Campus ID, Account ID, Project ID, Budget Adjustments) to isolate the issue.
• I also manually checked the Google Sheet for any potential issues like locked cells, hidden columns, or permission errors, but everything seems fine.

Testing with New Data:

• I have tested the form submission using completely new data (e.g., a new Business ID, new Campus ID, etc.), but the form still does not save the data, and no row appears in the Google Sheet.

A screenshot of the error message is attached below.

Thanks again for your help!

[Steve]

You are attempting to add a new row that has the same key column value of a row that is already in the table. You cannot do that.