How to make an action that use columns values to search and update another columns table

almoonds
Participant I

Hello community,
I am trying to create an app that records the entry and exit of visitors in a building. At the entrance there is a tablet that scans some id of the visitor and registers the entrance, at the exit the user scans his id again and the app registers the exit.
I have three tables: buildings, visitors, entrances.
The diagram should look like this:
at the entrance:

  1. from the access form scan the visitorโ€™s id, if the id is already present write the entry time in the access table, if the id is not present ask to fill in the user data.
    at the exit:
  2. from the visitor id scan access form (if the visitor has entered it means that he is already present in the visitors table and that in the access table there is already a record with an entrance exit).
    SEARCH in the access table and update the relative record with the exit time (so I can have a virtual column that calculates the time of presence).

Now, with part 1) I have no problems, but it is part 2) that puts me in crisis because I donโ€™t know how to implement the โ€œlook in the access table and update the record to write the exit timeโ€.

Can anyone give me some idea or indication?

0 1 204
1 REPLY 1

I think you should use the following action:

(I mean the โ€œData: execute an action of a set of rowsโ€ action)

Even if you only want the action to be done on one record, this is the one to use.

The โ€œsearchingโ€ for the records to act upon is done with the โ€œReferenced Rowsโ€ part of the action.

Top Labels in this Space