How to get Enumlist in the Input() function

[Manish_Jain11]

I am trying to create an action to bulk update the vendor column in my purchase table. I want the same enum values in my Input function that I have set for this column in the main table. Is that possible ? I should see the label but store the key just like when we use the add form

[shahappsheet]

I think yes you can.

[Manish_Jain11]

Can you guide how

[shahappsheet]

Please give me an hour

[shahappsheet]

drive.google.com

ShahAppSheetInput.mp4 (video)

Google Drive file.

Please check the link and let me know whether you want to do similar thing. Then I can go to help you. Maybe in your can there will be two combo, one for person list and another for session list. Let me know better through drawing. Thanks.

[shahappsheet]

In your case, i think, there will be one combo list in the input form for the person list.

[Manish_Jain11]

Hi Samiur,

Apologise for the late reply. I want something like this but what I exactly want is a dropdown showing values that I have actually given in my column definition.

[shahappsheet]

Yes. Possible.

[MultiTech]

@Manish_Jain1 You should be able to simply specify the column you wish to use inside the INPUT() function

• If you’ve set up the column with the Enumlist settings, it renders inside the INPUT window
• INPUT("My_Enumlist_Column", "")

[shahappsheet]

Give me half an hour I am showing you.

[shahappsheet]

drive.google.com

ShahAppSheetInputDropdown.mp4 (video)

Google Drive file.

Watch the video and let me know. Video quality is not good.

[MultiTech]

@shahappsheet mate, it’s been answered already…

Did you know....that there IS a pop-up Form available using the INPUT() function? Tips & Tricks 💡

Based on a post by @Joachim_Mund … …I just learned that there is a way to present a pop-up Form to collect additional input from a user. It is with the INPUT() function. I never knew this existed and I don’t ever recall it talked about in any of the posts I’ve read (I don’t read everything ). I thought there is probably a good chance others weren’t aware of it either so I thought I’d pass it along. Basic Usage Create a “Set the values” action specifying the target field…

Using INPUT() to update another table using a value from this row Tips & Tricks 💡

This “Tip” is a little report, with a sample app, on my own attempt to familiarize myself with the new INPUT() function. As @praveen has indicated, the advent of this function gives us the power of an “UPDATE EXISTING ROW(s) using values from this row” action: Here’s a sample app I made to test this out: https://www.appsheet.com/samples?appGuidString=502cc394-2717-4a69-8246-5fc26a1aa9cf This extremely simple app has two tables: one with multiple records and one with only one record. The i…

Add rows to another table WITH parameterized input Tips & Tricks 💡

This pattern comes up more and more, so I thought I’d build a simple example. We already know that you can copy rows using the “add rows to another table” action. But sometimes we want our end user audience to provide some input first. The attached app shows a simple way to do this. At its most basic, the design has an “extra” table whose only real purpose is to allow data entry of a single row of info. This info could then be used when calling the “Copy” action. So… in our fictitious example…

[MultiTech]

Here’s another video

[shahappsheet]

Nice

[Manish_Jain11]

Thank you Everyone . It’s sorted. Appreciate all the help.