Jodie

Hi
If there's no data submission, do you already have the knowledge table? The table structure needs to have a link between the parent-child options.
With what you've presented, this doesn't necessarily require a multi-page form. The workflow can be accomplished using a set of cascading drop downs where the parent is linked to child options.  You can use as many parent-child responses as the question types require. You can hide the options whilst the parent field is blank, and only show when the user has selected something from the preceding dropdown.  
The other thing you could consider is entering your question into chatgpt - this has helped me enormously. In the youtube below, Ned shows how you can use ChatGPT to get sample code, find errors, as well as get basic database structure. 
Best of luck on your app 
 

Did you find an answer? I'm also so close to the 50 page limit for my plan that I've put way too much into a single page. But I did find that I had taken the wrong approach with my views. 
I created a very simple datapage table - with a results page and it took 3-4 minutes just to preview the page. If I passed a parameter and went straight to the results page, it was about 30 sec to 45 secs. The issue turned out to be the size of view. I'd been using the same view for multiple pages, and the views over time were getting bigger and bigger - so even pages that once were quick, became slower!
Now I need to go back and make more views for my pages and retest/change the pages as required to keep everything as lean as possible. I'm also creating a separate calc table for my user data to push as much calculation off the page load and into the tables as I can.
If you found other options that worked, it'd be great to hear.

H, I just wanna share this article and informative video about the best practices for creating Caspio apps.
I hope this helps!

Hi @Jodie

I tested your formula on my end, it worked fine.
Supposing your field is Integer this formula should work:
 
CASE WHEN [@field:PW_tbl_progitems_itemnum] >=10 THEN 'block;' ELSE 'none;' END If your field is other than Integer then you could cast the value to integer:
 
CASE WHEN CAST([@field:PW_tbl_progitems_itemnum] AS int) >=10 THEN 'block;' ELSE 'none;' END The Output:

Thanks for responding Ilyrian, whilst  the formula showed as verified in my account too it still didn't return the field values.  Caspio Support suggested blocking the " mark and that finally worked. 
 

Hello @Jodie,
Please test the statement with the 'target' keyword.
ISNULL((SELECT (Field4) FROM PW_tbl_progitems WHERE progitemid=target.[@field:progitemid]),0) According to your description, it looks like you pass the selected value as a parameter. In this case, the syntax should be:
 
SNULL((SELECT (Field4) FROM PW_tbl_progitems WHERE progitemid='[@progitemid]'),0)  Feel free to update this thread if you have further questions.  

Hi @Jodie,
You can check this forum post from Caspio. It provides a guideline for referencing Caspio form elements using JavaScript.
 

Hi @Jodie

You are correct, you can simply use #cbParamVirtual1 for a selector.
You can try to add !important to se if it makes any difference.
#cbParamVirtual1 { background-color: red !important; }
You 

Hi @CMorris,
Values from virtual fields do not have a datatype.
You would need to wrap the fields reference with single quotes to make them string type and convert the string to float type.
You can use T-SQL function CAST or CONVERT for this.
So, your expression will look like this:
CASE WHEN '[@cbParamVirtual2]' = 'mm' THEN CAST('[@cbParamVirtual1]' AS FLOAT)/25.4 ELSE CAST('[@cbParamVirtual1]' AS FLOAT) END Regards,
vitalikssssss

Hello @Jodie,
On your HTML Page, you need to click the Source button first or disable the HTML editor before pasting the code. 
https://howto.caspio.com/faq/web-forms/how-to-disable-html-editor-in-datapage-headerfooter-and-html-blocks/