Guys i need help. There should only 1 “On Route” status that should exist. if there’s already an “On Route” Status existing on the table, the status of the “Pending” cannot be edited. how do i do that?
Put AND([_THIS] <> “On Route”, ISBLANK(SELECT(Table[Status], [Status]=“On Route”))) in Editable_If of Status column
@Suvrutt_Gurjar Thanks bud! but im having a hard time understanding this expression given from that article “NOT(IN([_THIS], SELECT(Customers[State], NOT(IN([CustomerId], LIST([_THISROW].[CustomerId]))))))”
you will need to have multiple other statuses such as “pending” in the table.The expression given in article prevents any status being duplicated inthe table.
@Suvrutt_Gurjar @Bellave_Jayaram Thanks for the help guys i got the required code - “=IF([Status] = “Done”, false, OR(AND([_THIS] <> “On Route”, ISBLANK(SELECT(testing[Status], [Status]=“On Route”))), [Status] = “On Route”))”
Hi @Ganz_Montejo,Based on my understanding,your concerned table should have only one “on route” status record at any point of time.
You may wish to take a look at the section “Preventing Duplicate Field Values” in the following article. Hope this helps help.appsheet.com - List Expressions and Aggregates List Expressions and Aggregates help.appsheet.com