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

(Glenn Pearson) #1

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) #2

You can use data change workflow

(Glenn Pearson) #3

@Bellave_Jayaram

please elaborate/explain

#4

Hi Does your jobs table Ref the Machine table?

(Glenn Pearson) #5

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) #6

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