Skip to main content

I’m building a database for brokering products. I have a lot of offers and requests. I built a form where I can look up offers (in one table) or requests (in another table). Users are supposed to select an offer OR a request from a drop-down menu (lookup) in the form. However, when I look at the form in the edit mode, it shows all the information for each entry in either the offer or request table.


When I activate the form, however, all I see is the name/number of the offer/request, but none of the additional information. I also can’t search by any other fields.


This should be rather basic, but - I just can’t fix it.

Welcome to the community, @Dietwald_Claus! :grinning_face_with_big_eyes: Sorry that this wasn’t answered sooner. What you’re seeing with the form behavior can’t be changed. When setting up the form, you see all of the related fields for linked records because you’re the form creator. When users open the form, though, all they see is what’s in the primary field for linked records. The only way to natively give the users more to choose from is to use a formula field as your primary field in any table that you want to link to, and pull in data from other relevant fields that the users might wish to search through.


If that won’t work for your use case, you’ll probably need to consider a third-party form tool that may let you give users additional searching options. I know that On2Air Forms by @openside, which ties into JotForm, can let you do more robust searching. I don’t have experience with other form tools, so I can’t speak to their specific abilities to address this issue.

Reply


Terms & Conditions