I decided to create a new clean app to avoid propagating some of the learning mess I'd had in my first app. However I'm having issues with the record ID instead of proxy field showing up, as below;
I've checked back to my original app (where the lookup worked fine) and I cannot see any differences in the settings.
The related site field settings are as below;
I haven't copied in the screenshots of the original apps table relationships but they are exactly the same (unless I've been staring at these long enough that I can't see the differences!).
Go to the Settings for the table which holds the drop down source and to Advanced Properties.
Set the Record Picker fields. These are the fields that you set to show by default to allow uses to "pick" which records they want in a drop down list from a relationship.
Thank you! I knew it was going to be in a menu I hadn't looked at yet :)
Are the record picker fields created when you create the table for the first time or the relationship for the first time? Just wondering if there is a default period when you can first chose these pickers to avoid having to edit later.
The record picker fields are also used when you click on the "star" at the top right to look at recently touched records.
That will save a ton of time and frustration as you work with the app, if you get your default reports cleaned up and disable to auto add fields to the default report.
Settings (for the table)
Reports, and then way up at the top right for defaults.
I did that one but by creating new "main" reports (since I wanted to leave the ALL reports alone) and then assigning these main reports as the default report, but thank you for the official method of doing this, less clicks in the future!
One other quick one, normally you edit the field value to remove the, for example, <add a new site> option (via "allow users to create new choices") but I can't remember where this option is for lookup fields? I'm pretty certain that also includes what information to display in the drop down (ie. record ID# + site ID or just site ID). I've been hunting but can't remember where this option is, can you point me the right way?
I’m not sure if simply changing the Role to Hide the Add Record button would apply to the link at the bottom of the drop down list.