/scripts/ahub.form.attachments.js
0

Using A Parameter Field To Suppress A Group Header

Mar 17, 2017 at 10:04 PM

95

avatar image

Hi Experts,

Is it possible to use the value of a Parameter Field i.e. "Show Group Header" to suppress or un-suppress a Group Header section, depending on the boolean value of said Parameter Field?

For Example:

Show Header: True > Doesn't suppress the header

Show Header: False > Does suppress the header

(Everytime you refreshed the data, it would give you the option to change the boolean value, like any other Parameter Field).

How would you do this?

Thanks,

Gareth

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Mar 20, 2017 at 09:40 AM
1

Hi Gareth,

1. Setup a parameter with the type 'Booleanvar'.

2. Go to the Section Expert > Highlight Group Header > Click the formula button beside Suppress and use this code:

Not({?PromptName})

-Abhilash

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Abhilash,

I'll need to test this in a couple of different environments than mine own, but this should work nicely.

Thank you for your reply.

Kindest Regards,

Gareth

0

Hi Abhilash,

I am trying to suppress the "CHECKBOXGROUP_4_Supress_Frame_Materials" Group Header.

I've inserted the statement "Not({?CHECKBOXGROUP_4_Supress_Frame_Materials})" below.

However, I am getting the error [A statement was expected here] on the Not({?CHECKBOXGROUP_4_Supress_Frame_Materials}) line of code.

Any ideas?

If {?CHECKBOXGROUP_1_SUMMARY} = True Then
    formula = True
    Else
        If {QuoteAssemblies.qmaQuoteAssemblyID} = 0 Then
            formula = True
            Else
                If {?CHECKBOXGROUP_3_Suppress_Fabric_Materials} = True and {QuoteAssemblies.qmaPartID} = "FABRIC" Then
                    formula = True
                    Else
                         If {?CHECKBOXGROUP_4_Suppress_Frame_Materials} = True and ({QuoteAssemblies.qmaPartID} = "FRAME" or {QuoteAssemblies.UQMACOMPONENTCLASSID} = "FRAME" or {QuoteAssemblies.UQMACOMPONENTCLASSID} = "TIMBER") Then
                            formula = True
                            Error here >>>> Not({?CHECKBOXGROUP_4_Suppress_Frame_Materials})
                            Else
                                If {?CHECKBOXGROUP_5_Suppress_Leather_Materials} = True and {QuoteAssemblies.qmaPartID} = "LEATHER" Then
                                    formula = True
                            Else
                            formula = False
                            End If
                    End If
            End If
End If
End If
<br>

Regards,

Gareth

0

Bump......

0
Skip to Content