I can’t figure out why Auto Save on my form is doing nothing. This is a simple system generated form that has 3 fields: a time stamp that has initial value set to NOW(), a Ref field that enters the ID of a person from a master person table, and an Item field that is a pull-down based on a list of items. The underlying table also has a Type column that is set to a fixed text value in the Auto Compute App Formula; this is not on the form.
The form order is TimeStamp, Person ID, Item. I will eventually fill Item using a HID bar scanner, but for now am testing with manual entry. I have verified Auto Save is on.
When I click the Add+ button to open the form and leave the TimeStamp value (current time), click on the Person ID field and select one of the items in the list, then click on the Item field (last one on form) and select one of its values - nothing happens. Manually clicking Save works, but I want the behavior to automatically save the form after this last field is populated.
Using AI searches yields no help, just tells me to make sure Auto Save is on and the triggering field should be the bottom most - both are true. Any other things might affect it - like perhaps the form can’t be one of the system generated forms? Thanks!
I just noticed in a reply to an older post (suggested by AI) a note like “the one editable field must be the last one.” Does that mean there must be one and only one editable field in the form?
I made them all required. It still doesn’t do anything after the last field is populated. The Enter key doesn’t do anything either, if it is supposed to. I have no idea how to debug this.
OK - just made some progress. The last field on the form (Item’s ID) had a formula in the Valid If attribute like “ItemTable[ItemLabel]”. This had the desired effect of limiting inputs to valid items (there are about 20 in the list) and also made the input field on the form a pull-down. Apparently selecting a value from that pull-down does not trigger the action to auto-save. I removed that validity formula and it now works to auto-save. Now I have to experiment to see if I can find a way to limit input to valid values and also enable auto-save.
If Google developers read these posts, the engine (“compiler”?) seems like it should recognize the incompatibility of the validity check (or the types of validity checks) and the auto-save setting on the form and flag it with one of those yellow icons.
