Dear All,

I am quite new user of Airtable and I am trying to create a database for my geology laboratory. In short, we make microscope slides named Thin Sections (hereafter I will call them “TS”) from geology samples (hereafter “samples”). From one sample, one can obtain more than 1 TS at the end of the manufacturing process. However, the user knows since the beginning if he/she wants one, two, or three (and so on) TS from his/her own samples.

I have thus created a table with the following fields (see attached image):

• “Sample name”,


• “Site name” (the name of the site where the sample has been collected),


• “total TS” (that refers to the number of TS on aims to obtain),


• “TS names” (since each TS has its specific name at the end of the making process).

In the case more than one TS will be produced, I would fill automatically the “TS name” field as it follows:

e.g. → (Sample name)_1, (Sample name)2, (Sample name) 3…and so on, in relation to the number of TS he/she wants that he/she wrote in the field “Total TS”.

In short, for example, if the"total TS" field has the value “3”, I would have 3 different names divided by a comma.

My problem is that I am not able to generate multiple names, but just one (using an IF statement) and I am not able to use the “Total TS” field as a limit for the names that want to be generated.

I hope I have explained clearly my situation.

Thanks in advance to all the users will help me. I wish you a nice weekend.

Federico