Create an entirely invisible subfile column with hidden fields

[chs]

Hi everyone,

We would like to create a subfile column (resp. a grid column) for hidden fields which is entirely invisible for the user.

We tried the following:
1. We set the column fields visibility to hidden: The field values were invisible but unfortunately an empty column was displayed. We also set the column header to blank but the column was still visible.
2. We set the column width to zero. Unfortunately, this works only if "expand to layout" is set to false. If "expand to layout" is set to true (this is the setting we want to use), the column with width = zero is displayed.

We would like to hide the entire subfile column while using "expand to layout" = true.

Questions:
1. How can we create such a column?
2. Is it correct, that a column with width = zero is expanded when "expand to layout" = true is used? In our opinion, this column should still be invisible.
3. Can this problem be solved by using JavaScript code?
4. Can this problem be solved by using the RemoveColumn() api?
5. If this feature doesn't exist, is it possible to create such a feature in the next version?

This function is very important for us and we would like to avoid storing the hidden fields in program arrays.

Any help is very much appreciated. Thank you.

Christoph

[Scott Klement]

Why not put the hidden fields inside one of the existing columns instead of putting them in their own column?

You can have as many fields as you wish in a subfile column, so why add another one for fields that are hidden? Since they're hidden, there's not much point to giving them their own column...

[dscorca]

I’ve wondered the same thing and it was all due to my mild case of OCD to keep all the hidden fields in a separate place and not overlapping or cluttering anything else up. I came up with a simple solution which works for me and doesn’t require any hidden columns… I simply make the row height very large and stick all my hidden fields neatly arranged below my visible elements, then I shrink the row’s height back to normal.

Voilà… all my hidden fields are tucked away in their own little cozy place and my visible elements aren’t cluttered up.

[Scott Klement]

Another solution is to set the top/left properties of the hidden fields to negative numbers. then they won't be visible in the designer at all.

[chs]

Hello everybody,

Thank you for your quick response.

With each suggested solution, we can store hidden resp. invisible field values in our subfile now.

Now we want to locate the value of the hidden subfile field DOFUserGroup.
Subfile column 1 has 2 fields: One is the hidden field DOFUserGroup with a negative position number and the other one is a visible field.

We use the following Java Script code to locate the value of the hidden field:
getObj("GRDGroup").grid.getDataValue(1, "DOFUserGroup")

Unfortunately, this isn't working because our hidden field name DOFUserGroup is an alias field name with more than 10 characters.
If we use a non-alias field name with a maximum of 10 characters, it works fine.

We would like to keep the advantage of alias resp. long field names.

Questions:
1. How can we locate the value of the hidden alias field name DOFUserGroup?
2. Is our Java Script code correct or should we use another code ?
3. Is there a Java Script code which supports alias field names ?

Thank you for your answer in advance.

Christoph

[Scott Klement]

Unfortunately, right now the getDataValue() API must be used with the short name. So if you have a field named DOFUserGroup, then there should also be a 10 character version of that field with a name like DOFUSE0001. For now, you will need to use that shorter name, DOFUSE0001 with getDataValue().

You have the syntax correct, just change the code to:

Code: Select all

getObj("GRDGroup").grid.getDataValue(1, "DOFUSE0001")

We can look into fixing this for a future release of Profound UI.

[chs]

Thank you for your response.

We would appreciate having a fix to be able to use alias field names.

We are now starting to renew our software with Profound.

Christoph