I have a problem:
I am developing an e-commerce APP.
In the "Items" table I have 3 prices:
- Wholesaler
- Store
- Particular
Additionally, at the time of accessing the APP, the user has a "USERSETTINGS" Wholesaler, Store or Individual.
The problem I have is that I want to display the items in a "Card" view and I want one of the fields to show the "Wholesale", "Store" or "Individual" price based on the USERSETTINGS.
I have tried it with a virtual column:
IFS(IN(USERSETTINGS(ROLE), {"Traveller", "Shop"}), [PVT],
IN(USERSETTINGS(ROLE), {"Senior Traveler", "Wholesale"}), [PVM],
IN(USERSETTINGS(ROLE), {"Administrator", "Individual", "GUEST"}), [PVP]
)
But VCs do not evaluate USERSETTINGS.
I have also tried with a "SHOW" column but the "CARD" view does not accept this type of column...
What I can do???
SOS!!!
Thanks for your help....
LinkedIn
Twitter
