Submission of new records in multiple tables on one datapage

[Billp]

Very new to the Caspio interface although not to programming.  I am getting used to what it does automatically and what it doesn't.  I'd like to create a survey form in a single data page where the user starts by entering their email which becomes the parent record for the answer to many questions.  Each question can have one or more answers.  The schema (without all attributes ) is:

Survey_Entry (id autonumber, email text)

Survey_Question (id autonumber, question text)

Survey_Answers (id autonumber, Survey_Question_id integer, Survey_Answers text(64000)

Survey_Participant_Answers (id autonumber, Survey_Entry_id integer, Survey_Question_id integer, Survey_Answer_ID integer, Survey_Answer text(64000) note: for responses for "other")

I'd like the user to enter their email which inserts into Survey_Entry, that enables the list of questions with the possible answers and they go through checkboxing or entering answers scrolling down till the end

Each answer would add a record to the Survey_Participant_Answers table.  Some of the answers are "all that apply" so for those do i need to fully normalize or can the options in a list integer datatype be entered programmatically rather than selected from a static set of options?

[Kurumi]

Hi @Billp - Your workflow can be done by combining Conditional Form for answering questions in the form and Triggered Actions to insert records to other tables. You can check these references:
https://howto.caspio.com/datapages/forms/conditional-forms/
https://howto.caspio.com/tables-and-views/triggered-actions/
 

 

 

[autonumber]

Hello. Just to add to @Meekeee's answer, you can also check out this template that I found that might help you with your workflow. You can request the app to be uploaded to your account so you can check it out. https://www.caspio.com/apps/faq-manager/