I understand that you’re looking for a quick script to fill records’ values with “N/A”, but I wanted to share this in case this could work for you:
In the Records view of the Builder for your table, you can update your records like the following screenshots show. I don’t know how many fields you have, but if you don’t have that many, this process could work for you:
Was looking for an approach using javascript/css. The client wants all the boxes in the table to say N/A instead of being blank, and a number of these fields are “numbers/currency” fields where “N/A” would be converted to “0.”
I would create a new number or short text field and add conditional rules to it. This new field would be what you show in the grid. So the conditional rules would be something like:
If (original field) is not blank, use (original field).
If (original field) is blank, “N/A”.
No need to use any code with this approach.
Although support keeps telling us to de-complicate our objects, so I’d like to avoid physically filling extra rows in the DB if the solution can be created with css/js code.