You are viewing limited content. For full access, please sign in.

Question

Question

Form fields collection

asked on November 4, 2016

Instead of this Address field collection, how can I create a field of my own collection?

 

I want a field for a Legal Address collection.  Instead of the following:

I want one field for the Legal Address, where a person would fill in the slots as shown on one line across the form, looking like this:  Qtr ____ - Section ____ - TWP ____ - Rge ____ - W4

And have the end result be one Field Value result of NW-35-040-11-W4

And, on top of that, I need it to be a field for multiple entries.

Thanks for any help you can throw my way!

1 0

Answer

SELECTED ANSWER
replied on November 17, 2016 Show version history

Hi Connie, yes, this can be done.

Open your Process and go to your form page, and in the top right hand corner their is a Duplicate button. What you are going to do is Duplicate your Form Page and Rename it something like "YourFormName - FC", and now you will see it appear in the Forms Section under the Hamburger Button on the left side of your screen along with your original form.

 

       

As this is a Duplicate of the original form that the user submits it contains all the same variables, so as they are filling out the main form, that information is being populated into the Fire Chiefs forms as well.

Now open the Fire Chiefs Form and make the changes you need to add/remove or Hide information on the form that the Fire Chief will see.

Once completed, go to your Process Diagram and at the User or Email Task for the Fire Chiefs Review, set the Form to the Fire Chiefs Form.

If you don't want the Fire Chief to be able to interact with any of the Data on the Form other than whatever your Submission Buttons (Approve\Reject\Etc), check the Read Only Box directly below.

1 0

Replies

replied on November 4, 2016

Hi Connie

It takes a little set up but here is how it could go.

In forms you need to Add a Collection to your Form, and then Add the Fields into the Collection. As well you will need to add another field that will use as a calculation field to Concatenate the Fields Together. It works like a Table but you will need to use CSS to change the size of the label and field widths so you can fit it on one line. You can also Hide the Variable field with CSS if you don't want to see it on the page. CSS is below

Using what I have below your Collection would look like this

To Add the Field together into the Variable Field, you can use the Advanced Calculations in the Variable Field. You formula would look like this.

=CONCATENATE(INDEX(Address.Qtr,ROW()),"-",INDEX(Address.Section,ROW()),"-",INDEX(Address.Township,ROW()),"-",INDEX(Address.Range,ROW()),"-W4")

