Jump to content

Reference display value of related field with Javascript


Recommended Posts

Hello. I would like to concatenate two text fields (both foreign keys) and populate a third text field in the same table with the concatenated value when submitting a DataPage. I understand how to do this when I am concatenating the stored value of the fields, but I would like to concatenate the display values of the two lookup fields, not their stored values. Please advise.

Link to comment
Share on other sites

  • 2 years later...

Hi @ray,

You could use the Calculated Value on it.  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.  This allows you to generate calculations which you can use to concatenate your fields.

Check these videos for more information:

 

I hope this helps!

Link to comment
Share on other sites

Hi Just to add to the previous comment above,  In the new release of Caspio version 17.0 , you can now add the Calculated Value form element to Update Forms and Details Pages to generate dynamic calculations as users interact with your forms. Previously, this feature was only available in Submission Forms. You may also check this link about calculated value: https://howto.caspio.com/datapages/datapage-components/calculated-values/

Also, you can Concantenate two fields in your Table using a Formula field:

 

ConcatenateSC.png

Link to comment
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
Reply to this topic...

×   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...
 Share

×
×
  • Create New...