Hi everyone, my question is about enumlist order selection. I want to build a quiz app to recompose a phrase word by word. In my enum list the words are mixed and I hope there is a way to them organised in the order of selecting them. Here an example:
Enumlist: is,today,beautifu,very.
I want to ricompose it in order of selection because now appsheet will recompos the same order even If I push first today,is,very,beautifull it will recompose is,today,very,beautifully.
Any suggestions??
In an EnumList dropdown, there is no way to be able to detect what order the items were selected. You will need to come up with an alternative approach.
One simple idea, is to list each word as its own row in a table view along with a column that specifies the word order. The user would enter the number of the order the words should appear and save. You could then have these attached to row with a Submit button that checks the answer. See images below.
A variation on the above is to have Arrow buttons in the rows that a user can tap to move the rows up or down and change the order. There was an example of this submitted by @MultiTech some time ago, I’ll see if I can find it…or he may just chime in here! Matt??
Example of phrase words as rows in a table
After placing table into Edit mode users can insert a number to specify the order and then tap Save when done.
Found the post
I appreciate your answer but I can’t believe there’s no other way. I hope some appsheet bigbrain reads this post to give us this possibility or some other way ( one way could be to have a button like in the editor to move the words directly in the enumlist popup ). Thank you very much Willow.
You’re Welcome!
I can guarantee you that there will not be any way to use the EnumList dropdown in the way you are suggesting. You will need to find another approach in AppSheet or find another tool that maybe can support what you have in mind.
You could set up your table with some number of generic columns, like [word1] , [word2] , etc. Enough to accommodate for your longest possible sentence. With another column to hold the comma-separated list of possible words. Each of the [wordx] columns would be an Enum, displayed as a button, with a valid_if of LIST( INDEX( [words] , x ) ). Then have a final column that will concatenate together the words as they are selected, probably with some fancy usage of reset_on_edit and an initial value expression. Or perhaps just some inline-attached actions. Might need to display this as a quick-edit detail view instead of a form. Not an easy setup for sure, and there are a few important details that I left out, because I don’t feel like putting that much effort in here just now.
My suggestion is to use two long text columns with a table view.
The first is the LIST of scrambled list of words, which is presented and not editable or required and the second is a long text input where the user may enter the words in the “correct” order. In this way you may have any number of rows with various scrabled lists of words and the user selects any row and the row list of words will be presented and then using the enable Quick Edit table view feature the user may edit any row and enter their response.
Below is the spreadsheet table with scrambled words in col LIST
The APPSHEET TABLE VIEW
and the browser view
Now the user clicks on any row to edit and one gets
One may now edit and one gets
After save one gets
This works but is far from the real deal just to show that ENUM is not required and can just complicate one’s life in terms of no-code development.
