Solved: Sync queue. How to change? - Page 2

A_S_Pysarenko · 02-06-2025 11:53 AM

Hi

I have MySQL DB

Part of structure:

When creating a Request directly from his form, I add both the new Partner and the Contact Person associated with him, then an error occurs when trying to synchronize.

Judging by the json update, AppSheet first tries to write the Contacts table, and only after that Partners, and of course it fails, because it does not find the necessary key (the partner has not yet been created, and we are trying to write his contact person)

Question - on what principle does AppSheet build the sync queue and is it possible to somehow configure this order to avoid such an error?

AlexM

Hi,

What if you change the flow?
Instead of adding the Partner, add the Contact and under the partner_id field you can select an existing one or create a new one.
Check if you get the error by using the Contact_Form.

If you want to add a new partner with multiple contacts, you could have an action to create a new record (just [id]) and open that record in a detail view (skip the form view).
Have all columns that needs to to be filled as quick edit, and then another action to add contacts.

Not sure about the first option but last one would definitely solve the problem.

View solution in original post