Forum Discussion

MeganHardison's avatar
MeganHardison
Qrew Member
4 years ago

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 blank spaces, then puts the 125 field.

------------------------------
Megan Hardison
------------------------------
Wizards and add-ons

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    I'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
    ------------------------------
    • KeithJusas's avatar
      KeithJusas
      Qrew Captain
      4 years ago
      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
      ------------------------------
      • MeganHardison's avatar
        MeganHardison
        Qrew Member
        4 years ago
        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
        ------------------------------