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

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 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!