AnsweredAssumed Answered

Auto-Enter "N/A" in Empty Fields

Question asked by bt22true on Jan 17, 2011
Latest reply on Jan 17, 2011 by philmodjunk

Title

Auto-Enter "N/A" in Empty Fields & Count Fields without "N/A" Entered

Post

Hello,

I'd like to be able to create a script that on finishing data entry and creating a new record, will automatically enter the text "N/A" in any field that is empty. How can I go about doing this in a way that doesn't require that I do a massive If calculation?

Also, once I have that set up, I'd like to have a field automatically count how many fields do not have "N/A" written in them. Is there a way to do this?

Outcomes