Hello,
I am trying to gather information from my colleges on how they do specific tasks through out our building (some departments have the same tasks but are done differently, we are trying to accumulate all the data and compare).
I have a grid view of all the tasks from all departments, but I am having trouble finding a way to track which department answers which questions and making sure that when a department does answer, the question can not be asked again (I do not want duplicate data if someone forgets that they already answered a previous question).
Is there a conditional format I can use to accomplish this or will I need to find an external form builder?
I have the table that the info will upload into and the form, once I have someone fill out a form for a designated workflow, how to I take that workflow option out of the list of workflows to submit another form for?
On your Workflows table, create a new view, and add a filter to that view. The filter will only allow records to display where the link field coming from your destination table is empty.