Jump to content
  • 0

Pass parameters Calculated fields


Go to solution Solved by MayMusic,

Question

Hello!

Read all info on passing parameters but couldn't find answer. Have a Submission Form with virtual fields from which I pass parameters to report DataPage (data source: view not table) with calculated fields and want then to pass parameters to new DataPage - Web Form where user can check his choice, make new data input and only than to save data to table. I am using following string:

"?Operator_carrier=[@field:tbl_export_import_land_Operator_carrier]&Origin_country=[@field:Origin_country]&Destination_country=[@field:Destination_country]&Departure_port=[@field:Departure_Port]&Destination_port=[@field:Destination_Port]&Weight=[@Weight]&Price=[@field:Price]&LCL_voy_noID=[@field:LCL_voy_noID]">Book</a>"

Can pass other parameters but not values from Calculated Fields. There is no possibility. Is there are way to pass Calculated Fields values to a new DataPage, Web Form Submission?

I've tried to do without passing - to just use formula in new Calculated Field in a new Web Form but somehow it doesn't work with formulas based on View as Data source but it is working with formulas based on Table data Source. Unfortunately I need to use View as data source due to formulas and conditions.

Perhaps any idea or solution?

Thank you very much!

Bostjan

 

Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
  • Solution

As I understand you have a Calculated Field in your report page and you are trying to pass that value as a parameter from a report or details page.  If that is the case you should be able to select that value from picker and the format is: '[@calcfield:1]' for instance:  https://caspio.com?value=[@calcfield:1]

 

 

Link to post
Share on other sites
  • 0

Correct. It works, perfectly!! and pass value immediately!!

Didn't know that Calculated Filed value can be passed by the number of the filed. Thank you so much!!

In mean time I got help and found a improvising solution to pass Text value parameter like '[@Parameter]' and calculate same formula and conditions as in previous DataPage but your solution :-)  as I do not need to calculate in destination DataPage, I can simply pass!!

Thank you again!!!

Really appreciate your help!!

 

Link to post
Share on other sites

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.

Guest
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.

Loading...
×
×
  • Create New...