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.
Lately, when Zapier updates attachment fields with images, it briefly shows the attachment, but seconds later it completely deletes anything in that field. Even when there we’re already attachments, it deletes them.
I saw that this problem happened o...
I’m probably missing something, but how do I get the current day of the year? For instance, we have WEEKNUM(TODAY()), but not DAYNUM(TODAY())?
I can do year(today()), and week(today() but when I do day(today()) it shows the day of the month and not t...
For anyone that has been trying to get a formula field to ACTUALLY substitute line feeds, carriage returns, and paragraphs here is a solution I (slowly) figured out.
Use the following formula to URL encode the text, and then substitute the other stuf...
When Zapier is updating a record, it’s adding comma separated records into a linked field. Lately, it is creating duplicate records even though the record exists.
Is there something I can do about this? I vaguely remember running into this issue befo...
I am concatenating multiple fields into one comma separated field, and even though the formula format is 2 decimals, it’s showing as a whole bunch of them in the concatenated field.
I’ve tried rounding but I can’t seem to get it right. Included pic.
I just realized I asked and answered my own post.
Anyway, for inbound to WP we are using an airtable automation script to send a webhook to Zapier, usually based on a “something changed” trigger. This creates or updates the Wordpress posts via WP Web...
@Miquel_Capo_Casasnov I don’t have anything else to say but… I love you.
Okay, I found something. Most of the photos are .jpg, but some are .png. Is there a way to do more than one file type in the “end string”?
I am using webhooks and zapier. On the Wordpress side I’m using a combination of WP Webhooks Pro, and an amazing little plugin called ACF-to-rest-api. This is specifically challenging because of Advanced Custom Fields, but with those two plugins and ...
Hey look I actually figured out my own problem:
In the formula fields you are concatenating, you wrap the formula with the round formula like this:
IF({Avg Rent Per 1br}="",0,ROUND(({Avg Rent Per 1br}/{Avg SF Per 1br}),2))
or Round([FORMULA],2) the t...