Delete min row from another table

AppSheet AppSheet Q&A
1

I am looking to have an action to delete the min row in another table that matches the criteria using data from the originating row.

For example:

Table A - large data-set of read-only data (Where the action will be invoked from a button)
has a column called “Trial ID”

Table B - has multiple rows with the same Trial ID from Table A

I would like to have an action button in Table A that will delete just one row (min row) from Table B (checking a DateTime column called “TimeStamp”) in Table B where Trial ID = Trial ID.

Is this possible?

Thanks!

2

Use a LIST(MINROW(…)) expression in an Action of type “execute an action on a set of rows”

https://www.appsheet.com/samples/This-app-shows-how-to-use-reference-actions?appGuidString=e76d2e73-3d26-475c-a8f8-9911f5015920

3 Likes