Jump to content
  • 0

Using Virtual fields for search and calculation on pages




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












Link to comment
Share on other sites

2 answers to this question

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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...