Tablename.Field(ROW(() for each field so it will calculate across the lines of the collection. You can choose the Fields from the Drop Down

 

 

CSS to format the fields would look like below, it happens to be my fields were numbered from 31 to 35.

The Label lines below you adjust to set the amount of space the field label will take, the next part controls the size of the field itself. Easiest to make the numbers match for each line

The line line tells all the Fields to display on 1 line.

#q31 label{width:60px; text-align:right;}
#q32 label{width:60px; text-align:right;}
#q33 label{width:80px; text-align:right;}
#q34 label{width:60px; text-align:right;}
#q35 label{width:60px; text-align:right;}

#q31 .cf-field {width: 50px; min-width: 50px;}
#q31 .cf-medium {width: 50px;}
#q32 .cf-field {width: 50px; min-width: 50px;}
#q32 .cf-medium {width: 50px;}
#q33 .cf-field {width: 50px; min-width: 50px;}
#q33 .cf-medium {width: 50px;}
#q34 .cf-field {width: 50px; min-width: 50px;}
#q34 .cf-medium {width: 50px;}
#q35 .cf-field {width: 150px; min-width: 150px;}
#q35 .cf-medium {width: 150px;}

#q31,#q32,#q33,#q34,#q35 {display:inline-block;}

Good Luck

3 0
replied on November 7, 2016

Awesome!  Thanks for all the detail, as well.  I will be working on this today to see if I can duplicate it myself.  Thanks, Steve!

0 0
replied on November 7, 2016

Steve, I've run into a problem right off the bat.  In trying to build a Collection, the "Add field from Variable" is greyed out and won't allow me to add any fields to the collection field.  What am I missing?

0 0
replied on November 7, 2016 Show version history

Yes, this is true. Individual Fields cannot be added to a Collection. When creating fields in a Collection what you need to do is to Drag the Collection Tool onto the Page, and then drag the new fields you want to create as part of the Collection between the Collection lines. When you drag the Field between the lines they become part of the Collection Fields and your fields are created at that time.

1 0
replied on November 7, 2016

Okay, next issues:

Where to put the =Tablename.Field(ROW((); in each sub-field? or, in the variable combination field?  And:  I get this message:

0 0
replied on November 7, 2016 Show version history

What version of Forms do you have, unfortunately to use the Embedded Forms Calculations across a Table you need at least 10.1.

1 0
replied on November 7, 2016

Also, the variable (or collection) field, doesn't like my formula:

0 0
replied on November 7, 2016

Okay, Forms 10.1 came up last week at a LF User Group Workshop I was at.  My IT staff are supposed to be checking into that for me, so I guess I'll have to wait a day or two for them to finish upgrading Forms to 10.1.  I thought we already had it loaded, since we did the 10.1 upgrade about two months ago, but I guess they missed doing the Forms module.

0 0
replied on November 7, 2016 Show version history

There were two patches after 10.1 was released, Update 1 and Update 2. Suggest you go all the way since they are at it. Might be CONCATENATE it doesn't understand, does it show up under your function drop down list? Also, Had you noticed you put Legal_Address.Meridian in Quotes""

 

0 0
replied on November 7, 2016 Show version history

Yes, Steve, I changed the "-W4" to the actual field name variable because I was getting an error message that it didn't like my formula.  I was hoping that would clear out the problem, because I had narrowed out anything else I could find.  I realize now that I must not be working on the same Version you are.  Hopefully, my IT staff will be able to help me with this today, but it might have to wait for a day or two.  :( 

Thanks for your help!

0 0
replied on November 7, 2016

As a test for CONCATENATE, have you tried putting in a Formula such as =CONCATENATE("The Red Fox"," jumped over the dog") and see if it works?

0 0
replied on November 7, 2016

Ya, nope, that still comes up with the error msg.

0 0
replied on November 7, 2016 Show version history

In the meantime, where do I put the Tablename formula you gave me?

0 0
replied on November 7, 2016 Show version history

That was just an example of how the Collection Variable looks.

Try this instead of the CONCATENATE Formula and see if it works for you.

=INDEX(Legal_Address.Quarter,ROW())&"-"&INDEX(Legal_Address.Section,ROW())&"-"&INDEX(Legal_Address.Township,ROW())&"-"&INDEX(Legal_Address.Range,ROW())&"-W4"

0 0
replied on November 7, 2016

Still have errors:

0 0
replied on November 7, 2016 Show version history

Check in once your IT folks have completed the upgrade, it's pretty easy for the upgrade and patches installation. Otherwise your only option would be JavaScript, but if your guys can apply the patches in a day or 2, I'd wait and go that way.

1 0
replied on November 16, 2016

Okay, Steve, I now have the upgrade installed and this formula is working!!

Now, how to I get only the collection field (that last variable that collects the pieces) to show up on the approval form?  When this application form gets emailed to our Fire Chief for approval, I want it as short as possible.  I want it to only show the collections that result from any legal addresses entered.  Can I do that?

0 0
SELECTED ANSWER
replied on November 17, 2016 Show version history

Hi Connie, yes, this can be done.

Open your Process and go to your form page, and in the top right hand corner their is a Duplicate button. What you are going to do is Duplicate your Form Page and Rename it something like "YourFormName - FC", and now you will see it appear in the Forms Section under the Hamburger Button on the left side of your screen along with your original form.

 

       

As this is a Duplicate of the original form that the user submits it contains all the same variables, so as they are filling out the main form, that information is being populated into the Fire Chiefs forms as well.

Now open the Fire Chiefs Form and make the changes you need to add/remove or Hide information on the form that the Fire Chief will see.

Once completed, go to your Process Diagram and at the User or Email Task for the Fire Chiefs Review, set the Form to the Fire Chiefs Form.

If you don't want the Fire Chief to be able to interact with any of the Data on the Form other than whatever your Submission Buttons (Approve\Reject\Etc), check the Read Only Box directly below.

1 0
replied on November 18, 2016

Perfect, Steve!  This is what showed up on the submission to the fire chief:

1 0
replied on November 4, 2016

You cannot currently create your own collections, but I really like that idea!

You are not allowed to follow up in this post.

Sign in to reply to this post.