Update automaticaly 1 table with record from other table without API

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

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.

5 Likes

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

2 Likes

Great, glad you found it useful.

1 Like