Display Value in a Relationship

[JohnM]

Caspio has this feature, Display Value, nice when a joined table is being used as a lookup, with a key and a value. 

But how it works seems backwards.

If I pick something from the dropdown, then I, as the administrator, see the lookup value, instead of the key, in tables.

If I check “Use display value on DataPages,” then my users see the lookup value in DataPages.

But often I, as the administrator, want to see the key while my users see the lookup value.

Am I correct that Caspio cannot display the lookup value on users DataPages unless it does the same on Datasheets? 

Thanks,

 

 

 

 

 

[JohnM]

Thanks for confirming.

I decided to select a Display Value and check the box . . . but I then created a calculated field that is merely a duplicate of the key. That way, I see both key and lookup value in the Datasheet.

[CoopperBackpack]

Hello @JohnM,

As far as I know the behavior you described is correct.

There are 2 possible scenarios:

1)  The value to display is selected in the dropdown but the checkbox is not checked:

In this case the dropdown appears in the child table but on the DataPage the real value is displayed.

2) The value to display is selected in the dropdown and the checkbox is checked:

In this case the dropdown appears in the child table and on the DataPage the real value is replaced by the selected 'Display value'.

[CoopperBackpack]

Thank you for sharing this idea @JohnM