Solved: Show if constraints for row in table - Page 2

Wallace_Service · 12-17-2020 01:31 PM

Hi, is there a way to use a “show if” type constraint on a row in a table. We want to stop technicians from adding service tickets (one table) under a particular customer file (another table) but still want to be able to see past info. I tried using a security filter to block the customer rows but then it breaks all of the references to the old service tickets. This would be ok in sense as we can still see all of the old data but curious if there’s a way to do this without breaking the references.

Thanks in advance!

Suvrutt_Gurjar

Thank you.

Is the " Not in System" also coming from the referenced table?

If so, please try in the valid_if of [Customer Name] column in the Service Ticket table

IFS([Date]>=“12/20/2020”, SORT(((Customers[Customer ID])-LIST(“Not in system”)), FALSE),
[Date]<“12/20/2020”, SORT(Customers[Customer ID], FALSE)
)

Any new records created from 20th December 2020, will not have option of “Not in System”, records created before 20th December will have the option displayed.

View solution in original post