Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Display Lookup Fields alongside Linked Records in Form Views

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Zollie
10 - Mercury
10 - Mercury

Context

Weโ€™re putting together an order form for our clients. The various components of that order are listed in other tables. So they use linked record fields to select which components they need for the order.

Problem

Because linked records only display the primary field, clients arenโ€™t able to see the image of the component theyโ€™re choosing. As a workaround, weโ€™re using helper text and shared links so they can at least see a catalogue of their options alongside the form. But representative thumbnails directly in the form would be preferred.

Current state of order form:

CurrentForm

Catalogue example:

catalogueExample

9 Comments
Aron
7 - App Architect
7 - App Architect

Hi Zollie,

Thanks for the feedback! The only workaround that comes to mind is that if the person filling out the order is a member of the base, you can create a URL that pre-fills the right component directly in the catalogue table which they can use

Iโ€™d even recommend โ€“ if I was so bold โ€“ to use the new Button to create a โ€œOrder this itemโ€ button that pre-fill that item in the order form!

Hope that helps & appreciate the feedback
Best
Aron

Want to learn Airtable? Join me for a webinar at airtable.com/webinar

Zollie
10 - Mercury
10 - Mercury

Thatโ€™s a clever thought, Aron. Unfortunately:

  • I donโ€™t think it would fit the schema *
  • Weโ€™re hoping to avoid adding client collaborators for now

* A given Order is comprised of number of records from additional linked tables - such as a Props, Background Images, and Products. Together they create an image weโ€™ll be producing. So if the collaborator is indicating their interest in a given Product, for example, then the prefill will only have populated one portion of that order form - it wouldnโ€™t have carried over information about the Prop or Background Image.

Justin_Barrett
18 - Pluto
18 - Pluto

Have you spoken with Dan at @openside about the On2Air: Forms product? I worked with him on some projects last year, and heโ€™s got a way to have a text/image combo as part of a drop-down list, thanks to how his tool integrates with Jotform.

Zollie
10 - Mercury
10 - Mercury

On2Air: Forms looks pretty awesome @Justin_Barrett and @openside. Iโ€™ll definitely be weighing it against the current implementation.

Moe
10 - Mercury
10 - Mercury

Weโ€™ve built a form that supports showing lookup fields inside the form, including images. You can check out the demo on this page for an example:

Simon_Warren
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I have the same need, as this for a Form.
Users click a field selection on the form and it does not explain or show them what they are picking?

image

In this example Current Doc is the primary and is only a number.

When i click Add, i get the scrolling pop-up window of all options:

image

This is not helpful and would like to see the linked field which is the description of the Document as well?

and then once a record is selected, it displayโ€™s the description linked field in the form as well
image

So there is 2 issues here;

  1. Showing the linked field when choosing the input field, scrolling up and down the pop-up window,
  2. Embedding the linked field in the form, based on the selection in 1).

Any guidance would be appreciated.

Bruno_Aguilar
4 - Data Explorer
4 - Data Explorer

I have the same need here

Sabrina_Hewa
4 - Data Explorer
4 - Data Explorer

same hereโ€ฆ so frustrating! how hard can it be to add this functionality!!

RRH_Middle_Mana
4 - Data Explorer
4 - Data Explorer

Talk about coming late to the partyโ€ฆ

You could move the Primary Key (PL001, PL002โ€ฆetc) to a new field and add a new PK with the formula field type. You would then enter a formula such as:

Doc & " - " & Description

โ€ฆdepending on what your respective field names are

Then when a user goes to select the linked record on the form they will see the Doc and Description

Hope this helps everyone!