Default Value problem
I would like to ask you if you could undestand the reason why I can't set a default value to my numeric fields. Thanks!
6 replies
-
You can,in the settings of the field. But the default value is only created when a new record is created, not in already existing records.
Steven
-
Thanks! Could we define a field when it is empty in Ninox coding?
-
*a formula field
-
Are you asking if a formula field can check if a field is empty and then put some value in it?
If so then yes.
If you have a text field called Field1 and you want to check if Field1 is empty, you would:
1) create a button and put the following in the On Click section:
if Field1 = null then Field1 := "No Longer Empty" end
This will only update the record you are looking at.
Hope this helps.
-
Clicked to fast.
A formula field can't update another field, but a button can. See previous post for 1 option.
If you are doing a 1 time update, then you can use the handy Update Multiple Records function.
If you are needing to check for emtpy field constantly, then a button can be created to do it.
-
Thanks for the response, yes what I just wanted is to check if a field is empty which as you said you can check by ''= null''. It is working! You guys are making such a great job in the community!
Content aside
- 2 yrs agoLast active
- 6Replies
- 462Views