Update a field(date field) on row to blank value

Hi

I’m trying for a framework action to accomplish the following:

Update field on row

I want to update a Date/Time field (same issue for date field) to a blank value

I looked at this post: https://community.skuid.com/t/best-way-to-set-value-of-field-to-null-blank, but none of the simple methods listed work for date fields

1- the reference to blank UI , would not work for Date fields

2- Using {{blank}}, does not work either

Would there be a simpler way than to use JS?


Thank you,


I believe you can use the value of a ui only text formula field which has just “” in it. {{blankText}}

Hi Pat, and thank you

How do I use that value?

As soon as i select a date field for action: update a field on row , it only give me the choice to input a specific date , or use of the “predetermined” ranges.

Where would I reference the UI field?

Ah yes. A date field. Pretty much can only do this with a snippet.

I’m trying to create a mass update action that will clear a date field, but I’m running into this same issue. Is a snippet still the only way to make this work?

Hi Sarah, unless something has changed recently on skuid, the only way i found it possible with pat’s help, is a snippet.

Here snippet I use on a a single record, you will prob need to modify it to use for mass update as this 1 only does it for first row

Create a In-Line Snippet :

var $ = skuid.$, model = skuid.model.getModel(‘AccountCover’), row = model.getFirstRow(); model.updateRow(row, {API NAME FIELD GOES IN HERE’});

Hope it helps

You can use Pat’s {{blankText}} approach in the first response, you just have to trick Skuid into it:


  1. Instead of selecting a Date field, select any text field as the one to update.
  2. Enter {{blankText}} (or whatever the name of your blank ui-only formula field is)
  3. Now select the actual Date field that you want to update to blank.
You will still see the date picker in the ui, but don’t touch it. The XML behind the scenes will be set to update the field to blank.

You can do this with any date or datetime field update:
https://community.skuid.com/t/support-merge-syntax-for-date-and-datetime-fields-in-af-upd…

Sneaky! Thank you!