Update automaticaly 1 table with record from other table without API

[pascal_s]

Hello

I need to make a Visitor Log for my company therefor i must manage Badge and Name of the visitor

For this I have 2 Table : Badge & Registry.

In registry I use badge as REF to drop-down al Badge number present in Table BADGE.

My problem is as follow.

I Visitor use badge Number 10 .

I make a filter in badget field that show only the Available Badge Numbers. the filter in VALID IF is
SELECT(Badge[Codice Badge], [Stato]=“Available” )

This badge number is written in REGISTRY Table .I use a drop-down list (from badge table)

Question:

How can I write in BADGE TABLE that the Badge 10 is in field STATE “IN USE” as soon a save the record?

When the visitor Exit the company I call the row in REGISTRY to write the Exit time.

Question:

How can I update the field STATE in Badge table “AVAILABLE” as soon i save the record?

Thanks.

Screenshots

Badge Form
help for changing the field STATE with IN USE

[Lynn · Accepted solution]

Hi @pascal_s
If you have a look at the Trucks W/F app in my portfolio you may get some idea how to do this with a change data workflow.
https://www.appsheet.com/portfolio/129805
Full instructions are in a doc here.

docs.google.com

TrucksWorkflowInstructions

Shared: TrucksWorkflowInstructions Workflows are used to show drivers with jobs as "Assigned" and also the Truck they are assigned to. When the Job is completed the Assigned column is returned to blank along with the Truck column. Changing Data in...

[pascal_s]

look perfect and test it , Its Works:) great job
many thanks

[Lynn]

Great, glad you found it useful.