Pass Calculated Field

[Leigh]

I need to be able to pass a calculated field from a tabular report datapage to a submit datapage thru a link. The calculated field is 'Age'. it is calculated using the following:

SELECT CAST(DATEDIFF(YEAR,'[@field:Date_Of_Birth]',GETDATE()) AS VARCHAR(10)) + ',' + CAST(DATEDIFF(MONTH,'[@field:Date_Of_Birth]',GETDATE())-(DATEDIFF(YEAR,'[@field:Date_Of_BIrth]',GETDATE())*12) AS VARCHAR(10)) AS Age

I am passing other fields from the report to the submit page, but can't figure out how to pass the calculated field.

Thank you!

Leigh

 

[Mathilda]

On 11/14/2016 at 5:17 PM, Leigh said:

I need to be able to pass a calculated field from a tabular report datapage to a submit datapage thru a link. The calculated field is 'Age'. it is calculated using the following:

SELECT CAST(DATEDIFF(YEAR,'[@field:Date_Of_Birth]',GETDATE()) AS VARCHAR(10)) + ',' + CAST(DATEDIFF(MONTH,'[@field:Date_Of_Birth]',GETDATE())-(DATEDIFF(YEAR,'[@field:Date_Of_BIrth]',GETDATE())*12) AS VARCHAR(10)) AS Age

I am passing other fields from the report to the submit page, but can't figure out how to pass the calculated field.

Thank you!

Leigh

 

Hi Leigh,

You may pass value of calculated field in the same way you pass regular field in query string.

For example:

<a href="URL_of_submission_form&age=[@calcfield:1]">name of the link</a>

In my example value of calculated field#1 will be passed. If you need to pass value of the Calculated field #2, the parameter will be: [@calcfield:2] and so on.

In a submission form you need to receive in a field the following parameter: [@age]

Hope it helps.

Please feel free to ask if something is not clear enough

[Leigh]

Thank you VERY much. This works perfectly!!

[Mathilda]

12 hours ago, Leigh said:

Thank you VERY much. This works perfectly!!

You are welcome! I'm glad that it helped

[ParkLoey]

Hi! Just to add, Mathilda used a process called passing parameters through query string. Should anyone need help in knowing how to create the correct format, here's their article about it:

https://howto.caspio.com/parameters/parameters-as-query-string-values/

[autonumber]

Hi! You can also check this forum post: