Add email user from the value in the email ID column value

[desmond_lee]

Hi All

Is there an expression that automatically add the newly added email user as valid for edit. See below. I need to come to this windows to add new user.

Is there an expression that automatically add pick the list of emails in the table Source PIC[CONTACT EMAIL] as editable_if list in the table MPN Database[DATE REQUIRED]

[Suvrutt_Gurjar]

In general you could try using an editable_if expression something like

IN(USEREMAIL(), PIC[CONTACT EMAIL] )

However the above expression will give access to all the emails listed in the table PIC

For only senior executives to edit the field, you could create a slice called say "SrExecutive" on the PIC table with an expression

[Position]="Senior Sourcing Executive"

Then your editable_if could be something like 

IN(USEREMAIL(), SrExecutive[CONTACT EMAIL] )

You will need similarly need a slice or SELEC() , FILTER() expression to create a restricted list based on some argument or criteria  such as discussed above.

[desmond_lee]

What about doing something more specific. Let take a look at Col A, Col E  & Col I at Row 6. Col A is unique ID. Is there an expression that allow Col E, 2/21/2023, (DATE REQUIRED) that can only be edited by the email (PII Removed by Staff) with reference to Col A, MRQ_SEA00000837-2023.2.9.16.55.36, the unique ID? In laymen on the person useremail at that row can edit col 6 at the same row

[Suvrutt_Gurjar · Accepted solution]

If understanding of your description is correct, you could simply try 

USEREMAIL()=[CONTACT EMAIL] in the editable_if of the [DATE REQUIRED] column.

[desmond_lee]

wow it so easy and it works well. Thank sooooo much