So, I have an inspection app with three table INSPECTIONS, STAFF, AND LOCATION.
I assigned the user of the app as a default value to INSPECTOR column, column type is text and app formula is:
SELECT(STAFF[INSPECTOR], [EMAIL] = USEREMAIL(), TRUE)
By nature of the formula, it is working and the user of the app don’t need write his name to the INSPECTOR column.
The problem is ref column don’t accept app formula to evaluate the action above.
So I can not use reverse reference. Any idea is appreciated…