Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 11, 2020 12:56 PM
Hi, I copied Airtable’s Currency Conversion Import script and kept everything the same except renamed the table and fields to the following:
const table = base.getTable(‘Currencies & Exchange Rates’);
const conversion_field = ‘USD → Currency (Non-Static)’
const currency_code_field = ‘Currency’;
I’m currently getting the following error message when I try to run the script:
What’s the issue here and how can I fix this? I have extremely limited JavaScript skills, I only know what I’ve used by copying other template scripts. Pasting the full script below in case helpful.
Continuing the discussion from Currency Conversion Scripting Example:
Solved! Go to Solution.
Nov 11, 2020 02:00 PM
I would suspect that this is because someone has put permissions on your ‘USD -> Currentcy (Non-Static)’ field.
If you right click a field, a dropdown, such as the one above, will pop up and if you click “Edit field permissions”, you can see what kind of controls have been placed on your field.
If you’re not able to change this, I would contact the creator of the base and request they change the permissions.
Hope this helps. Good luck!
Nov 11, 2020 02:00 PM
I would suspect that this is because someone has put permissions on your ‘USD -> Currentcy (Non-Static)’ field.
If you right click a field, a dropdown, such as the one above, will pop up and if you click “Edit field permissions”, you can see what kind of controls have been placed on your field.
If you’re not able to change this, I would contact the creator of the base and request they change the permissions.
Hope this helps. Good luck!
Nov 11, 2020 04:03 PM
Wow, I admittedly had not thought of that. That was the issue, thanks!