Hi you all, I have a table "jobs" and anothe...

(Alex Meraru) #1

Hi you all,

I have a table “jobs” and another one “stops” One job can have multiple stops. Both the job and the stops table have a status column. I want the job’s status to be automated in relation to stops status.

example: All the stops have the status " Planned"

  • I want the job’s status to be “Planned” When I change the first stop to active, the job’s status to be active too.

just to test the functionality, I tried it this way:

=IF(lookup(“JobNo”,Stops,JobNo,Status)=“2.Active”,“2.Active”,“Unkown”)

What am I doing wrong?

Thank you!

(Bellave Jayaram) #2

Try IFS(IN(“2.Active”,[Related Stops][Status]), “2.Active”)

(Alex Meraru) #3

@Bellave_Jayaram thank you! It is working but to update the “job” record I need to edit it first and save it. Is this the only way?

(Bellave Jayaram) #4

The other way is to use data change workflow described here - http://help.appsheet.com/behavior/workflow-changing-data/changing-data-from-a-workflow-rule-or-scheduled-report

(Alex Meraru) #5

You’re my new hero! :wink:

(Aleksi Alkio) #6

Another solution is using virtual column for this purpose.

(Alex Meraru) #7

I’m not good with virtual columns yet.

Good to know, I will try to get better with it.

Thank you!!