Hi, I am using this valid if in the customers table / customer column
it validate if the customer is already exist
NOT(IN([_THIS], SELECT(Customers[Customer],true)))
App says that it could impact the app’s performance. I think because it has to look up the whole column.
so is there to limit it to specific date … for example only customers that were entered today and yesterday or last 5 days only.
Big Thanks
Have you tried adding constraints to the SELECT expression?
You can ignore the warning as the validation is only calculated when you add or modify the record through the form view. Meaning.. it doesn’t affect your app’s performance for example when syncing.
Thanks very much @TeeSee1
Please detail more
table : customers
column: customer
Column: Date
would you plz re-write the select expression here so it will notify user if the current entered customer name was already entered today to up to 7 days back.
That is really great to know, thank you very much.
by the way do you know ways to speed up app loading.
There are a lot of things that can ruin the app performance if the app is built in a “wrong” way. The best way to start the investigation is to open the Performance Analyzer and check what is the main cause for the delay.
Thank you I will check the Performance Analyzer now
Goto Editor > Manage > Monitor > Performance Profile > Launch performance analyzer