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?