Forum Discussion
Sorting a Form-Generated Table Automatically
Alternatively I'd do not touch updated by Forms table but use for the reporting another range/table taking data from source. As variant
=SORTBY(Table1[#Data],Table1[Date],-1)
SergeiBaklan thanks for your response! Sortby results in the same issue, that I need to sort the original table since the contents on the sorted data need to be editable.
I see. To change behavior of the agent which adds rows to table is not possible, it always adds new rows to the end of the table and do nothing more.
And I'm not sure if Office Script could be triggered by adding new row to the table, but who knows. Another issue here is conflict resolution if agent, script and person who edits work simultaneously.
In general it depends what and how often to edit. My usual scenario is to Power Query such forms table, combine with our data sources, transform and clean data and return back to user in another file. Max for manual editing is to add column returned by query, for example for comments, it is syncing with known technique by querying return by query table with itself and merging inside to return result.
Such approach has limitations, but could be used in some scenarios.