I have a parent table that contains ‘CarMeetings’ information.
I have a child table ‘Tracking’ that is used to register (based on DeviceID) if people will attend the meetings.
Users do not have to login.
See here some Meetings in the App.
See these meetings also in the Sheet in the table “CarMeetings”.
There is a button in the list or when a user opens a meeting saying “I will attent”.
It’s a Dutch app, so “Ik zal er zijn” means “I will be there”.
It is button number 3.
When de user clicks that button, a record will be made in the ‘Tracking’ table.
That record has a generated unique-ID for a key and it saves the key of the parent record and the DeviceID of the user. I do that concatenated with " / " in between, and also in separate columns.
There is a column ‘Present’ as well, which might be useful or not.
The button changes to “Ik kom toch niet” which loosely translates to “I changed my mind and decided not to attend”.
THE ISSUE
And here is my issue…because when the user clicks that button, only THAT record, containing the parent key and the user DeviceID should be removed OR the column ‘Present’ should be updated to “FALSE”.
There is an action to ‘Add an new row to another table using values from this row’.
I have used that to create the new record…but…
There is no action to 'Delete a row from another table using values from this row’.
There is no action to ‘Set values of some columns in a row in another table’.
I can use the action 'Data: Delete this row’, but I do not want to delete the row in the ‘CarMeetings’ table. I need to delete the record in the ‘Tracking’ table.
I can create this delete-action or update-action in the ‘Tracking’ table and that is what I did. (I tried both) So I created an action in the ‘CarMeetings’ table named ‘Update tracking with No’ using: ‘Data: execute an action on a set of rows’. It calls the action in the ‘Tracking’ table.
As I mentioned, I created in the table ‘Tracking’ I created an action ‘I will NOT attent’
I am a bit free wheeling here.
I tried to delete the record here, as you can see, but that does not work because ALL records in the ‘Tracking’ table will be deleted.
I tried: 'Data: set the values of some columns in this row’, but then ALL records are updated.
In both cases I have no idea how to select only the ONE record that needs to be updated or deleted.
I have searched the forum and YouTube and TickTok and I asked ChatGPT and Bard and so on, and so on…but I only find stories from people that have ‘some kind of similar issue’ but never exactly what I need.
Please help?
