I need to ensure no dates in my base land on a weekend or holiday. I’m trying to use the WORKDAY(startDate, numDays, [holidays]) formula to accomplish this. However… issues. I’m using “0” as numDays since I do not want to add any days if the date alr...
Hello,
I’ve created a table in my base called “Email Templates”. It’s a simple 2 column table. First column: Template Name, 2nd column: URL Formula. In the email template column, I’ve selected a long text field. And for each row, I’m creating test UR...
Is there a way to make the content on a page designer PDF conditional upon the data in your subject record? Example: I am creating a real estate flyer. The page designer template auto-populates “Bedrooms: {no. bedrooms from record}”, Baths: {no. bath...
Hello,
Can one use the URL email formula for the button field to send out an HTML vs basic text email? I believe I saw that I could possibly use SendGrid to do HTML templates. However, I’m not interested in the bulk send out to everyone within a view...
Hello!
I’m new to Airtable and am SO excited at what I’ve seen so far. Thank you for such an amazing platform!
I’d like to use the button field to send a templated email. I see that can be done. Very cool! My question is, can I have the email change ...
I’m so sorry I somehow missed your reply message! I wasn’t able to use a webhook because my HTML was above the amount of data that could be sent. So instead of a button, I used a checkbox to trigger that record into a new view which would trigger the...
Hi! Pierre-Louis_Firre, did you add the HTML code into Airtable so you could use merge fields from Airtable records before sending the final code to Zapier? I’d like to manipulate the code in Airtable using IF Statements (if possible) then send to Za...
Ah-hah! Answered my own question. I can add the “-1” right into that formula instead of using another field:
IF({Feasibility Firm Date (F25)}, {Feasibility Firm Date (F25)}, IF({Feasibility # Days (F25)}=BLANK(), "", IF({Feasibility # Days (F25)}>5, ...
