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.
hey everyone,
I’m not sure why but I’m getting an empty result when using filterbyformula with a date function. I’m trying to receive all records that hold a certain date in a certain field. The field also might be empty on some records just if that ...
Hey community,
I wanna sync some customer data that I hold in Airtable with other services (poor man’s CRM kind off). My plan was to use Zapier to do some stuff when a customer row changes. Unfortunately this is not an option out of the box. Only for...
Hey everyone,
I’m fighting with a thing that I wanna do with airtable:
Table ‘customers’ holds all my customers information
Table ‘orders’ holds all orders with all the order information
Table ‘catalogues’ holds all catalogue orders (as they are vast...
Hey,
for our little CRM I’m trying to builds something based on customer revenue based on time. Like sales generated within the last 12 months.
I don’t want to calculate that on a daily basis but only check once a month on the last 12 months. I do ha...
Hi,
my google api account has billing activated and I don’t see any reached limits on the Google side. Still I’m getting API limit errors on the Maps Block when trying to geocode 4000 addresses (after every 200 or so).
Any idea why this is happening?...
I’m not an insider but I’m guessing a lot of the performance is just due to the way Airtable works - a lot of stuff is happening in the browser and all the data has pushed forward and backward from and to your browser. I’m not sure if more CPU cycles...
Thanks for helping again. I‘m only on my phone now so only can check your example later but I think our man confusion really is the order table that does not exist. It was my error to put it in the initial question as it is not used for this problem....
Hey @AlliAlosa ,
sorry for my late reaction - I was busy with some other stuff and only now came back to this. I’m not sure if I can follow your advise. Let’s cut out the orders table for the moment as this isn’t really involved in the example.
So I ...
hmm but then only if it’s .com, right? I’d better not rely on that. But good idea trying to catch that / - I was also thinking about trying to remove paths in the URL
I’m not a big formula pro yet but I tried it out and it seems to work:
MID(
URL,
IF(
SEARCH('//www.', URL),
SEARCH('//www.', URL) + 6,
IF(
SEARCH('//', URL),
SEARCH('//', URL) + 2,
IF(
SEARCH('www.', URL),
...