Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Daily Currency Rates Update (script automation)

Topic Labels: Automations
1031 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Avenilo
4 - Data Explorer
4 - Data Explorer

Hi there,
first of all,
I’m glad to join Your community!

I’ve started exploring scripts yesterday and would be glad to catch some tips from the community :grinning_face_with_big_eyes:

So…
I’ve copied the Currency Converter Script to my Workspace,
Adjusted it to my needs and synced it to my main Base.

And now I want it to Update Daily! :smiling_imp:

After some exploring I came up to a conclusion
that this automation could work when a Currency enters a new view.
therefore, i’ve created a new table with the desired Currencies needed to be up to date,
attached them to a Date field, added Today field with the formula Today(), and automated it to update whenever the Date is not today.

I’ve created a filtered view to show only today’s Date,
Launched an automation to run whenever a record enters this view
And added the Currency Converter Script.

And… Got an ERROR

изображение_2021-01-09_125758

Dear community,
Tell me please,
should I add this Task (Check for new rates) to my Daily routine,
Or this ERROR can be fixed?

Thanks in advance!
:grinning_face_with_big_eyes:

P.S.
I did read the topic which says that Automation Scripts has simplified input/output method, however I did not find any info on how to make this work…

0 Replies 0