You can’t enforce the user having to do something with a subtable.
Your only 2 options are either move the deficiencies to the same table.
Or create a rule that you can’t create a deficiency in a subtable unless all previous checkpoints have a deficiency.
Thanks Mr. Simon.
@John_Henry_Joseph yeah so each task column needs the show if rule added.
You do this in the data section under the column tab.
Edit the column(of the tasks) and in the show if section put =[your Enum column]=“Not OK”
Does that make sense?
The tasks can’t be in column. It’s the input from technician. What I try to say… These tasks are Rows which associated with due date category etc etc
The task headings will need to be in a column right?
@Simon_Robinson I am following your advice that having a table contains set of Questions or Checks, which are pulled during inspection by Dropdown. Now i need to show / filter those questions / checks, which are not attended. How to write expression in ValidIf? please help me out.
@Simon_Robinson This is my original expression … SELECT(INSPECTION TEMPLATE[Checkpoint], NOT(IN[Checkpoint], SELECT(INSPECTION CHECKLIST[Checkpoint], [Inspection Code] = [_THISROW].[Inspection Code])))
Sorry then I can’t help you. As what it seems you are trying to do is not really possible to my logic.
To me a row needs to be unique to every other row like a customer or the item that needs maintenance.
Columns to me are all the possible situations/tasks that the unique item/job/customer could need.
If your app won’t work in this manner I wish you good luck in finding a solution, sorry I couldn’t have been any help.
Thanks for your efforts
Still I am looking for a solution…
@Aleksi_Alkio Can you help me out in this regard please…
So… we just have done something similar for a client who inspects buildings for fire safety.
The format we have for him is the main table is Job, and the subtable is Defects.
We’ve done it this way because no one knows how many defects there might be on each job.
Each defect contains about 10 bits of information he can add such as
[Question] [Location]
[Pic 1] [Pic 2] [Pic 3] etc
In his case Location pulled from a list of known locations for this job.
Question is pulled from a list of 100 questions in another table because he needs to ensure he has answered all questions even if its just to say everything is fine.
Hope this helps
@Simon_Robinson Great Mr. Simon. This is what i have been looking for. But tell me one thing. As you said, the questions are pulled from another table, how its designed. Whether inspector has to choose from drop down button? or how? how do we ensure they filled all questions? Please…