Top 5 Ways to Make Dropdown Lists in AppSheet 2024 | Best 5 Methods

[@jimarnoldhuya9113]

You got a new subscriber!

[@FullOfSheets]

Thank you! I appreciate it! 🙏

[@alialsamer4423]

great tutorial thank you

[@FullOfSheets]

You are welcome!

[@ChrisGibbings-zx1yi]

Very clear and well structured. Thank-you!

[@FullOfSheets]

You're very welcome!

[@AmelaidHoumadi]

Un très bon tutoriel. Merci beaucoup !

[@FullOfSheets]

Vous êtes les bienvenus. Merci d'avoir apprécié.

[@jerichodistor1948]

Galing po ninyo sir!! 🇵🇭 Salamat sa tutorial sir!

[@FullOfSheets]

Thanks, kapatid! 🇵🇭

[@hermawanyulianto2645]

it is a cool tutorial, many thank

[@FullOfSheets]

You are welcome. Please let us know your suggestions on what we should cover next.

[@sajinj2457]

This video really helped me to fix my view❤

[@FullOfSheets]

Glad it helped. I hope you subbed. 😁

[@denzilsnyman3258]

Nice and clear

[@FullOfSheets]

Thank you. Do you have any suggestions on what you want me to cover next? What do you want to know more about?

[@senthilramadhurai7616]

Yes ... Kindly make videos on how to make the the googlesheet (as a result of Google forms reply) as data source table for appsheet

[@FullOfSheets]

Awesome. I've got that in the pipeline. Thanks.

[@miguemonfort5058]

great tutorial! How can you make the dropdown display in alphabetical order?

[@FullOfSheets]

You can use the ORDERBY() formula in the Valid-If column setting

[@senthilramadhurai7616]

Thanks cleared my doubts about dropdowns

[@FullOfSheets]

Happy to help

[@senthilramadhurai7616]

How to show a table or a list of values based on a drip down selection

[@FullOfSheets]

What do you mean? You are currently on a form, right? Then you selected from a drop down? And you want to show a table in the form?

[@FullOfSheets]

@senthilramadhurai7616 Please elaborate your question because I want to answer it. ☺️

[@senthilramadhurai7616]

@@FullOfSheets nice of you to show eagerness to help ... But till now didn't know where to check replies to the question that I have raised in KZbin. My question is ...... On selecting a year from a drop down, want to show the list of students (in a table) who were in the nominal roll of the school in that particular year

[@janitashelton]

You are a very good teacher. Thank you and good luck with your channel.

[@FullOfSheets]

Thank you for the nice words. 😊

[@hegekrisz4787]

Fantastic video, very helpful. Thank you very much. So the dangerous one is the REF Drop down list. In my case i have Order Table and Customer table, if i make an Order its easy to pick up a Customer with Ref method cause there is a option "New" if its not the list, but if i delete one Customer thats gonna be affect the whole Order List. I think in my case best option is Enum Valid If method , what do you think? Or hide the DELETE button ? :)

[@FullOfSheets]

The order will be affected if you delete the customer if you tick the "is a part of" checkbox of the Ref column. If you leave it blank, then your order will stay stafe. Enum-Text+Valid If works fine if you do not need dereferencing. If you do, then use Enum-Ref +Valid If

[@hegekrisz4787]

@@FullOfSheetsThank you very much finally i decided to use just REF (cause i realised , i made a mistake and ticked "is part of it" if i choose "Ref" with Source Table "Customer" somehow i have a option to add "New" Customer meanwhile im picking up the new order , its fantastic , you are very helpful , thanks again :)

[@FullOfSheets]

You are very welcome. Thanks for your support!

[@bryanbontuyan3409]

Hello do you have a video using dynamic enum for time to avoid double booking?

[@FullOfSheets]

Do you need a dynamic enum or jist a validation that the date has not been used in another entry?

[@bryanbontuyan3409]

I was thinking of having the enum change its choices depending on the date and time available, example if i select the date it would only show the available time slot

[@FullOfSheets]

Is your timeslots Enum values being pulled from a separate table or did you supply the values manually in the enum's column settings.

[@anilshakya522]

Yes master how to add column and row from Appsheet App

[@FullOfSheets]

Appsheet follows the column structures of your underlying google sheets. So you have to add columns in the actual sheet, then regenerate your Appsheet table to reflect the changes. What did you mean by adding rows? A row is added when a new record is saved via an Appsheet form.

[@jso3620]

