I have 2 tables. One table contains a list of...

[Glenn_Pearson]

I have 2 tables. One table contains a list of machines. Each machine has a status, for example AVAILABLE, ALLOCATED, IN USE, IN REPAIR. Each machine has a unique ID number.

The second table contains a list of jobs, and the machine type required for the job. The mechanics need to assign a machine, unique ID number, to each job.

If the mechanics assign the Unique ID number of a machine to a job, how can I trigger an update in the Machine table to change the status of that specific machine from AVAILABLE to ALLOCATED?

[Bellave_Jayaram]

You can use data change workflow

[Glenn_Pearson]

@Bellave_Jayaram

please elaborate/explain

[Lynn]

Hi Does your jobs table Ref the Machine table?

[Glenn_Pearson]

Yes, I did have a ref from the Machine ID field in the Jobs table to the Machine ID field in the Machines table. I also tried the data change workflow but failed to get the desired result

[Glenn_Pearson]

I jsut found this, and will try it help.appsheet.com - Changing Data from a Workflow Rule or Scheduled Report Changing Data from a Workflow Rule or Scheduled Report help.appsheet.com