Just wasted 15mins debugging a dependant drop down. The issue was the column type had change AUTOMATICALLY from Text to Number. Despite the data it was pulling in was clearly text only
Iโve had this happen numerous times now over the past few weeks. I go into a column to edit something, come out, then notice the type has changed. Never used to do this
There are bug reports going back to at least March reporting this
Apart from when you add an entirely new table or regenerate a new column in, I see no reason for Appsheet to change column types itself
I too would like to see this fixed. Iโve written about it more than once in the past. Hereโs the latest post I could find:
@Aleksi this is happening to me again. Was this ever fixed?
Perhaps this is why things have started getting weird in apps; things that once worked now donโt. Column types are changing.
It happens when I save the expression builder; like when youโre first building a virtual column - the system analyzes your formula and guesses the column type - except itโs doing it on physical columns that have been there forever.
#NotAFan
It would be nice to be able to disable any function that might automatically change the column type.
@MultiTech_Visions Would you please send this to supprt@appsheet.com so we could investigate it directly from your app, thanks.
Just got through with an email string from support: This is intended behavior and will continue to operate this way.
I had always thought about the auto-column-type setting thing along the same lines as the initial value formula space we have in appsheet apps; itโs evaluated when things are first created, but once itโs saved its set - and if you manually change it then itโs 100% manual from then on.
This was incorrect.
Anytime you save the app formula, not sure about initial value, appsheet will reevaluate what column type it thinks the column should be based on your formula.
In my case here, I have a long conditional branching IF() statement that pulls in data from different parts of the app based on certain criteria; one of these is a decimal type, and since I didnโt wrap that part in TEXT() or CONCATENATE() the system picked up the decimal and set the type to that - I need the column to be text for display purposes.
Wrapping TEXT() around the [Decimal_Column] part worked, because now all the branches of my IF() statements are all the same type: text.
This is very useful information, thanks for the heads up.
Note that TEXT() may reformat its input, so better to use CONCATENATE().
All good to know for future.
Thanks a lot! If you have time, it would be great if you could post the same information (adding @Steveโs point) in the โTips & Tricksโ category. I think that more people will see it there, particularly as time passes. In terms of content, it definitely fits the category. Great tip!!
I had mรบltiple columns with the same example that you mention.
I had thouse in virtual, and it always give me trouble.
Try to do it in non virtual, that solves part of the issue.
The IFS should get the data from non
Virtual columns, if virtuals are are the columns with complex calculation may be you will have some trouble when data row is updated.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |