Forum Discussion

RossonLong1's avatar
RossonLong1
Qrew Cadet
4 years ago

Multi-Select Text filtering based on user permissions

We have a table that is filtered based on your role and a Multi-Select Text that is grabbing it's drop-down data from the filtered table.

However, rather than being a filtered drop down based on your role the Multi-Select Text field is acting like an administrator in the sense that it shows every possible option from the filtered table that it is pulling from.

Example of expected results:
John visits the table "Tags." He can see "OLD" and "NEW"
Tim visits the table "Tags." He can see "Fresh" and "Expired"

In a separate table when John makes a record we have a multi-select text field that is pulling from the filtered table. John should only see "OLD" and "NEW" and when Tim makes a record he should only be able to see "Fresh" and "Expired"

Problem & actual results:
Currently the Multi-Select Text drop-down box does not filter based on the permissions in the table it is pulling from based on the user creating the record. Tim and John both see "OLD", "NEW", "FRESH", and "EXPIRED" in the Multi-Select Text field rather than only seeing the results based on their filtered permissions.

Is there any way to make sure that those multi-select text fields filter themselves based on what the user has access to in the table that it is pulling its information from?

------------------------------
Rosson Long
------------------------------

1 Reply

  • It sounds like you've got the drop-down set to use values from another field, is that correct?

    If that's the case, you're not going to be able to control what each user sees in the drop-down as the options are solely dependent on the different selections in the origin field. 

    If you can explain a bit more about the business decision(s) driving the need for this particular setup, we might be able to provide some viable alternatives.


    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------