Shift up fields on Exact Forms Plus
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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI'm not sure if anyone from Juiced will notice this post, but I have had the same issue. You might try concatenating the fields together, separated by a new line character into a new field.
List("\n", [field 1], [field 2],[field 3])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
List("\n", [field 1], [field 2],[field 3])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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("\n", [field1], [field2],[field3]))
use the new field in the template instead of the 3 fields
~126~
------------------------------
Keith Jusas
CEO
Juiced Technologies, Inc.
Ronkonkoma NY
6316175060
------------------------------
create a new formula text field (assume new field id is 126)
in formula use:
If (trim([field1])="" and trim([field2])="", [field3],List("\n", [field1], [field2],[field3]))
use the new field in the template instead of the 3 fields
~126~
------------------------------
Keith Jusas
CEO
Juiced Technologies, Inc.
Ronkonkoma NY
6316175060
------------------------------
- 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__YouDo you mean that it's showing like ~123~ on the form now? What does the form look like that i a problemn? maybe upload a an example?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
