Shift up fields on Exact Forms Plus

Question

I have a bunch of fields in a row down the word doc like this:
~123~
~124~
~125~
and so on... my question is, when 123 and 124 are blank, how do i get 125 to shift up. Right now, it just leaves 2 blank spaces, then puts the 125 field.

------------------------------
Megan Hardison
------------------------------

keithjusas · Answer

Another option:create a new formula text field (assume new field id is 126)in formula use:If (trim([field1])="" and trim([field2])="", [field3],List("
", [field1], [field2],[field3]))use the new field in the template instead of the 3 fields~126~------------------------------Keith JusasCEOJuiced Technologies, Inc.Ronkonkoma NY6316175060------------------------------

markshnier__you · Answer

I'm not sure if anyone from Juiced will notice this post, but I have had the same issue.&nbsp; You might try concatenating the fields together, separated by a new line character into a new field.List("
", [field 1], [field 2],[field 3])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

meganhardison · Answer

Well shoot. I think its how my EF+ was set up. Its showing a lot of code now. Could it have do to with the field [EF+ Form Content]? Sorry, I'm not smart enough with code to figure this out myself.

------------------------------
Megan Hardison
------------------------------

markshnier__you · Answer

Do you mean that it's showing like ~123~ on the form now?&nbsp; What does the form look like that i a problemn?&nbsp; maybe upload a an example?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Shift up fields on Exact Forms Plus

Related Content

Report Heading Shifting

Snapshot Fields

Find and Replace Field Values

Proxy fields

Consolidate Field Types