Hello @Tony11,
Unfortunately, URL for the attachment field that can currently be referenced in the formula is an invalid URL.
However, various URLs and other values can be retrieved from automation.
"Expiring Download URL" can be used to upload to other Attachment fields.
Hello @Tony11,
Unfortunately, URL for the attachment field that can currently be referenced in the formula is an invalid URL.
However, various URLs and other values can be retrieved from automation.
"Expiring Download URL" can be used to upload to other Attachment fields.
Thank you for the reply @Sho.
So if we want to extract the first attachment. I guess the only solution would be to run a sript or an automatisation with Make ?
This can be done in one automation.
First add a single line text field that records the list of download URLs from the automation.
Then add the following formula field that extracts the first URL from the list of download URLs
REGEX_EXTRACT({Download URLs},"(^[^, ]*)((, )|$)?")In the Automation settings
1. Trigger when the attachment is updated
2. Update the download URL list
3. Delay script 1 second (as it sometimes fails without delay)
function delay(ms) {
var limit = new Date();
limit = limit.setMilliseconds(limit.getMilliseconds() + ms);
while ((new Date()) < limit) {
// do nothing
;
}
delay(1000); //delay 1 second*This script is shared by this community
4. Upload with extracted URLs
This is updated even if the first attachment is changed by manual sorting.
Thank you for your advices @Sho !
I followed the steps but it was too buggy, even when I was using the delay script set to 3 secondes the automation was very unstable and the 1st photo wasn't uploaded in many cases.
I found another easy way to handle it through an easy Make automation.
1 - Search for record (not having the 1st picture uploaded in your target column). You can create a view on Airtable to filter only the record you want to update.
2 - Update the record by mapping the attachement fields (array)'s first element into your target column.
Was it no work?
I had no problem testing with light images. It seems to fail if the upload takes too long.
If it fails in one automation, it might be better to split it into two.
Anyway, MAKE would be a sure thing.
This can be done in one automation.
First add a single line text field that records the list of download URLs from the automation.
Then add the following formula field that extracts the first URL from the list of download URLs
REGEX_EXTRACT({Download URLs},"(^[^, ]*)((, )|$)?")In the Automation settings
1. Trigger when the attachment is updated
2. Update the download URL list
3. Delay script 1 second (as it sometimes fails without delay)
function delay(ms) {
var limit = new Date();
limit = limit.setMilliseconds(limit.getMilliseconds() + ms);
while ((new Date()) < limit) {
// do nothing
;
}
delay(1000); //delay 1 second*This script is shared by this community
4. Upload with extracted URLs
This is updated even if the first attachment is changed by manual sorting.
hello @Sho how to extract first image from multiple image attachments in airtable in same table I want only 1st pic shown in the column from multiple image attachements
Hello @Fazia_Fayyaz,
One automation was unstable, so two should be fine.
In addition to the Attachment field, add the following four additional fields
"Attachment IDs" single-line string field
"Attachment URLs" single-line string field
"First Attachment ID" formula field with the formula
REGEX_EXTRACT({Attachment IDs},"(^[^, ]*)((, )|$)?")"First Attachment URL" formula field, with the formula
REGEX_EXTRACT({Attachment URLs},"(^[^, ]*)((, )|$)?")
The two automations are set up as follows
Automation1 Setting
It will be trigger each time the Attachment field is updated.
How to get Attachment's ID and URL is to change Display properties.
Automation2 Setting
Automation2 is triggered only when the First Attachment ID is changed.
Give it a try.