Great job The 4 TEXT - Valid if method only works for me if in the Valid If I write the expression: IN([_THIS], Cities[CityProvince]) Yes I use it: Cities[CityProvince] In the HOME_Form View the TEXT-VALID IF field does not appear. I don't know if AppSheet has changed something or I'm doing something wrong.

[@FullOfSheets]

Did you also create the first three methods before you did the Text-Valid If? If yes, that's the reason. Bec if you already setup a Valid If using the same Cities table in a prior column, Appsheet will think you are creating a Dependent Dropdown. (You can see this in my other video about Dependent Dropdowns). Setting up.a Ref to the same Cities table in a prior column will also affect this. So if you check back my video on the Text-Valid If, you can see that I removed the Ref column and changed it back to Text. I also removed the Valid-if of all the first 3 dropdowns in order to make the Text-Valid If work.

[@jso3620]

@@FullOfSheets Makes sense. I will test it and give confirmation if so.

[@FullOfSheets]

Great. Let me know if it works. ☺️

[@jso3620]

@@FullOfSheets Indeed the problem was caused by the definition of the previous columns. Thank you so much.

[@FullOfSheets]

Glad it helped.

[@constars9712]

In the last method combining two columns for suggestion dropdown is not working why so?

[@FullOfSheets]

The last method is the text + suggested values. What did you mean by combining two columns?

[@alessandrozorzet7485]

salve. molto interessanti i tuoi video. Vorrei fare una dropdowlist in cui gli elementi scompaiano una volta scelti, mi spiego meglio: da una lista predefinita vorrei poter visualizzare gli elementi una sola volta. dopo aver eseguito la scelta per un record vorrei non vederli più. è possibile? Grazie

[@FullOfSheets]

Yes. I think it is possible. You will need to ise the Text + Valid If or Enum-Text + Valid If. The secret will be in the Valid If expression. Let's say you have a Main table where you want to put the dropdown called City. Then you have a Cities table where there is a column called CityName. In your Main table's dropdown, the Valid If expression will be: Cities[CityName]-Main[City] Meaning you are telling appsheet to get all the CityName from Cities table minus all the City already selected in the Main table.

[@harshmaurya200]

Method 1 is not being applied for multiple Columns. Can you please help me out?

[@FullOfSheets]

What do you mean by multiple columns? Method 1 is for manually adding the option values for the dropdowns. The dropdown is in itself just a single column.

[@harshmaurya200]

@@FullOfSheets So I have a sheet in which there are 6 columns and I want that all those 6 columns as drop down in 6 different form fields Issues: 1) I cant see all the data from that particular column in the form as dropdown. 2) there are few rows which are empty as the columns have uneven number of data.

[@FullOfSheets]

Ate all those 6 different dropdowns dependent on each other? If not, then you will need to break that sheet into separate sheets. Or create 6 slices from that table, selecting only one column at a time. Then, use the slices in your Valid if expressions. This is because AppSheet would think that you are creating a dynamic dependent dropdowm of they all are in the same table. See my video about dependent dropdowns to understand what I'm talking about.

[@ariefugi2000]

does appsheet have event like in html ? onkeydown / onkeypress, ie: we have price, tax, total amount coloumn, when you change price by typing number in real time total amount also change, tq

[@FullOfSheets]

The only event appsheet has would be on form save/submit. But you can simulate onChange() calculations using expression or formulas. It's just like spreadsheet formulas, but instead of cells (ie A1, A2), you use the actual field/column name. It will then auto calculate when values of the related fields change. This is WAAAYYYY easier than doing html js events.

[@ariefugi2000]

@@FullOfSheets ok, I'm afraid when I submit/save button the column total amount value wouldn't change,, 😞, One question again, does AppSheet could make trigger when I save table a, table b also could save, table b is log for saving any action like CRUD

[@FullOfSheets]

If the value does not change when you submit the form, it means that the formula you added is not a column formula. Are you sure you did not put it as an initial value? If a formula is entered in the column (the first box in the row of the editor view), that field should become read only in the user form. If it's still editable, then that means you did something wrong. On your second question, yes it is possible. You will have to make an Automation bot with an event monitoring all changes to the table. Then the process of the bot would be a data task using "Add another row to another table using values from this row". Many developers use this to create log records of user activities. Although you can actually already see logs using Appsheet's built-in "Monitor".

[@ariefugi2000]

@@FullOfSheets many thanks brother,,, very helpful/useful answer,,, see u,,

[@FullOfSheets]

Glad it helped. 😊