Discussions

 View Only
  • 1.  Shift up fields on Exact Forms Plus

    Posted 11-13-2020 14:18
    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
    ------------------------------


  • 2.  RE: Shift up fields on Exact Forms Plus

    Posted 11-13-2020 15:37
    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
    ------------------------------



  • 3.  RE: Shift up fields on Exact Forms Plus

    Posted 11-14-2020 15:41
    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
    ------------------------------



  • 4.  RE: Shift up fields on Exact Forms Plus

    Posted 11-16-2020 14:33
    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
    ------------------------------



  • 5.  RE: Shift up fields on Exact Forms Plus

    Posted 11-16-2020 14:37
    Do 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
    ------------------------------