Really need help here, I have not been able to figure this out and it is probably a simple fix. My app has 3 tables
- QuestionMaster = this table has checklist questions related to one or many business processes. this allows you to create checklist questions, and assign them to business processes for re-use
- Answers = This table stores the answers to checklist questions and it has a reference to the question QUESTIONMASTER and to the business process that it was answered for.
- BusinessProcess = This table holds the business processes that are started.
when a technician is going to do something, say a site inspection, they will create a new instance of the business process (row) which should trigger the pre-population of the correct checklist questions associated to the business process jsut created. this way when the user opens the business process, they can see all of the relevent checklist questions and steps that are to be performed and they can cpature hte answers.
The checklist master table is only used for defining the templates and overall structure of hte checklist questions used for each business process. This way, we have a single answer table and can aggregate answers across various business processes that may share the same checklist step or action.
AnnoyingI (AI) has told me the same thing over and over. Create a bot to run when a new row to business process is added, run a data action -> run action on rows. Refence table QuestionsMaster, filter the rows for the type of business process, and run a referenced action create a single answer row. This action runs for for records in the QuestionMaster table and adds a new row to another table using values from this row. It adds to the Answer table and sets the question ID directly and business Process ID using [_THISROW].[ROW ID].
I can't get this to work and have no visibility into what is happening. now answer rows get created.
Any help is VERY much appreciated.
LinkedIn
Twitter
