Cross reference a form input against another column?
Is there a way to tie the value of one column to the action of another?
I have a form created, but only certain sites will be responding to it. I thought about making my primary column the site code, but I can't change the column type. So I ended up taking a different column (Column 3), changing it to a dropdown list type, and listing the specific sites I want to respond to this form (approximately 100). The respondent will select their site, input the requested information in the form (Columns 4, 5, and 6), and submit it.
Once the form is submitted, I would like form some way to identify if a certain site has responded or not. I was thinking of using the primary column as the base list, and would like it if the row could be highlighted, or another column that is set to be a checkmark box could automatically be checked when that site is selected in the Column 3 dropdown. I would also like the correct information to be associated with that site's row.
For example, if site ABC completes the form, the row that has ABC in the primary column would change color (or the associated checkmark would be checked), and the information associated with ABC would be added to the appropriate columns.
Can this be done?