Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Value list by calculation


This topic is 4873 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Hi,

I have a text field (OutcomeVariable) in a table, that is displayed on a layout. I want the user to enter a value in that field based on a value list.

I have two different value lists that can be used for this field. If User 1 enters the layout, I want the layout to display ValueList 1. If User 2 enters the layout, I want the layout to display ValueList 2. Three items that are in ValueList 1 are not in ValueList 2.

Could you comment on the following:

1. Is it possible to set it up such that User 1 sees ValueList 1 and User 2 sees ValueList 2? If yes, how?

2. Should I just have two different tables, one for User 1 and the other for User 2?

Thank you.

Posted

You need one value list that will change dynamically according to the current user. Create a new table for the values, and for each value select the users that are allowed to use it - this could be a checkbox field. Define a relationship between your current table and the Values table, based on matching an unstored calculation field returning the current user (in your current table) to the checkbox field.in the Values table. Set the value list to use only related values from the Values table.

Note: you probably should use the current privilege set instead of "user".

This topic is 4873 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.