Skip to main content

my question is regarding Forms

I have a table countries with country name as main field.

in my main table clients I have a field client_country filed which is a field linked to table countries

I want to create a Form view of the clients table.
For the field "Client_Country I want to display a select dropdown to select a country among the list from the table countries  
Instead of that, in the form besides the field Client_Country, I have a button "Add a file", which is not what I want  
Can you please guide me to get the possibility to select one country from the list of countries ?  
Many thanks in advance

Hm, could you provide some screenshots of your base / form?  I’ve set up a base here for you to check out as well that I think does what you want for you to refer to in case that’s helpful:

 


I am not sure this fix the issue 
 

my question is regarding Forms

I have a table countries with country name as main field.

in my main table clients I have a field client_country filed which is a field linked to table countries

I want to create a Form view of the clients table.
For the field "Client_Country I want to display a select dropdown to select a country among the list from the table countries  
Instead of that, in the form besides the field Client_Country, I have a button "Add a file", which is not what I want  
Can you please guide me to get the possibility to select one country from the list of countries ?  
Many thanks in advance

Here is my country table
Here is my client table
here is the new for view I am creating with the problem on the Client_country fields.
I have a button “Add a file”” and I wand to have a select dropdown to choose among the countries from the Country Table.

///TABLE COUNTRIES
 


 



///TABLE CLIENTS

 

 

 



/////BACK ON TABLE CLIENTS I WANT TO CREATE A NEW FORM VIEW FOR ENTERING THE DATA MORE EASILY

 


Here is what I see for entering the Client_Counrty
 



I would like here to be able to select a Country_Name from the list in countries which are in the Country table


Thanks a lot

 

:)


Hm, from your screenshots that looks fine.  I assume you’re able to click ‘Ajouter dossier’ and then it shows you a list of records from the ‘Countries’ table and that works fine, right?

If your issue is that you don’t want it to say ‘Ajouter dossier’, perhaps you could try selecting the type of data the table contains?  You can do this by renaming the table and opening the ‘What should each record be called’ dropdown:

 


sorry can you explain this

You can do this by renaming the table and opening the ‘What should each record be called’ dropdown:

when I do that I have a dropdown list with limited options not including country

in your previous message?

 


Hm might be a translation related thing and Airtable doesn’t have as many options in French?  I’d recommend opening a support ticket with Airtable directly to confirm!


@Dan 

You are much better off rebuilding your form in Fillout’s advanced forms for Airtable.

Fillout is 100% free, it communicates directly with Airtable, and it lets you rename those buttons to whatever you want them to say.

Please see my screenshot below to see how easy it is to rename those buttons in Fillout.

Fillout also offer hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a formcreate custom PDF files from a form submissionaccept payments on formspre-fetch dynamic data from an Airtable recordcustomize the style and branding of your formcustomize a theme for your form, display Airtable lookup fields on forms, create new linked records on a formadd a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld