I have created a table to import Google Analytics data. It contains 500 records with relative URLs and total page views.
I then want to use an automation to do the equivalent of a VLOOPUP on the URLs to find matches in a content table.
When there i...
I have a linked record table that stores dates for publications. The dates are unique and form the primary field.
When a value is inserted in a linked record field in the main table they are treated as text, which throws out the sorting.
It’s t...
Is it possible to use an automation to fill in a date field, if the user has missed it?
I would have a publication date for a piece of content, and would want to set the writer’s deadline 7 days’ prior.
I’m new to automations, so any pointers on how ...
I need to open a record in a miniExtensions form prefilling values from Airtable fields - including a multi-select field.
I’ve used an extension to build a formula. The resulting URL works fine with an Airtable form, which populates all fields, inclu...
This is a real noob question, so forgive me…
I want to call a script that will include user inputs. Whenever I try and do this from the automation interface, the code declaration errors.
I have found the script app in marketplace and can successfully...
Hi Scott. I went back and had another try using the approach you demonstrated. I did get it to work consistent, but with errors. After many hours I couldn’t get rid of these, although the data seemed accurate, the email alerts from the failed proce...
Thank you @ScottWorld
I watched the podcast and it is very interesting! However, if I understand correctly, it can only work with a single table.
I need to know the IDs of records to update in one table, plus the corresponding data value to insert f...
Many thanks for your replies. I feared extra fields might be the only answer.
I’m finding that I’m having to add so many fields for various workarounds it is making my main table very cluttered. Even with the ability to hide fields I think this is g...
I found that it is the URL encode function that inserts the space.
As a solution, I wrapped the URL encode function with Regex_replace to remove the space trailing the commas. The miniExtensions form now works fine.
REGEX_REPLACE(ENCODE_URL_COMPONENT...
