Daniela_Hecht - profile

Daniela_Hecht · Jan 27, 2021

I’m trying to create HTML code for each record based on a common HTML with placeholders between [ brackets ] that will then be replaced with record data from the corresponding fields, so I have in a long text field something like this: < h2 style=“te...

Daniela_Hecht · Oct 27, 2020

Hello everyone and thank you for being such a helpful community! I’m trying to get Facebook Ads data to Airtable using Parabola.io, all new records, no links. I have this body: { “records”: [ { “fields”: { “Campaign Name”:"{Campaign Name}", “Ad Name”...

Daniela_Hecht · Sep 02, 2020

Hello Community, I’m having an issue with a substitute function I hope you ban help with. I need to substitute certain numbers in a string that includes quote marks, and I get errors or invalid formulas in every try This is my original string, I have...

Daniela_Hecht · Feb 03, 2021

This script is very useful, Mike, thank you! I’m trying to set up an automation that will trigger a script like this one with fixed values for tables and fields, but I need it to run and create the junction table’s records without any user confirming...

Daniela_Hecht · Feb 02, 2021

Hello Alex I think it’s because of the VALUE function, because DATETIME_DIFF should return a number and not a text string, which is the correct input for the VALUE function. Try removing it: IF({Resolved} != BLANK() , DATETIME_DIFF(Resolved, Created,...

Daniela_Hecht · Jan 28, 2021

funny, it’s a lookup for a text field, I still don’t get it, but it worked anyway. Thanks a lot for your help

Daniela_Hecht · Jan 28, 2021

WOW, that did it!!! thanks so much! works with NCLIENTE field both as lookup and as rollup, so surprising, can you please explain why this works?

Daniela_Hecht · Jan 28, 2021

Thanks, I tried that, but I still get that error :pensive:

User Statistics

User Activity

Substitute returns #ERROR! in HTML

Parabola to Airtable returns error 422

Substitute in string with quote marks

Re: Help Creating a Script to Populate a Junction Table with Linked Records

Re: Formula Calculation Inside an IF Formula

Re: Substitute returns #ERROR! in HTML

Re: Substitute returns #ERROR! in HTML

Re: Substitute returns #ERROR! in HTML