I’m currently using the MAXROW(Data, Timestamp) formula in a ref. to prefill some form fields with the last entry in the table.
Can someone please help me come up with a formula to only use the last entry within a certain time constraint?
For example if the last table entry is older than an hour, I don’t want the form fields prefilled?
any suggestions on how my INITIAL VALUE form should be to achieve this?