How can i set up a form that the user can add rows as required

Options

How can i set up a form that the user can add rows as required for example if i was capturing the data on a companies assets.

The customer might have 5 assets or 100 assets

We need the customer to be able to add the details of as many assets they have

EG

Asset 1 - Name - Details

Asset 2 - Name - Details

Tags:

Answers

  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭
    Options

    You can use form logic to either:

    1) Have a user select the number of Assets needed and based on that selection make the appropriate number of asset rows appear,

    2) Start with 1 asset and have another row appear if you populate it with a value, and continue this until the max is hit (not 100% you can do this, I've never tried this exact use case).

    With 100 assets you will have a LOT of logic, I'm not actually sure if there is a limit on number of rules (e.g., option 1).

    👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner

    If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!

    PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!