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:
- Instead of selecting a Date field, select any text field as the one to update.
- Enter {{blankText}} (or whatever the name of your blank ui-only formula field is)
- 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.