yballan3 Posted January 30, 2018 Report Share Posted January 30, 2018 Hi, I am trying to convert my Access database to Caspio database, and am having trouble accomplishing a task that I used VBA to do. I wanted to know if there is a way to populate a Caspio table from javascript inside HTML code in Form page. I am trying to get Opt 1 and Opt2 input, then generate all the variations, for example: Opt1: Red, Blue Opt2: Small, Medium, Large The Variations that I want to populate the table will be: Opt1 Opt2 Red Small Red Medium Red Large Blue Small Blue Medium Blue Large Please advise. Quote Link to comment Share on other sites More sharing options...
MayMusic Posted February 8, 2018 Report Share Posted February 8, 2018 I believe you need to have a trigger to add the rows to the table and it does not seem to be possible with built in trigger as there is no loop option Quote Link to comment Share on other sites More sharing options...
vanderLeest Posted March 5, 2018 Report Share Posted March 5, 2018 Create a trigger that fires on insert on the submission table, and insert the records one by one in the destination table based on If statements for all available options. Quote Link to comment Share on other sites More sharing options...
yballan3 Posted March 5, 2018 Author Report Share Posted March 5, 2018 Dear Vander, I will try your solutions. Thank you! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.