I think I have uncovered an issue related to submission update timing that could be fatal to certain apps. I will try to explain my data hierarchy
- I have a sheet of patients
- I have a sheet of episodes which is related to “parent” patient by the patient’s email
- I have a sheet of goals which is related to “parent” episode by the episode’s row id
Within the app it is possible to create a patient, then add an episode to them, then add a goal to the episode. These three “adds” are done as three distinct submissions i.e. I add a patient, then open their details and add an episode, then open its details and add a goal.
In each case I use column components from the parent to ensure that the parent-child links are maintained correctly.
ISSUE: It seems that if I add the patient, then an episode, then a goal, quite quickly after each other then in some cases the values from the parent column (required for the linkage) do not get submitted. It’s as if there may be a delay for Glide to submit these values. I am surprised since all sheet updates are taking place in Glide so there should be no delays related to Google Sheets?
I have a degree of urgency here as we are supposed to be rolling out a customer pilot on Monday. Therefore any and all help greatly appreciated.