Here’s the case study:
I have a board with employee records (ssn, email address, phone, address, hire date etc.). Periodically, I’d like to share a form with my “view only” employees to update their information (new phone number, change of address etc).
Is there any way in this scenario to update an existing record from a web shared form? Perhaps by referencing an unchanging field such as a SSN?
If not, is there some clever way I could create an “update board” that collects data via a form as described above and then somehow automate updating one board from another?
You might be interested in the Duplicates and Uniques app which can help you achieve what you want. Here is an answer which demonstrates how. Should you need any help, you can always write to firstname.lastname@example.org and would be happy to walk you through.
Can you explain me with little more details, how should I use this automation for surveys updates?
I have 2 boards: master board with detailed information and survey board with survey answers (columns almost the same). I want to create automation, which, according to the status column, will update existing columns or (if it possible) create new items in master board with data from survey board columns. Or it’s not possible to do with Monday automations or integrations and I need to do it manually?
Thanks beforehand for your answer!
I think there are many questions, suggestions, and requests for the ability to update records from a (web-based) form. Since monday is a web native application, you might think that this should have been built into the system, but it isn’t.
Work-around solutions are available, as mentioned above, but I know you aren’t alone in needing to have users update a record (pulse) without needing them to be a monday user. Collecting the data into another table and merging the records is a solution, but being able to have them update the record should be an option. (The problem again comes down to safeguards: how do you prevent the employee from entering in “bad” data. I don’t want to see that everyone now lives at 123 Sunset Blvd.)