Record ID displaying in lookup field

Question

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!).

Any ideas?

quickbasecoachd · Answer

No problem.Go to the Settings for the table which holds the drop down source and to Advanced Properties.&nbsp;&nbsp;Set the Record Picker fields.&nbsp; 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.

archiveuser · Answer

Thank you!&nbsp; 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?&nbsp; Just wondering if there is a default period when you can first chose these pickers to avoid having to edit later.

quickbasecoachd · Answer

The Record Picker fields really have nothing to do with relationships. They tend to get selected when the first fields are created in he table on the assumption that the first two fields you create must be the most important identifier of the records. The first default field will be the [Record ID#] field and then the next two fields you create will the the next two slots in the record picker.

The record picker fields are also used when you click on the "star" at the top right to look at recently touched records.

archiveuser · Answer

Got it, thanks!&nbsp; I'd added fields for site address and similar before I got to site id, so that's where this came from, I'll remember to keep an eye out for this one in the future!

quickbasecoachd · Answer

Right, and the other good housekeeping practice once most of he fields are set up is to set the default report, so get the best default fields, Dynamic filters and sort.

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.

Forum Discussion

Record ID displaying in lookup field

Related Content

Pipelines: Lookup newest record?

Display Thumbnail Image

Lookup Field not pulling Data

Can I create a single field that displays record owners from a child table

Lookup Field Not Pulling Data