Combine Virtual Fields into another Virtual Field

[mark048]

Hello All,

 

Is it possible to concatenate two virtual fields into a third virtual field on a submission page? It doesn't seem to be working for me. 

 

Thanks

Mark

[Vitalikssssss]

11 hours ago, Pulford said:

Hello All,

 

Is it possible to concatenate two virtual fields into a third virtual field on a submission page? It doesn't seem to be working for me. 

 

Thanks

Mark

Hi Mark,

I believe that it is possbile. You may customize JS solution from this post:

https://forums.caspio.com/index.php?/topic/3200-js-concatenatecombine-two-fields-into-one-field/

You need to change element_id to reference Virtual field(correct syntax:  cbParamVirtualX ).

You may also need to change an event  trigger  i.o. onsubmit.

Hope this helps.

 

[Kurumi]

Hi @mark048,

This is possible. On the 3rd Virtual Field, you could choose the Form Element as calculated value and put the following formula from two virtual fields: '[@cbParamVirtual1]'+" "+'[@cbParamVirtual2]'

As of July 12, 2018, Caspio introduced new features which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-13-0/
This release includes a new feature, Calculated Values in Submission Forms.  This allows you to generate calculations which you can use for your total sum.

Check these videos for more information:

 

I hope this helps!

[NailDyanC]

Just want to add to this post, you may also consider checking Caspio's Function Reference for other formulas: https://howto.caspio.com/function-reference/