Good afternoon everyone! I’m trying to create custom currency conversions for a project I’m involved with. We’re traveling around the world selling concert tickets at the door of the venues, and each country has a different currency. I want to be abl...
Good afternoon everyone. I’m trying to create a field that calculates the appropriate pay given the work type. In my case, there are 3 different work types, (1. Booked gig, Not booked gig, and Custom Rate).
In case 1 where it’s a booked gig, the base...
Hi. I’m trying to use DATETIME_Format() inside of a formula field to display the day in which an order was placed.
These are the dates of the orders. For reference, the 18th took place on a Sunday.
The formula block is a very simple DATE_FORMAT() f...
Hey coding wizards. My company is using Airtable forms to manage customer orders inside of a club. When a new customer fills out a form, there is an “Email Address” field as well as a “Confirm Email Address” field. After the form is completed, an Aut...
@Hendrik_Yang , thanks for your suggestion. I’ve replaced the lines below. My console is giving an error saying “your script has invalid settings defined”. Screenshots below:
Hey there @Vivid-Squid , thank you so much for your solution! Only one problem that I’m currently experiencing: It seems that when i select a record via “choose a record”, it uses that currency exchange rate for all of the other currencies in the dat...
