I have a form called "New Request" and a stateless form called "Update Request Status". In Update Request Status, I have a field called "Task Pending Notes" - here, the user will fill in the notes and upon submission, this will save the notes into "Task Pending Notes" in New Request, along with a timestamp. This happens every time new notes are submitted, and they are saved, collectively with each note and timestamp in "Task Pending Notes" in New Request. This is also auto-populated into Update Request Status in "Task Notes" when the user enters the Request Number into the form to bring up the Request details. (The user will continue to enter new notes in "Task Pending Notes" in Update Request Status.)
I am having an issue with "null" being displayed in "Task Notes" when the Task Pending Notes is not being filled out. There are many steps to my form, so I don't want it to keep displaying "null" everytime a previous step is being completed.
As well - I have the Request details emailed to staff members at various stages of the Request prior to being completed. The email shows "null" in number fields. What can I do to make it show a blank space instead of the word "null"? (The "null" in this instance, does not show up in the report itself, just in the email.
Thank you in advance!