File Column split to multiple separate fields

Baserow Help
,
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What do you need help with?

I have a column of “file” type called images. It contains 3 files or less.

I want to create 3 separate columns, A, B and C to contain one image each.

I can use the following formula:
index(field(‘images’), 0)

That formula grabs the first, second, and third images (by changing the index). I have created test columns successfully and they show the correct image. But they are of type formula.

I would like them as type file so that I can remove the original column and use the new columns as data entry.

If I set the data type of the formula column (A, B or C) to file, it empties out the column.

2

Hey @Troy, it’s currently not possible to split a multi-file field into separate editable file fields directly in Baserow.

You can either:

  • Add images manually into new file fields (A, B, C)
  • Use workaround: Use Baserow’s API or tools like Make/Zapier to extract and re-upload images into separate editable fields.

Hope it helps!

3

Thanks for confirming.

I’ll look at using the API and probably a python script.

I am curious, do I have to download and upload or can I simply get the internal name and assign that to the field?

4

I think you will need to download and upload again using API :thinking:

5

I wonder too.

If you take a look at the names of the files that are downloaded via the api they appear to be a hash along with the original name.

If they are hashed, it should mean we shouldn’t have to re-upload.

Thank you for the confirmation that I’ll have to use the API. Whether I have to download, then upload or I can do something else.