Solved: Audit app with action plan - Page 2

Alexveo314 · 07-11-2024 04:20 AM

Hello,

I have a bit of a tricky case.
I am creating a big audit app with multiple tables.
Based on some of the questions' answer an action plan must be created.
Ideally I'd like to create a new table with action item linked to the audit.
However, I feel like I need to create an appsheet action for each question and that might be a bit cumbersome to maintain

I was thinking to create a question_answer_action table and once my audit is terminated, based on the answer I create all the action items based on this table and the answer. But I don't see a way of having a mechanism of for each question item do this except using apps script.

The other idea I had is create in my initial audit other columns to have the actions but it creates the actions items in colum which I am not a big fan of.

Any thoughts welcome.

Regards

Alexveo314

Another idea, I just tested.
I create 5 tables:
Audit: general information about my audit)
Audit_question: all the questions from table question that I want to ask for this audit
Question: the list of question with possible answer
Question_action: the list of actions per question-answer couple
Audit_action:the list of actions for my audit

every time an action_question is answered it creates an audit_action item fetching the action from question_action table.
Now I must find a convenient way to pre-create the audit_question

View solution in original post