Audit app with action plan

[Alexveo314]

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

[peterson]

Could you please give us more detail of wat you want, maybe some examples...

[Alexveo314]

I have an audit "audit ABC" 
for which I need X answers (IE "do you like bananas?")
based on this answer I create an action plan with action item.
If (answer to "do you like bananas" is yes then I create an action item "buy bananas" linked with my "audit ABC" . 
The most straightforward is to do it with a bot with a branch on condition for each question but I fear that the bot might be huge.
The other options I have found is to have a script to create the actions or the other option is the one below

[Alexveo314 · Accepted solution]

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

[dk3]

Hi! i am also having the same problem. I have 6 tables which are different from each other covering different audit scopes.  I wanted to create a bot that will activate 'Audit complete when I reach the last Item on the row.  when I condition the behavior to the last row on the table it appears on all other the rows. If you get a solution please share it might be useful to my problem.

[Steve]

([_RowNumber] = MAX(Table[_RowNumber]))