Question

collection field blank until all four fields filled in

Forms Workflow Version 10

Updated April 5, 2017

asked on April 3, 2017

I am getting some error messages in my Business Process due to a collection field that manages the collection of four fields into one, in a format that must be configured right for the Laserfiche Templates. The Burn Site field will auto-populate with the entries put into the Quarter, Section TWP and Range fields.

This collection field works great, except when the location is not a Legal Address. In that case, the applicant fills out a different field and I get this error in the Workflow:

To resolve this, I'd like the form to not fill in the Burn Site until all four of the separate input fields are filled in. Is that possible?

QUESTION: How can I get this Burn Site field to remain completely blank until all four fields are "Not Empty"?

0 0

Answer

SELECTED ANSWER

replied on April 5, 2017

I understand, that's scare for sure. I recommend making a copy of your process to test with (you can always delete it once you're done with it).

You should be able to just wrap your existing formula into the "if false" part of the IF statement. Here's how to set-up your formula with it checking any of those five fields (Quarter, Section, Township, Range, and Meridian) At the beginning of your formula (between the = and CONCATENATE), you should be able to add this:

IF(OR(LEN(INDEX(Legal_Address.Quarter,ROW()))=0,LEN(INDEX(Legal_Address.Section,ROW()))=0,LEN(INDEX(Legal_Address.Township,ROW()))=0,LEN(INDEX(Legal_Address.Range,ROW()))=0,LEN(INDEX(Legal_Address.Meridian,ROW()))=0),"",

Then at the very end, just add one more closing parenthesis: )

The new complete formula would be:

=IF(OR(LEN(INDEX(Legal_Address.Quarter,ROW()))=0,LEN(INDEX(Legal_Address.Section,ROW()))=0,LEN(INDEX(Legal_Address.Township,ROW()))=0,LEN(INDEX(Legal_Address.Range,ROW()))=0,LEN(INDEX(Legal_Address.Meridian,ROW()))=0),"",CONCATENATE(INDEX(Legal_Address.Quarter,ROW()),"-",RIGHT(CONCATENATE("000",INDEX(Legal_Address.Section,ROW())),2),"-",RIGHT(CONCATENATE("000",INDEX(Legal_Address.Township,ROW())),3),"-",RIGHT(CONCATENATE("000",INDEX(Legal_Address.Range,ROW())),2),"-",INDEX(Legal_Address.Meridian,ROW())))

1 0

Replies

replied on April 4, 2017

Here's a formula that checks if four fields (named one, two, three, and four) are empty (length of zero) and only if none of them are empty, it completes a command to concatenate those four fields into one.

=IF(OR(LEN(one)=0,LEN(two)=0,LEN(three)=0,LEN(four)=0),"",CONCATENATE(one,two,three,four))

0 0

View 1 previous reply

replied on April 5, 2017

Matthew, thanks for your response.

I'm a chicken. That field already has this in it (instructing it how to collect those four fields and how to format each collection): =CONCATENATE(INDEX(Legal_Address.Quarter,ROW()),"-",RIGHT(CONCATENATE("000",INDEX(Legal_Address.Section,ROW())),2),"-",RIGHT(CONCATENATE("000",INDEX(Legal_Address.Township,ROW())),3),"-",RIGHT(CONCATENATE("000",INDEX(Legal_Address.Range,ROW())),2),"-",INDEX(Legal_Address.Meridian,ROW()))

Our permit process went live to the public just a few work days ago. I'm therefore afraid to play with this complex formatting. How would I adjust what I have to include leaving it blank if no entries were made in the four fields?

This might make it easier: Maybe we really only need to tell it to leave "Burn Site" blank if the first of the four fields are blank. In all cases where the applicants will not have a Legal Address to provide us with, they will not enter anything in even the first field (the "Quarter" field).

This might also make it easier: Is there a way I can tell Workflow to leave that template field blank if the result equals -00-000-00-W4 (which is what gets pulled in by WF if the applicant did not fill anything in those four fields.

0 0

SELECTED ANSWER

replied on April 5, 2017

I understand, that's scare for sure. I recommend making a copy of your process to test with (you can always delete it once you're done with it).

Then at the very end, just add one more closing parenthesis: )

The new complete formula would be:

1 0

replied on April 5, 2017

That worked beautifully, thanks! And thanks for the tip to Copy the process before testing. That also helps a lot!

1 0

replied on April 5, 2017

You're very welcome.

0 0

You are not allowed to follow up in this post.

Question

Question

collection field blank until all four fields filled in

Answer

Replies

Sign in to reply to this post.