For each photo added to a form one entry in airtable

​@KIW 

Yes, this is very easy to do with Airtable’s automations.

After the form is submitted, you would just loop through your attachment field with a repeating group action to create your new records.

Please see the screenshot below for a quick overview of how to set this up in Airtable’s automations.

By the way, if you need more advanced control over the uploaded photos, such as limiting the user to a certain file size, you would need to use .Fillout’s advanced forms for Airtable for that.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Thanks very much for the fast answer.

I have a question. When i set field attachment i have two options (they are in german).
Which one should i select?

There may even be more than 2 URLs for the attachment field. I think they should all work, but play around with it until you find one that works best.

I tested with Base-Datensatz-URL and i got this error: “Attachment could not be parsed”.

 

Sorry and another question. In “fields” we must only select the attachment field or others also?

When creating records, you can update as many fields as you would like for your new record.

Check out my screenshot below — be sure you’re choosing the attachment field’s URL from the “current item” option on the left.

Something is not working. I set this:

 

And not three entries was made. It was one entry with three attachments made.

 

The form looks like this:
 

What I am doing wrong?
Thanks very much

Take a look at my screenshot above…. Notice how I chose “current item” within the “create record” action.

Current item (Aktuelles Elemnt) is selected:

 

Very strange… as far as I can tell from your screenshots, your setup should work! It looks identical to my setup. You may want to email support@airtable.com to ask them about your setup to see what’s going on.

- ScottWorld, Expert Airtable Consultant

By the way, while you’re waiting for Airtable Support to help you figure out what is going wrong with your automation, there’s another way that you can do this too.

You can recreate your form in Fillout (which is free), and then use Make (which is free) to create your records in Airtable.

Your Make automation would look like the screenshot below:

Hope this helps!

- ScottWorld, Expert Airtable Consultant

Thanks very much. I will try both. 

Hi, can it be that it doesnt work because i made order number to primary key?

Does this look right?

If so, I’ve set it up here so you can compare how it’s set up against your own automation

Hi,
After you submitted form and automation triggered, check Automation History, expand steps and see what’s happening. Note that if your form based on the same table, where you create new records, the record with three fotos will be created as a result of the form submission,
then 3 records will be (supposed to be) created by Automation.
 

Possible reson why it is not working - files needs a little delay, a few seconds or even less than a second, to be displayed and ‘registered’ in table. At the moment Automation starting, they are not registered yet, so ‘Fotos’ considered as empty, so it’s an empty loop. Checking history will clarify this.
Workaround - add formula field counting the number of attachments.
EXAMPLE OF COUNT FORMULA:

(LEN(Files)-LEN(SUBSTITUTE(Files,'https://','')))/LEN('https://')

It counts only ‘registered’ files, so you should think about - how to run this automation AFTER the value in count field == the number of files and not before. The speed of ‘registering’ could be different depending on location and the device type, so it can work for one user but not work for second (and partially work for third)

After you solve it, you might want to remove a 3-files record afterwards (and it’s a bit tricky as you cannot install single step after Repeating group on Automation). But that’s another story and it depends on your solution of previous.