Does anyone knows ways to build automated surveys in next circumstances :
Table 1 - team members
Table 2 - questions
Table 3 - answers: every answer of every team member should be saved to own row
I need to run somehow the survey so every team member answers every question and I will get the Table 3 filled.
I can’t use coda forms because I don’t keep questions as columns (this is periodical Bus Factor survey with tens of questions that can be extended from period to period)
Maybe some chatbot solutions can help - chatbot via API iterates through table, gets question by question, asks user and saves answer via API? Or may be there is some script that makes temporary transposed table to allow to use coda form and then puts data back to original table?
For now my questions suppose numbers as answers - it’s a bus factor report - people rate their knowledge. Slider is more convenient way, but simple digit input is ok too