Limiting Drop Down options in a Field

[lou2]

I am creating a form for our website that I will need external users to fill out. I want to minimize user input error so I have created a table with state names/abbreviations to link to the form. When they start to fill out the state it populates options they can pick, but is there a way to make this look better by eliminaing showing where the data is going (it shows 'Leads' the table where it is going and I don't want customers to see that). Or is there a way to easily upload the state abbreviations that I have in the table without manually entering them all as a single select drop down option?

Last question, I love the look of the interface form but from what I can tell this is not something you can share with outside airtable users via our website? Other than having them creative an airtable login, is this correct?

[Dan_Montoya]

Hi Lou,  you can easily copy all of the state abbreviations to a single select field since this will be static data.  Then I would use an automation that updates your linked record when the single select changes.

[TheTimeSavingCo · Accepted solution]

Ah, forms don't show the extra data, so you don't have to worry about that.  Try opening the form itself and looking at it
Here's my table:


And here's the form's linked field:

---

re: Interface forms

Ah, users without Airtable accounts can access Interface forms fine; it's an option when sharing them

And here's the base

[lou2]

Mine shows every option greyed out except for "only users with base access". Is this something I can change with a setting?

Appreciate your help!

[TheTimeSavingCo]

Hm, if I were you I'd look into workspace / account permissions and such?