Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
#dc for control of columns in tables in documents
You have documented the use of #dt, #dr, #dp, all of which I am using and finding very useful. Is there any chance you could add a #dc which would manage the possible inclusion or exclusion of a column from a table in documents. I am finding myself making various versions of the document or the table within a document to handle different scenarios which could be much ore elegantly managed with a #dc.

For example I use #dt in our invoice. My users can set a parameter within the system which in turn governs whether each of the three tables is displayed or not. For example in the first table there is a parameter "Format_is_line_by_line#dt". If this is null then the table is not displayed. If it contains a space then the table is displayed.

Within the first of the three tables I want to be able to set a parameter which decides whether the 3 columns Qty, Units and Unit price are included or not. Not all of my users want these three columns. Lets call the parameter "display_qty_cols". I would then make the title of each of the columns Qty"display_qty_cols#dc"; Units"display_qty_cols#dc", Unit price"display_qty_cols#dc". If "display_qty_cols" is null the column is not displayed, if it is space the column is displayed.
ID
1375
Category
Setup
Author

Philipp Matuschka (MMB)
Date Created
8/26/2020 6:37:47 AM
Date Updated
8/26/2020 7:58:52 AM
Status
New Idea
Score
30
Promoted By
PierrePatricio BustosPhilipp Matuschka (MMB)
Comments
Pierre 8/26/2020 7:58:52 AM
This would be very useful
Along the same lines, it would be useful to be released from the obligation to declare the fields (columns) used in document subtables, as columns of the form subtable.
The subtables of the form and the subtable of the documents have very different usages, different formatting constraints, sometimes different access rights.
Declaring all the fields used in document subtables as fields of the form subtable crowds this sub-table. (you can then hide them user by user - but this is slow)
Kind regards,
Pierre
Feedback
 
Back to Search Results