Set Field Empty

[mdfOffman]

Please:

How do I Set Field by Name [FieldName ; empty]?

Thank you 🙂

[comment]

I am not sure I understand what your question is. If you are asking how to specify an empty result (i.e. the equivalent of clearing the field), set the field to the calculated result of:

""

Make sure you use the Set Field by Name[] step for a good reason. And if so, that the script is protected against failing when a field is renamed.

 

[mdfOffman]

Many thanks.  Actually, when I stopped thinking about it, the thought came to me to try "=" and that seems to work too.

 

[comment]

4 minutes ago, mdfOffman said:

the thought came to me to try "=" and that seems to work too.

I don't think so. What type of field is your target field?

 

[LaRetta]

I don't quite understand the request.  Are you trying to FIND records with empty values?  Or are you trying to remove values from a field in browse?

"=" works if trying to find records with empty values.  I think we need more information.

[comment]

9 minutes ago, LaRetta said:

if trying to find records with empty values. 

Ah. That would indeed makes sense. But then my suggestion would not work - so "that seems to work too" cannot be true.

 

 

[LaRetta]

That's why it was confusing me.  

Spoiler

 

Edited April 10 by LaRetta