
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 27, 2020 08:11 AM
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?
Thank you.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 27, 2020 03:23 PM
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.
In your form, modify the field for linking to workflows so that it limits the selection to that new view:
Once a workflow has been selected (i.e. linked), it will be removed from that custom view, and no longer appear as an option for subsequent form use.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 27, 2020 09:23 AM
Welcome to the Airtable community!
It is a little hard to picture the data that you are working with. Could you provide some specific examples, perhaps with screen captures?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 27, 2020 09:58 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 27, 2020 03:23 PM
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.
In your form, modify the field for linking to workflows so that it limits the selection to that new view:
Once a workflow has been selected (i.e. linked), it will be removed from that custom view, and no longer appear as an option for subsequent form use.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2020 07:01 AM
Thank you, I was trying to figure that out originally but could not wrap my brain around it.
