# How to populate field that reference other table using workflow

**URL:** <https://forum.bubble.io/t/how-to-populate-field-that-reference-other-table-using-workflow/138417>\
**Category:** Need help\
**Created:** [February 26, 2021, 4:03pm UTC](https://forum.bubble.io/t/how-to-populate-field-that-reference-other-table-using-workflow/138417 "2021-02-26T16:03:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tadeu.msv](https://avatars.discourse-cdn.com/v4/letter/t/7bcc69/32.png) [@tadeu.msv](https://forum.bubble.io/u/tadeu.msv)\
**Post date:** [February 26, 2021, 4:03pm UTC](https://forum.bubble.io/t/how-to-populate-field-that-reference-other-table-using-workflow/138417/1 "2021-02-26T16:03:55Z")

</div>

I have the basic user table with email (type email) , age (number) and function (that references the table function \* that is populated with 3 options ). I can use inputs to populate a new user data (email and number) , but when it comes to the function i think i would need a dropdown to use as “input” (however i wan’t to populate it using only the workflow background - no dropdown). Is it possible ?

---

<div class="post-metadata">

**Author:** ![cmarchan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/cmarchan/32/253062_2.png) [@cmarchan](https://forum.bubble.io/u/cmarchan)\
**Post date:** [February 27, 2021, 5:30am UTC](https://forum.bubble.io/t/how-to-populate-field-that-reference-other-table-using-workflow/138417/2 "2021-02-27T05:30:49Z")

</div>

Not sure what you are asking …”using the workflow background “

Could you elaborate please?

---

<div class="post-metadata">

**Author:** ![tadeu.msv](https://avatars.discourse-cdn.com/v4/letter/t/7bcc69/32.png) [@tadeu.msv](https://forum.bubble.io/u/tadeu.msv)\
**Post date:** [February 27, 2021, 4:28pm UTC](https://forum.bubble.io/t/how-to-populate-field-that-reference-other-table-using-workflow/138417/3 "2021-02-27T16:28:21Z")

</div>

Thank you for the reply.

EX: If you make a table (user) and make a field (role - not a list) that references another table (roles table —\> which has fields : role name ; description)

The only way i found to fill (populate) the field (on the users table) that references another table (roles) was by using the “search for” on workflow and by selecting the “first item”. I wanted to make it possible without the need of ui dropdowns as a choice picker.

I want to know more about these workflow expressions, because some of them return text and others yes or no (the wiki talks about them , but i want to see more of a practical application as i am kind of lost on them).

---

<div class="post-metadata">

**Author:** ![cmarchan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/cmarchan/32/253062_2.png) [@cmarchan](https://forum.bubble.io/u/cmarchan)\
**Post date:** [February 27, 2021, 4:59pm UTC](https://forum.bubble.io/t/how-to-populate-field-that-reference-other-table-using-workflow/138417/4 "2021-02-27T16:59:44Z")

</div>

You are welcome!

These 5 short videos by @TipLister may help putting together most of the different concepts needed to sort out your problem:

[![](https://img.youtube.com/vi/LsPDqfWoJ6M/maxresdefault.jpg "Bubble Basics: Understanding Databases & Backends 1/5") ](https://www.youtube.com/watch?v=LsPDqfWoJ6M)

[![](https://img.youtube.com/vi/3lWLXK7LBpQ/maxresdefault.jpg "Bubble Basics: Creating & Joining Databases on Bubble 2/5") ](https://www.youtube.com/watch?v=3lWLXK7LBpQ)

[![](https://img.youtube.com/vi/3UHstzkFPy4/maxresdefault.jpg "Bubble Basics: Inputting & Joining DataTables on Bubble 3/5") ](https://www.youtube.com/watch?v=3UHstzkFPy4)

[![](https://img.youtube.com/vi/3-KYiXm4aCo/maxresdefault.jpg "Bubble Basics: Joining Databases 4/5") ](https://www.youtube.com/watch?v=3-KYiXm4aCo)

[![](https://img.youtube.com/vi/7jzpKI-V32I/maxresdefault.jpg "Bubble Basics: Editing & Displaying Joined Data 5/5") ](https://www.youtube.com/watch?v=7jzpKI-V32I)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [May 7, 2021, 4:04pm UTC](https://forum.bubble.io/t/how-to-populate-field-that-reference-other-table-using-workflow/138417/5 "2021-05-07T16:04:44Z")

</div>

Closed on May 7, 2021, 4:04pm UTC

This topic was automatically closed after 70 days. New replies are no longer allowed.
