# Is it possible to autocomplete fields in a form based on a choice entry?

**URL:** <https://community.glideapps.com/t/is-it-possible-to-autocomplete-fields-in-a-form-based-on-a-choice-entry/71578>\
**Category:** Ask for Help\
**Created:** [March 11, 2024, 6:57am UTC](https://community.glideapps.com/t/is-it-possible-to-autocomplete-fields-in-a-form-based-on-a-choice-entry/71578 "2024-03-11T06:57:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andreea\_Nisipeanu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreea_nisipeanu/32/62787_2.png) [@Andreea\_Nisipeanu](https://community.glideapps.com/u/Andreea_Nisipeanu)\
**Post date:** [March 11, 2024, 6:57am UTC](https://community.glideapps.com/t/is-it-possible-to-autocomplete-fields-in-a-form-based-on-a-choice-entry/71578/1 "2024-03-11T06:57:18Z")

</div>

Hello! I have a question about the form entries. **So is it possible to autocomplete fields based on a choice entry?**

For example, I have a choice entry with the “Contact person” and after that I have other text/choice entries such as “Position”, “Phone”, “Email” etc. So based on the Contact person I choose, I want the other fields to autocomplete.

---

<div class="post-metadata">

**Author:** ![Rien\_Dumore](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rien_dumore/32/79283_2.png) [@Rien\_Dumore](https://community.glideapps.com/u/Rien_Dumore)\
**Post date:** [March 11, 2024, 8:30am UTC](https://community.glideapps.com/t/is-it-possible-to-autocomplete-fields-in-a-form-based-on-a-choice-entry/71578/2 "2024-03-11T08:30:06Z")

</div>

The way i do this. Is to write the choice value to a column in the user profile table. I relate that value to the table used for the choices, and do a lookup for the other values i want to use as autocomplete. then use those lookup values in the user profile table as default values for that fields i want to autocomplete.

As far as i know this only works in form screen. When the fields are already empty, including the user profile choice value. So clear that value when submitted form via set column value and clear user profile choice write value column.

I hope this makes sense, otherwise feel free to ask

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 11, 2024, 9:34am UTC](https://community.glideapps.com/t/is-it-possible-to-autocomplete-fields-in-a-form-based-on-a-choice-entry/71578/3 "2024-03-11T09:34:13Z")

</div>

> [@Andreea\_Nisipeanu](#):
>
> For example, I have a choice entry with the “Contact person” and after that I have other text/choice entries such as “Position”, “Phone”, “Email” etc. So based on the Contact person I choose, I want the other fields to autocomplete.

Is there a reason you have to store position, phone and email as basic columns? If that information is always related to your Contacts table, why do you need to edit position, phone and email separately?
