Iโm done on a problem!
Iโm trying to disable the possibility to ADD a record in a child table if the useremail() isnโt the useremail of the creator of the parent.
For the EDIT itโs working. Any clue?
IN(useremail(),SELECT(Report[Useremail], [Report nb]=[_THISROW].[Report nb])
Thanks in advance
Can you provide more details? Where have you entered that formula? Which table is child table, and which one is parent table?
โReport Noโ is parent, child is โActionโ Thanks
Try it like USEREMAIL()=[Report nb].[Useremail]
@Aleksi_Alkio Can I get the parent value to see if itโs in READ_ONLY or ADDS_UPDATES mode. It could be easier.
@Aleksi_Alkio I tried your line, the test in the โexpression assistantโ are good, but the button โNewโ doesnโt appear. The table allows ADDS and UPDATES.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |