Jump to content
  • 0

Display value in calculated field



Does anyone know how to access the display value of a field when using a formula inside a calculated field with sql?

The critical line for me is below.  In my table the field 'Column_values' is referenced to another table, but displays text in place of the underlying reference data.

 So far I can only manage to access the references, not the text display values.

WHEN CHARINDEX('[@myexample]','[@field:Column_values]') > 0 THEN ...


Other than the above I've tried '[@lookupfield:Column_values]',   '[@lookupvalue:Column_values]',  and all kinds of other combinations, but I just can't get the right syntax.

Any help much appreciated.


Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 1

Many thanks for your reply @Vitalikssssss

What a huge shame this is, and a strange omission by Caspio given that values can be looked up in HTML blocks, JS code, etc.  I appreciate your advice with the View and I'll follow it, but it's going to be detrimental on performance as my records run to the low millions.  How I wish Caspio would expand its sql capability in calculated fields.



Link to comment
Share on other sites

  • 0

Hi @Farnsbarnes,

I am afraid that it is not possible to reference a look up value with any syntax.

I can recommend creating a View to join your tables (parent child) and use this view as a datasource for the Datapage. 

You will be able to reference the parent field by using a parameter picker.

Hope this helps.



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.

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