Okay
  Public Ticket #2778549
Hide field on export
Closed

Comments

  •  1
    Igor Vinícius Neumann de Paiva started the conversation

    Is there a way to hide a field in the table tools export?

    Current scenario: We use contitional formatting in the stock column to display if the item is in stock or not without saying HOW MANY we have in stock

    Problem faced: Stock quantity appears when exported

    Ideal solution: Export it without this column.

    Workaround: Disable table tools (sad).

    Many Tahnks,
    Igor

  •  1
    Igor Vinícius Neumann de Paiva replied

    Found a workaround:

    1 - Set this column as hidden
    2 - Create a new coumn with a formula dividing this column value by itself... 
    3 - Display this coilumn, will be 1 or 0.

    Works like a charm... you can close this ticket if you dont have a better solution to send.

  • [deleted] replied

    Hi Igor

    Thank you for reaching out to us.

    Since the functionalities of table export tools are based on a 3rd party HTML5 library wich have some limitations to the styling of the export file, you have found a perfect workaround, we couldn't have suggested a better solution.

    If there is anything else we can assist you with please don't hesitate to open a new ticket.

    Have a wonderful day!