Obtaining Display Value in a Formula Field

[ronbrumbarger]

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?

[douvega]

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

[SunakoChan]

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.