I have a timecard/vehicle inspection app with these 2 tables:
Table 1- Timecards
Table 2 - Vehicle Inspection (nested table)
When an employee is clocking in, the Timecard form asks โOperate Vehicle?โ If they answer โYesโ then they are required to complete the nested Vehicle Inspection Form.
At the end of their shift, they are supposed to open and complete the nested Vehicle Inspection Form by entering the โEnd Hrs/Miles."
Right now, the employee can enter their Time Out and completely bypass completion of the End Hrs/Miles column in the nested form. Thank you, in advance.
You could check it with a formula like COUNT([Vehicle Inspection][End Hrs/Miles])>0. Iโm assuming that โVehicle Inspectionโ is your related virtual columnโs name.
Yes, โVehicle Inspectionโ is the related virtual column name. Do I enter the formula into this same virtual column? Is it a VALIDIF constraint?
Yes with Valid If. Though you probably need to do that with another column than this virtual list column.
Thank you, Aleksi. That did the trick.
Youโre welcome
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |