I have a table "Clients" in App 1 which has List-User fields to assign account managers to the clients.This table is replicated in App 2 using QuickBase Connection.
In the App 2 Clients table, the fields for users shows up as text with the email in quare brackets "[firstname.lastname@example.org]". Empty items shows up as "". This is not good especially when creating reports that are based on current user since the current user looks for full name.
What are my options?
Is there a way to sync the table such that the User is maintained same was as original table? OR
What can I use in a report to query based on current users email? I tried contains "usertoemail(_curuser) and it didn't work