How to show drop down from ref column and save user choice at the same time?

[YotsubaT]

Hi community,

Just updated my post to make it simpler. I'm working with 3  2 datasets:

• a. to read from
• b. to write to
• c. has one column "name" for user to choose from.

I need to do below things in action of clicking a button from detailed list of table a (if possible):

1. show a dropdown of Enum column "name" from table c  b
2. record user choice in table b - column "assigned_name"
3. pass value from column "product" from table a to b

I have completed setting up a button and number 3 successfully. Could someone please help me with 1 and 2? Potentially need to set up ref column in table a? 

[Steve]

What is the problem you're trying to solve in plain English?

[YotsubaT]

Hello Steve,

I'm working with 3 datasets and want to improve how users interact with them. When a user clicks a button in one dataset, I want to show them a dropdown list of names from a second dataset and let them choose one. After the user makes a selection, I want to save their choice in a third dataset, while also copying over some related data from the first dataset.

I've already set up the button and successfully copied over the related data, but I need help displaying the dropdown and saving the user's selection.

Does that clarify a bit?

[Steve]

---

@YotsubaT wrote:

When a user clicks a button in one dataset, I want to show them a dropdown list of names from a second dataset and let them choose one.

---

Maybe INPUT()?

[YotsubaT]

I've tried INPUT() but the dropdown would not show. I've tried to link to the view of the dropdown, but could not pass value at the same time.

[Steve]

Why not open a form view on a row in table B that shows only the assigned_name column that allows the user to choose the name, then use the App formula of another column to fetch and record the product value from table A?

[YotsubaT · Accepted solution]

Thanks for the help! I've figured it out by using LINKTOFORM() to pass value while creating a deep link within the row as well as saving user's choice in the form.