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.