0

Seperators between table rows

Josh Cohen-Collier

November 24, 2017 14:42

None

Follow

Hi Klipfolio!

This will give an example of how you can add a custom separator row between each regular row in a table column.


1)
First, add all of the actual data columns as hidden data, and make the hidden data independant;

-First, to add the hidden data, you can do this from the Properties panel of the table)

-To make it hidden, you can go to the Properties panel of each hidden data:

-You will need one hidden data for each column that you want in your table.
The actual column content would go in the hidden data




2)
Use the following formulas for the table columns themselves;

You will need to do one MAPFLAT formula for each table column, each pointing to a different hidden data.

3)
You can then set the indicators panel of each column to change the color and background color.





Hope this helps!

Warm regards,
Joshua
_____________________________
Joshua Cohen-Collier
Technical Support Engineer, Klipfolio

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  Starr Livingstone July 31, 2018 00:19

  Hi Joshua,

  Could you please break the instruction set down into smaller steps if that is possible.  I am missing something about how to make data independent and hidden.  Also missing something about where to to put that MAPFLAT formula.  Some of my Klips already have more than one datasource, so I have existing formulas for several columns. 

  Your end result table seems to be precisely what I am looking for.

  Thanks very much.

  Regards,

   

• 0
  
  Josh Cohen-Collier July 31, 2018 15:52

  Hi Starr,
  
  I made some adjustments to the above instructions, in order to make them easier to digest.
  Let me know if you have any questions!
  
  Best,
  Joshua

• 0
  
  Starr Livingstone August 01, 2018 05:51

  Hi Johua,

  Much easier to digest and apply, thank you!  I have done my own initial test successfully and can now apply this to all the Klips where we need this separator.

  One small addition to your instruction set would add clarity for others wanting to implement this. That is to add a screenshot in the left hand Klip document tree showing BOTH the Hdden data column object and the normal Column object.  I did not initially grasp that nuance, likely because I have never used the hidden data function previously.  The intellisense prompts in the MAPFLAT function eventually got me to put things in the right place.

  Thanks again.  REALLY appreciated.

  regards,

  Starr

   

• 0
  
  Starr Livingstone August 07, 2018 05:28

  Hi Joshua,

  I have another issue when trying to implement the separator line in Klips with multiple source tables. In particular I am testing it out in "Starr Copy of Safety Reports", which has 2 source tables.  I use the LOOKUP function to marry the data of the two tables together properly in the Klip.

  First 5 columns MAPFLAT works fine. 

  Next 5 columns all have LOOKUP in the Data panel for each column.  I have tried unsuccessfully to embed  LOOKUP within MAPFLAT as a the first parameter.  Seems that it does not like a function within a function.

  Can you please have a look and identify what it is that I am missing, or perhaps work some magic?

  Thanks,

  Starr

   

   

• 0
  
  Starr Livingstone August 07, 2018 05:57

  Hi Again,

  I think I have figured it out.  Trying Lookup Function in hidden data column, then Mapflat in visible column.  I have a couple of issues with duplicate date data field names/labels,  so am fixing that in my Device Magic form design first.

  Thanks.

• 0
  
  Starr Livingstone August 07, 2018 08:21

  Well that did not work.  Cannot seem to reference a Lookup function keyed into a Hidden Data column. I have the row separator in all columns but it only works because the source data in the two tables is in the same order.  There is no binding of row data by the identifier columns.

  Ideas?