If there are multiple batch numbers, how can I make that go to different rows instead of columns?

tchav

Hello,

I am trying to create a form that allows you to enter in when you receive different batches. Sometimes we receive multiple batch numbers at once. Is there a way to make it so that if multiple batch numbers are chosen that all the data will copy to another row instead of another column within the same row?

Right now I am having them fill out the form multiple times for every single batch number, it is a little mundane and taking up too much time.

Austin Smith

The simple answer to your question is no, one form = one row, and automations aren't robust enough to segregate data like that.

Would it be possible to just have multiple batch numbers per row (separate cells for each) and have whatever you're using to sort the data on the back-end use nested if, vlookup formulae to find things based on batch numbers.

Are the batch numbers part of a series, or random? How many characters?

If not, can you submit a screenshot that shows how much data you're working with?

Andrée Starå

Hi @tchav

I hope you're well and safe!

I've developed similar solutions for clients, and it's pretty advanced, but it's possible.

Can there be multiple submissions at the same time?

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

tchav

@Andrée Starå yes there can be multiple submissions at the same time. Normally there will be 5-10 people using the form at once.