Hello!
I recently managed to implement my first predictive model in appsheet. I set it as initial value when adding a new item. The problem is that it sets the inital value (type enum) in small letters even though the enum has a caps first letter.
Is there a workaraound for that? Thx for the help!
Emilio
Solved! Go to Solution.
Perhaps even easier!
ANY(
INTERSECT(
{"Tony", "Emilioudi", ...},
LIST(PREDICT("Your Model"))
)
)
Any Ideas how to fix the issue?
Chiming in @tony
Hi @emilioudi, thanks for bringing this bug to our attention. Weโll work on fixing it.
In the mean time, hereโs a workaround (also known as a โhackโ) that should unblock you for now:
IFS(
PREDICT("Your Model") = "tony", "Tony",
PREDICT("Your Model") = "emilioudi", "Emilioudi"
...
)
Hi @tony your โhackโ worked thank you for that!
although for some columns with the type enum i have more than 30 different values which makes for a long formula
Emilio
Perhaps easier:
SWITCH(
PREDICT("Your Model"),
"tony", "Tony",
"emilioudi", "Emilioudi",
...
)
Perhaps even easier!
ANY(
INTERSECT(
{"Tony", "Emilioudi", ...},
LIST(PREDICT("Your Model"))
)
)
thank you @Steve Steve this is easier, especially for the long columns with a lot of values
Does appsheet not have a function for capitalizing and uncapping letters?
TITLECASE()?
For fun technically:
UPPER(INITIALS(PREDICT(โYour Modelโ))&Right(PREDICT(โYour Modelโ), LEN(PREDICT(โYour Modelโ)-1) should get a title case so long as everything is 1 word right?
There is no TITLECASE() equivalent function.
Your expression would work fine.
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |