Iโm making progress on my inspection app, but am stuck on trying to set up a behavior. I have individual tables for each department where inspections are recorded. I also have a table that lists the departments. In the department table I have a column โLast Inspectionโ. When a record is added to the inspection table for a department I would like the corresponding โLast Inspectionโ date updated in the departments table. Is there a way to do this?
Sure!
For the departments table, create an action that updates the departmentโs Last Inspection column.
In the inspections table, create an action that invokes the action (1) for the appropriate department.
Set the action (2) as the Form Saved event action of the inspection tableโs form view.
Iโm sorry, can you be more specific? Iโm new.
1, What should the value you be? NOW() ?
Yes, I read that article. But I still need help, thatโs why Iโm posting here. Not because Iโm lonely and looking to strike up conversation with random strangers on the Appsheet forum.
โFor the departments table, create an action that updates the departmentโs Last Inspection column.โ How do I point it to the specific row I want updated?
โIn the inspections table, create an action that invokes the action (1) for the appropriate department.โ
Why is there any action to be taken on the inspection table?
OK, I got it. This is the article that explains it:
Hi @Mike_Wrob If you still need help, I posted a demo app in my portfolio Trucks WF . Full instructions are i the info tab. You may copy it if you would like to check it out.
Hi @Lynn, this is very helpful thank you!
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |