TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Adding new columns to a Form to be optional
At the moment, when a new Column is created in a Table, the field is added automatically to the Table's default Form: sometimes at the bottom, sometimes at the top!
Very often we create Formula fields for calculations that should not be displayed on the Form - so we need to remove them from the Form manually, which can be (often is!) annoying if you forget to do it.

It would be better to have the OPTION to add the new column to the Form or NOT, as a setting for the Column - just like we have the option to add it to the Default View.
ID
2005
Category
Setup
Author

Luison Lassala
Date Created
8/29/2023 3:25:00 AM
Date Updated
5/31/2024 7:03:07 AM
Status
Implemented
Score
120
Promoted By
DamianLiamMacky Muller
Lawrence BricknellNick AshcroftJonathan Snyman
Jonathan GeeJorge Sola Ullodcooper collier
Patricio BustosPierreLuison Lassala
Comments
cooper collier  8/29/2023 8:46:48 AM
Our go-to technique, which proves effective 99% of the time, involves creating a section labeled "Dev" and placing it directly above the default system section. It is crucial for this section to be positioned above the system section and below all other sections.

In most cases, new columns are added to this section. It is advisable to test it for each form. If it functions correctly with one column, it typically works for all subsequent new columns. However, if it doesn't work on a particular form, attempting to create another section often resolves the issue.

Next, set the section to be invisible for all roles except those assigned with the dev role (or any other role designated for programming purposes).

Although we still perform checks to prevent any unforeseen mishaps where a new column may erroneously appear on the form, having this failsafe in place proves invaluable.

We have a policy to immediately do this when creating a new table, all our clients have this in all tables!
Luison Lassala 8/29/2023 9:09:08 AM
Thanks for the suggestion Cooper, but it is only a workaround solution. We shouldn't have to create Sections for every Table and apply Form Behaviour rules just to prevent unwanted columns from showing up on Forms.
cooper collier  8/29/2023 9:18:49 AM
Certainly! I completely agree with you, and I wholeheartedly support your point. However, I would like to add an additional suggestion to this matter.

In the form editor, the columns that are not displayed on the form appear at the top, but unfortunately, they tend to truncate the full column name. It is crucial for these column names to be displayed in their entirety, at least when hovering the mouse over them.

By ensuring that the full column names are visible, it would greatly improve the usability and clarity of the form editor interface.
Jonathan Snyman 5/23/2024 9:20:38 AM
Would it be possible to have a "Include in form layout by default" checkbox when creating new columns similar to "Include in views by default.

This would reduce the effort to getting rid of unwanted columns in form layouts. {258}
Pierre 5/23/2024 9:24:13 AM
Include as first
Include as last
Do not include

Pierre 5/24/2024 1:34:53 AM
Add right after last field added
Slava Shinderov  Staff  5/27/2024 10:10:39 AM
Merged with:
2045 - Include in form layout by default checkbox (Column Display Properties)
Slava Shinderov  Staff  5/31/2024 5:47:59 AM
@All we've added a new option to the column add screen to exclude columns from the default views and forms by default. Additionally, you can hide columns from the form using the particular column's edit screen as well.
Jonathan Snyman 5/31/2024 6:05:43 AM
Thank you Slava.
Luison Lassala 5/31/2024 7:03:07 AM
Wonderful Slava! A very welcome new feature.
Feedback
 
Back to Search Results