Hi, I am unable to save my data in the editable grid into the PV. Can

Will Teoh over 8 years ago

Hi,

I am unable to save my data in the editable grid into the PV. Can you help me out please?

In the interface code:
a!gridLayout(
                                                            headerCells: {
                                                                      a!gridLayoutHeaderCell(label: "Cost Element"),
                                                                      a!gridLayoutHeaderCell(label: "Project Manager"),
                                                                      a!gridLayoutHeaderCell(label: "Split %", align: "RIGHT"),
                                                                      a!gridLayoutHeaderCell(label: "Category Code"),
                                                                      /* For the "Remove" column */
                                                                      a!gridLayoutHeaderCell(label: "")
                                                            },
                                                            /* Only needed when some columns need to be narrow */
                                                            columnConfigs: {
                                                                      a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
                                                                      a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
                                                                      a!gridLayoutColumnConfig(width: "NARROW"),
                                                                      a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
                                                                      a!gridLayoutColumnConfig(width: "NARROW")
                                                            },
                                                            rows: a!applyComponents(
                                                                      function: rule!TRAVEL_SAIL_costElementItemRow(
                                                                                items: local!costElements,
                                                                                index: _,
                    ...

Discussion posts and replies are publicly visible

Parents

0 Will Teoh over 8 years ago

...                                                            itemsToken: local!costElementsList
                                                                      ),
                                                                      array: if(or(isnull(local!costElements), count(local!costElements) < 1), {}, 1+enumerate(count(local!costElements))),
                                                                      arrayVariable: local!costElementsList
                                                            ),
                                                            validations: {
                                                                      /* Check the total amount and show a message immediately */
                                                                      with(
                                                                                local!total: todecimal(local!costElements.splitPercentage),
                                                                                if(rule!SI_checkNull(index(local!costElements, "costElementID", "")), null, if(not(local!total = 100),
                                                                                          a!validationMessage( message: "The total of all split percentage must be 100%. It is currently " &
                                                                                          if(rule!SI_checkNull(local!total), 0, local!total) & "%.",validateAfter: "SUBMIT"), null))
                                                                      ),
                                                                      /* Check the # items and show a message on submit */
                                                                      if(rule!SI_checkNotNull(index(local!costElements, "costElementID", "")), null,
                                                                                a!validationMessage( message: "Please enter at least 1 cost element.",validateAfter: "SUBMIT"))
...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Will Teoh over 8 years ago

...                                                            itemsToken: local!costElementsList
                                                                      ),
                                                                      array: if(or(isnull(local!costElements), count(local!costElements) < 1), {}, 1+enumerate(count(local!costElements))),
                                                                      arrayVariable: local!costElementsList
                                                            ),
                                                            validations: {
                                                                      /* Check the total amount and show a message immediately */
                                                                      with(
                                                                                local!total: todecimal(local!costElements.splitPercentage),
                                                                                if(rule!SI_checkNull(index(local!costElements, "costElementID", "")), null, if(not(local!total = 100),
                                                                                          a!validationMessage( message: "The total of all split percentage must be 100%. It is currently " &
                                                                                          if(rule!SI_checkNull(local!total), 0, local!total) & "%.",validateAfter: "SUBMIT"), null))
                                                                      ),
                                                                      /* Check the # items and show a message on submit */
                                                                      if(rule!SI_checkNotNull(index(local!costElements, "costElementID", "")), null,
                                                                                a!validationMessage( message: "Please enter at least 1 cost element.",validateAfter: "SUBMIT"))
...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data