When a new license plate number is entered in a new report (Form view), I want to show the dates of any matching license plates in previous reports. This needs to update without sync - the app is setup to work off-line which is the norm for our users who work in the forest.
Iโve setup a virtual column ,LongText type, with the following formula:
CONCATENATE(SELECT(NRC Reporting[Timestamp], ([License Plate #] = [_THISROW].[License Plate #])))
The expression assistant warns: โNote, this expression could significantly impact sync time.โ But this works perfectly 70-80% of the time. It work off-line and doesnโt matter how many matches are found. I canโt find an underlying reason when it doesnโt work.
Any help would be appreciated.
Bob Haizmann
LinkedIn
Twitter
