JohnM Posted December 19, 2022 Report Share Posted December 19, 2022 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, Quote Link to comment Share on other sites More sharing options...
1 JohnM Posted December 19, 2022 Author Report Share Posted December 19, 2022 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. Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted December 19, 2022 Report Share Posted December 19, 2022 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'. Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted December 20, 2022 Report Share Posted December 20, 2022 Thank you for sharing this idea @JohnM Quote Link to comment Share on other sites More sharing options...
Question
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,
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
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.