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

Damian	Liam	Macky Muller
Lawrence Bricknell	Nick Ashcroft	Jonathan Snyman
Jonathan Gee	Jorge Sola Ullod	cooper collier
Patricio Bustos	Pierre	Luison 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