Forms: How to create a 1..N part on a form

timhurkmans

Hello,

One of the things I cannot figure out is how to create, populate and save a control in Forms Builder that can occur one or multiple times on a form during runtime.

For example, I have a part on my form where a user will have to fill in one or multiple rows.

Name	Age	Address
Alice	23	Street 123
Bob	42	[needs filling in]
...
[Name N]	34	Street 78

Now, I want to be able to

- retrieve some fields (or all) from a docbase/repository,

- edit those that are still empty,

- add or remove rows.

My questions are:

- Can it be done with Forms Builder (electronic forms)?

- What kind of controls in Forms Builder will I use here?

- How can it be done?

- How can I populate my controls from an external source?

I cannot find it in the (FB 6.0) documentation. This is the biggest issue I still have open for Forms Builder.

Regards,

Tim

parasj

Hi,

I use Forms Builder 6.5 SP2 and Yes this is possible

=======================

1. Create a custom type with 3 repeating attributes 'Name', 'Age', 'Address'
2. Create a TABLE control on your form
3. It will have 2 columns by default
4. Add a Text Field as column 3 (drag-n-drop inside the repeating table)
5. Set the storage mappings for the data-items of the 3 columns to these repeating attributes
6. run the form and you will be able to use the INSERT/DELETE buttons to add/remove rows and add values where needed

Note - I have uploaded a screenshot of a Table with 3 rows, where each CELL is a drop-down list instead of a text field - the idea is that the user selects a value instead of typing in a value

Let us know if this helps