Jump to content
  • 0
ronbrumbarger

Obtaining Display Value in a Formula Field

Question

Using the Caspio functions in a "Formula Field", I'm trying to use the "Display Value" from an associated table/field. For example:

Table: Customer
CustomerName - type text
CustomerID - type integer

Table: Contact
ContactName - type text
CustomerID - type integer -> points to Customer table

The tables are are "related" and the CustomerID field in the Contact table is using the Display Value of CustomerName

Question: In the formula field, how do I access the CustomerName?

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi @ronbrumbarger,

You can not access data from another table within a table. You can surely access cross table data from Calculated fields in your datapages.

What is the purpose of having something like that in your app?

Generally, there are workarounds that might work for you but you must be more specific about why you are trying to do that.

Looking forward to hearing from you...

Share this post


Link to post
Share on other sites
  • 0
On 11/27/2019 at 9:48 AM, douvega said:

Hi @ronbrumbarger,

You can not access data from another table within a table. You can surely access cross table data from Calculated fields in your datapages.

What is the purpose of having something like that in your app?

Generally, there are workarounds that might work for you but you must be more specific about why you are trying to do that.

Looking forward to hearing from you...

Hi @ronbrumbarger,

You can use select statement to get the values from the table inside your calculated fields or values. You may check this function reference: https://howto.caspio.com/function-reference/

I hope this helps.

Share this post


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