Crow Canyon Software Forum

Crow Canyon User Community ForumNITRO Studio: Forms DesignerLookup Column Auto Fill

Please or Register to create posts and topics.

Lookup Column Auto Fill

#1 · September 26, 2023, 3:47 pm

Hello,

I have a lookup column from another list, that I would like to auto fill once another column is triggered.

My current setup right now is that the lookup column is a drop-down and i would have to manual click the lookup column for the item to appear. How can I do that?

I also tried having the lookup as a single line column instead, but it's giving me a blank area.

I've attached an image of what I'm working on.

The left column are my entry, the 2nd column(PRICE), is what I want to auto-fill and lookup.

Uploaded files:

#2 · September 28, 2023, 5:57 pm

Hi @anguyen,

Please configure form event actions in the NITRO Forms to fill a column based on value selected in another column.

Manual: https://www.crowcanyon.info/nitro/appmanual_v2/index.html?form-event-actions.html

Example: Please refer “Form Event Action 2: Update total budget” section from the article below:

https://www.crowcanyon.help/article/686/

In this form event action, we are fetching an item from the Departments list (query list) and then updating ‘Total Budget’ column of current list with the value in ‘Cost’ column of fetched query list item.

Please let us know if this is what you are looking for. If not, then please add more details about your use case.

#3 · September 29, 2023, 5:53 pm

Hello,

Thank you for the assist! I did manage to get the lookup column to work. As for the auto-fill, the column that I want to auto-fill is not part of user information, but it is the item lookup. I'm kind of stuck at that point. How would auto-fill and item column after another item is selected?

I've attached an image of what I'm trying to auto-fill after it was selected.

Uploaded files:

#4 · October 18, 2023, 1:38 pm

finally was able to get it popped up! But on another project. For this one, what I did was that the "price" columns where single Number columns. for the 'fountain bundle' lookup column, I was able to update it with 'auto-fill' function when editing the column.