I have this table...
It is possible that someone may enter dates out of order. Is there a way to have the rows automatically put in chronological order? If so, how?
I have this table...
It is possible that someone may enter dates out of order. Is there a way to have the rows automatically put in chronological order? If so, how?
Put in order when? As they are entering them? When the form it submitted? Is the table information that is pulled from a data source when the form is opened?
Hi Mary Lou, good to hear from you.
Our company deployed a custom timesheet solution for our own usage with Forms that handles this sort of thing. Feel free to reach out to us if you'd like a tour of what we put together.
In direct answer to your question, Jennifer is on a good path when asking about the data source since when data is read from a lookup it can be easily sorted there. Is there a requirement that the data be resorted before submitting? If not, the data from the table could be written to a database then another copy of the form could be used when presented to the next user that requires the data to be sorted correctly and a lookup used on that form to retrieve the stored data and resorted at that time. That's the "out of the box" solution I've got for you. It's likely that with some advanced Javascript you could code the reading and resorting of all the table data but I am not personally a Javascript expert so would cede the floor to coding experts. I usually try to stay away from custom code as much as possible to avoid the extra work later of managing the custom code through upgrades, etc.