I followed this article:
According to the article, if I use the expression ISBLANK([_THIS]) inside of the data isEditable? field, then once a user enters in a value and saves, the field becomes uneditable. However, Once you enter a number value, it instantly becomes uneditable without having to save. I would expect that the field would be editable until you press the save button as the article states.
Am I missing a command?
1 Like
It sounds that you need the field to be editable till it is saved, meaning till the record is not added in the table.
If so please try the below in the editable_if of the column Estimated Time
NOT(IN([_ROWNUMBER], Main_Table[_ROWNUMBER]))
Please take a look at the wonderful tips post by @Steve on detecting a new row being added and a row already existing in the table.
[FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216) Tips & Tricks ?
Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…
2 Likes
Yes! That is what I need. I will try this out and I will read Steve’s tip.
2 Likes