Hey community!
I have been trying to use the LOG() or LOG10() function in my app without success.
When I make the virtual column with this function and test it, it works and gives me the value I want.
But when I save the changes in the app, and want to use this function in a form to make dynamic the data. Example LOG([dynamic data]) the app doesnโt show me the form view of the table where I put this virtual column anymore. And when I remove the LOG expresion from my app the form view appears again.
Is there an option to keep this formula and my form view together?
Please post screenshots of the configurations of the columns involved.
THIS IS THE VIRTUAL COLUMN WITH THE LOG FUNCTION
THIS IS ONE OF THE VIRTUAL COLUMNS I WILL USE WITH THE โLOGARITMOโ COLUMN
THIS IS THE VIRTUAL COLUMN WHERE I PUT THE LOG FUNCTION + ANOTHER DATA THAT CAUSES THE BUG. ( THE โCโ AND โMโ COLUMNS HAVE THE SAME FORMULA DIFFERENT RESULT COLUMN.
HERE IS THE TEST OF THE โDENSIDADโ COLUMN SO YOU CAN SEE IT WORKS
AND THIS IS THE VIEW OF THE FORM BEFORE AND AFTER I SAVE THE โDENSIDADโ COLUMN
I hope this make sense to you @Steve
Thank you for the screenshots! I donโt see anything wrong with your configuration, so I would expect it to work. In my experience, that blank screen in place of a form is the result of an internal bug triggered by an Initial value, Suggested values, or Valid If expression in a column of the row in the form. Do any of the rowโs columnโs have expressions in any of those settings? Do any of those expressions contain EXTRACTโฆ(), IFS(), or ORDERBY() functions?
No Steve, actually the columns donโt have more functions in the configuration, just the app formulas that I show in the screenshots and the blank screen is still there. I donโt know why
Iโm at a loss, then! Please contact support@appsheet.com for help with this.
User | Count |
---|---|
13 | |
11 | |
9 | |
7 | |
4 |