Newbie Questions

Re: Programatically Create Tables Dependent on Another Fields Value

cartotech81 — Mon, 27 Aug 2018 17:02:56 GMT

I am not able to do VBA without installing VBA for InfoPath or some addin to allow me to do it, and its not authorized on our system.

The problem is our amount of travelers can change so I don't really have a good max number.

Can you code without the VBA addin?

Re: Programatically Create Tables Dependent on Another Fields Value

Hilary Stoupa — Mon, 27 Aug 2018 16:24:22 GMT

So - you are able to add code to your form? If so, you could just use code to add the instances of your repeating node that you need, based on the number entered. If not, you could use default data for this - add the max number of rows you'll let the user add to the defaults, then display them based on the entered number. Let me know if you'd like a sample of that approach.

Programatically Create Tables Dependent on Another Fields Value

cartotech81 — Thu, 23 Aug 2018 16:23:31 GMT

Using InfoPath Designer 2013

There are probably multiple ways to do this, but I would like to know your opinions and help on the best way.

I have a repeating table called travelersRepeatingTable.

I have a text box that counts the number of rows in travelersRepeatingTable called travelerCount

I want to be able to create new tables dependent on the traveler count.

For instance:

I would open the form and add in 2 travelers information.

That in return would create 2 different tables. If i had 2 travelers it would load 3 tables.

Each of these tables would have the following:

Row 1 - Traveler Name pulled from Row 1 of the travelersRepeatingTable

Row 2 - 4 column header row with expense types labeled

Row 3 - 4 column row with currency text fields with actual expenses.

Would need a blank row between the tables for separation purposes.