How to update a field in flow designer using script?

[Swarnarghya]

I have created a schedule trigger flow which will run and send email reminders based on the lookup done on approval table. Now in the approval table i have created 2 fields named number of reminders sent of type integer with default value of 0 and last reminder sent. 

Now whenever the schedule will run these two fields will be updated. The number of reminders will be incremented by 1 and last reminder sent will populate the current date.

How to do it? Do we need custom action for this?

[Astrid Sapphire]

Hi there,

You should be able to just use the Update Record action in a loop, after you’ve used the Send Notification/Send Email action.

Kind regards,

Astrid Sapphire

[Tushnik Chakrab · Accepted solution]

Hi Swarnarghya,

You could use fd_data._2__for_each.item.<field_name> for extraction .

You could follow this link for inline scripts in flow designers.

https://docs.servicenow.com/en-US/bundle/tokyo-application-development/page/administer/flow-designer... 

Regards,

Tushnik