while Glide is great, one issue is the synchronization time between the app & GSheet.
An approach is to use the ‘data editor’, but (1) not all can be done on it, (2) in particular for non-experts (ex. me!), (3) and sometimes the answer time still exists.
From a UX point of view, for any fields with answer time (ex. use of a formula in GSheet), would it be an idea to have a ‘running’ icon which indicates the user that information is ‘arriving’?
This is an indirect mean to avoid her/him to clic/select/enter other fields which, sometimes, are engendering weird behaviors in the screen.