Forms - ability to add multiple fields

CassAnne

Hi,

I've looked everywhere but cannot see if this is possible - or a work-around.

I want to use the forms to collect information from site. One of the most import pieces of information is deliveries. So I have it set up so that "Materials" is a field/column, and then multiselect, and a second column for the quantity. This works if there is only one delivery - they can select the material type and then enter the quantity. The problem is I need them to be able to choose a lot of different material options and allocate a quantity to each of them.

I ideally, if the form user could just add additional material and quant fields within the form that would be great.

Any other ideas? Adding multiple fields for materials and quantities isn't really an option as we are looking at upwards of 50 different types of materials.

Mark Cronk

Hi @CassAnne ,

Rather than a single material and quality column can you create multiple, e.g. material1, material2, material3, material4 so that each item in the order is a different column? You'd need as many columns as your largest delivery, or you'd need to record (submit) multiple deliveries if the items delivered is greater than X. You'll have to determine if that's manageable.

You would use form logic to display the next material and quantity column if they have another to enter. You could start by displaying the number common to most deliveries (1,2,3?). Then use logic to add beyond that.

This structure makes your reporting slightly more complicated. You'll need to count and sum multiple columns, but it's doable.

Does that give you any viable ideas?

Mark