This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Not sure this is possible but I can’t seem to get this to work when I add the second part. I have a formula that works this way 'If Base Rate = 0 and IF UM= “Pounds” then Weight / 2000 * Price, IF Base =0 and IF UM= “Kilograms” then Weight / 2200 * ...
I have a table that each record has an effective date that contains data that changes weekly. Is it possible somehow to have the data tied to those records to be view as historical data? My first thought would to be copy the table and date it, but ...
I know this is simple but I’m struggling for some reason. {Average Weight}/2000 * {Base Rate} + {Surcharge Calc} It adds the ‘Surcharge Calc’ which is a percentage just as a number.
What I’m trying to accomplish: Average Weight = 10000, Base Rate...
I can’t seem to figure this out. Here is what I’m trying to accomplish. When A Record Matches a Conditon In Table 1, then Update Record in Table 1 (Field 1) with data from Table 2 (Field 1). Is this possible using the automations?
Esssentially wha...
I’m not sure this is possible. I’m trying to multiply the amount of an item by a range with an attached percentage. For example, if the fuel price is $5.00 then the range is $5.00 - $5.25 and the percentage is 2%. Then multiply the Freight Amount ...
I understand what you are referring to, but this logic seemed to work better for my project. I did figure it out, I had to create two actions, one to Find records to locate the field in table 2 and then Update records to place the data in the correc...
I’m not sure how to make that Link Record field work with the drop down? The Policy in table 2 is a numerical value from a formula that will used to compute data on Table 1
Okay, maybe for the future I would like to learn how to do it myself, but for this particular project I think I would like some help developing this particular script.
Thanks Justin. I would like some help on doing it myself. I have some coding experience but have never worked with JavaScript. I am new to Airtable as well, but I have gotten quite familiar with it over the past few weeks. I’m using integromat to...
