Using Virtual fields for search and calculation on pages

[Ras2019]

Hi,

I'm looking for a hint on how to use Virtual fields and Calculated fields in DataPages to generate a quotation that can eventually be recorded in a different table. 

So far I have tried using Submission Forms and and Reports, but cant get the Virtal Field to appear in results so a Calculated field can be used.

 

This is what I am trying to accomplish:

SEARCH: User choose a product in a dropdown and manually enter required quantity of this a product e.g. in a Virtual field,

RESULT: On the result page it then show:  Product, Unit Price, X units entered, Total Price and a select option. 

SUBMIT: Once the order is selected from the result page, the user is directed to a Submission Form which shall display the selected order details. User can submit the order and the details and Total Price are recorded in a separate quotation table.

 

Any guidance are welcomed.

Thanks in advance

 

Sincerely

Ras

 

 

 

 

 

 

  

 

[Ras2019]

Jus to close it.

 

Problem was solved by changing mind of workflow and focus on passing parameters to next page submission form (without use of virtual fields).

[Flowers4Algernon]

Hello!

Just wanted to share these articles that might be helpful in the future:

1.  https://howto.caspio.com/parameters/passing-parameters/
2. https://howto.caspio.com/parameters/parameters-as-query-string-values/
3. https://howto.caspio.com/datapages/datapage-components/virtual-fields/

Cheers!