Embarrassing newb question - I have two tables built from a Google sheet source: People with names and a key [email], and Personal Records with a UniqueID key.
Records references People through the Name column. When a new Record is added, everything works as intended in the app and names appear correctly, but in the back end spreadsheet it populates the name column with the email key instead of personโs name.
I know this is supposed to happen, BUT I want it to populate the name instead for readability and in case I want to analyze the google sheet manually or in another app.
I know I could change this behavior by keying People with [Name] because my data set is small and there are unlikely to be any duplicate full names, but I also know itโs not a good practice to have.
Is there another way to get the name to populate in the Personal Records table that doesnโt break any good practices?
Would a dereference expression work in this instance?
LinkedIn
Twitter
