Dear team
Need to have an App for Inspection process, contains no. of questions. For each questions, there must be multiple findings, each finding should have photo, one more field to be filled by maintenance team.
I know by having two tables one for master inspection and another one for all observations. but that one is not practicable. The inspection team should give their findings question by question.
Any ideas please?
I’d have it all on the one table and use the slice ability to divide and filter into two different views. The first one being a form and the second a detail view with a quick edit on the field that needs an entry afterwards.
Thanks Mark. But, the detailed one is not predictable. For instance, one of the inspection check point is “Check / Change all Air Filters”. In this case, we dont know how many filters to be changed. We have take photos of each and make comment and finally it become a tasks to be followed by maintenance.
@John_Henry_Joseph sorry I don’t understand the issue. You can make quickedit available for as many columns as you want. Or you can filter what the second group sees with a slice and use a second form view that opens from an edit action.
@John_Henry_Joseph are you able to post a sample screen shot of what you have done so far and describe what you want it to do that it isn’t?
Unfortunately, i could not able to express my requirements. I am talking about parent child concept. Lets take another simple example. I have a question. The answer may be “OK” “NOT OK”. If not NOT OK, the user may raise multiple observations, categorized as Minor, Major and assigned to whom, fix the deadline and their comments.
Am i clear here?
@John_Henry_Joseph Ok, I would have an Enum column of Ok, Not Ok.
Then the next columns will have a show if value. Have them only show when the other column = Not Ok.
“Enum” type is ck for me. But i should able to add tasks if not ok…
So the questions are just a column in another table.
You just put TableName[ColumnName] in the Valid_If box to get a list to choose from.
To ensure they are all filled we simply list the questions completed in order of question number.
So if 26 is missing, you can see it.
So if you’re doing it that way, you can’t have a valid if in respect to adding rows.
What you can do though would be to create a UX rule to colour all the rows in red for example if a particular job didn’t have all questions answered
Misunderstood. let see stop by step. 1. One table having list of questions for different type of equipment (Question Table) 2. Another table for Inspection header (date, which equipment, inspector, place etc.,) 3. Another table for inspection for the above “inspection header”. Here i can show the questions that match for that equipment type. 4. Another table for observations for the above “Question” if not ok. Now the problem is
@Simon_Robinson Please see the data structure. Inspection Template - list of questions for different equipment type Inspection Header - master record for each inspection Inspection Checklist - shows questions for the above inspection Observations - tasks to be created if any problem in that particular question / checkpoint.
Ok, do you ever need to select the same question from Inspection Template twice?
Or is it ever only the same question once per Inspection Header?
@Simon_Robinson the question should be selected one time only for each inspection.
I’d create a valid_if as I described above but one where it only lists questions you’ve not already recorded.
Something like this in ‘Inspection Checklist[Question]’:
Select(Inspection Template[Question],IN([Question],Select(Inspection Checklist[Question],[Inspection Header ID]=[_ThisRow].[Inspection Header ID])))
Assumes you have a column called ‘Inspection Checklist[Inspection Header ID]’ which is your key column got that table.
Let me know if you need this breaking down
In fact we needed a NOT in here:
Select(Inspection Template[Question],NOT(IN([Question],Select(Inspection Checklist[Question],[Inspection Header ID]=[_ThisRow].[Inspection Header ID]))))
@Simon_Robinson Got a error message as "Unable to find table “IN”…
No Mr. Mark… that’s the problem actually. The tasks should be as rows.
@Simon_Robinson Dear Mr. Simon… Your expression is working great… its my fault that i missed “(” nearby “IN” operator. Thanks lot Mr. Simon for your great timely help.
@Simon_Robinson One more advise please. If one checkpoint is not ok, the user should update the deficiencies found in another child table. How system gives alert if checkpoint is “NOTOK” but without any deficiencies and try to save the record?
Can you please advise me?