Automatic flight log sorting

[daniele-athome]

It would be nice if it could be done in Google Sheets directly (automatically after every modification).

[daniele-athome]

https://webapps.stackexchange.com/questions/7211/how-can-i-make-some-data-on-a-google-sheets-auto-sorting

[daniele-athome]

• simple triggers don't work when changing sheet data via API
• installable triggers work but you need to use the onChange event (but it's an asynchronous call, so the app would have to sleep a random amount of time to let the trigger do its job)
• create a script that does the sorting and invoke it from the app (but script invocation can't be used with service account, it might be a bug: https://issuetracker.google.com/issues/36763096, however judging by the documentation you can't run scripts from service accounts https://developers.google.com/apps-script/api/how-tos/execute 🤔)

API execution: https://developers.google.com/apps-script/api/how-tos/execute

[daniele-athome]

Another alternative could be using a read-only sheet that queries another write-only sheet, sorting it:

https://webapps.stackexchange.com/a/69385/96655

=QUERY(A1:C3,"SELECT * ORDER BY C")  

[daniele-athome]

Implemented as a Google Apps Script automated trigger on sheet change. Source code will be collected when I will work on #32.