You’re offline. This is a read only version of the page.
Announcements
31
Hi Team,
I am needing a little assistance with my formula. I have made a Collection with a bunch of words all with different word Lengths from 1 all the way to 8. I have two input text fields that show a random word within it once a button is pressed. What I am trying to do is only show the words that are equal to the input number of characters within the word. I am also trying to make it add both Input text boxes together based on the character. Please find an example below of what I have done. I can only get the output to show both words combined and it cuts off the second word if it's longer than the value.
I dont know if i understand what you asking the right way but you can try this.
Add another Collection
Share
Report
All responses (
Answers (
ClearCollect(
WordlistWithLen,
AddColumns(
Wordlist,
"Length",
Len(Value)
)
)This will give you the word and associated length, i added a wordlist to show the result
You can filter this list based on the length you select. i will do this with a drop down and i will add a label to show the response.
add a label and set the test as follows:
Concat(
Filter(
WordlistWithLen,
Length = Dropdown1.SelectedText.Result // in your case this will be the texy box with the length
),
Value,
" "
)(i chose a dropdown so the user do not enter a length that's not in the wordlist.)
Result
Hope this he helps,
R
