Make columns visable in a grid using a macro command

No planeada

Ryan Spencer

• 31 de marzo de 2022 08:11

When using a Macro to SET or TRANSFER into a field that is not visible an error occurs stating:

[Check that it is visable and active] (Item - Form Item is not editable)

Rather than relying on the user to configure the columns to avoid this error, can we have a command to SHOW/HIDE columns like you can with other regular fields? This will ensure the field is visible before trying to update it.

Vote

3

• 

  Rasmus Jensen

  • 31 de marzo de 2022 08:27

  Hi Ryan

  From a technical perspective the Show/Hide commands can already do this:

  
  

  However, if this is enough is on a case by case basis, and does not help with if field is editable or not.
• 

  Ryan Spencer

  • 31 de marzo de 2022 08:38

  To be honest, Rasmus, that's what I initially understood; I'm confident I had it working in the past but thought I might be experiencing a bit of the Mandela Effect.

  I couldn't get it working, so I logged a support ticket, and they confirmed it was technically impossible #168647.

  Hense this feature request, but I will try again.
• 

  Ryan Spencer

  • 31 de marzo de 2022 09:00

  Hi Rasmus,

  Ok, it works if you Hide the column using a macro, you can then use the Show command to make it visible again. 

  But if the column is already not visible (or you manually turn it off in form settings), then the macro command Show doesn't work.

  Is this expected behaviour?

  Thanks
• 

  Rasmus Jensen

  • 31 de marzo de 2022 09:02

  Hmm, checking a bit more the support is actually correct (at least for your scenario)

  Show and Hide Commands can actually show and hide columns as such, but ONLY when the column is already on-screen

  

  So they could be used for a feature that displayed views depending on user or customer, but not for the scenario you describe.

  I also did some quick tests with the SDK just now and setting a non-visible column to visible via code is just ignored by the SDK on purpose... I then checked if we could force it to show by setting a width, and that actually work visually, but the column is disabled... and Enable of a column throw and code exception (this is on purpose by the SDK and make logical sense).

  

  So I'm afraid we need to mark this as not planned, as the SDK would simply not allow us to do it, no matter how hard we try
• 

  Ryan Spencer

  • 31 de marzo de 2022 09:06

  Thanks for the detailed explanation Rasmus. I'll leave you in peace for now.

Iniciar sesión para dejar un comentario.