Add/Update form not properly saving into GRID

Hello, I have an Add/Update form and a GRID that can add or update data that is already there. I have 1 dropdown in this form that I can't figure out why it is not saving properly to the GRID. I select 1 of the 2 options from the dropdown and submit but it seems to make it NULL on the GRID no matter which option I choose. 

Any help here would be much appreciated. I will share some code snippets below.

Dropdown data fetch:

local!relTypeData: a!refreshVariable(
    value: rule!TB_QE_getValuesForDropdownCategoryFromKeyValueConfig(
      appName: cons!TB_TEXT_KEY_VALUE_CONFIG_APP_NAMES[2],
      category: cons!TB_TEXT_KEYS_CONFIG_CATEGORIES[13],
      selectionList: { "key1", "value1", "isActive" }
    ).data,
    refreshAlways: if(ri!selection = 12, true(), false())
  ),
  local!isActRelType: index(
    local!relTypeData,
    wherecontains(
      cons!TB_TEXT_ISACTIVE[1],
      touniformstring(
        index(local!relTypeData, "isActive", null)
      )
    ),
    null()
  ),
  local!deActRelType: index(
    local!relTypeData,
    wherecontains(
      cons!TB_TEXT_ISACTIVE[2],
      touniformstring(
        index(local!relTypeData, "isActive", null)
      )
    ),
    null()
  ),
  local!actRelTypeDropDownValue: a!forEach(
    local!isActRelType,
    {
      index(
        local!isActRelType[fv!index],
        "key1",
        null()
      ) & " - " & index(
        local!isActRelType[fv!index],
        "value1",
        null()
      )
    }
  ),

Actual Dropdown:

a!sideBySideItem(
                    item: a!dropdownField(
                      label: cons!TB_LABEL_REL_TYPE,
                      labelPosition: "ABOVE",
                      placeholder: "--- Select Rel Type ---",
                      choiceLabels: if(
                        a!isNotNullOrEmpty(
                          wherecontains(
                            touniformstring(index(ri!userPods, "relType", null)),
                            touniformstring(index(local!isActRelType, "key1", null))
                          )
                        ),
                        local!actRelTypeDropDownValue,
                        reject(
                          a!isNullOrEmpty(_),
                          append(
                            local!actRelTypeDropDownValue,
                            if(
                              a!isNotNullOrEmpty(
                                wherecontains(
                                  touniformstring(index(ri!userPods, "relType", null)),
                                  touniformstring(index(local!deActRelType, "key1", null))
                                )
                              ),
                              index(
                                index(
                                  local!deActRelType,
                                  wherecontains(
                                    touniformstring(index(ri!userPods, "relType", null)),
                                    touniformstring(index(local!deActRelType, "key1", null))
                                  ),
                                  null
                                ),
                                "key1",
                                null
                              ) & if(
                                a!isNullOrEmpty(index(ri!userPods, "relType", null)),
                                "",
                                " - "
                              ) & index(
                                index(
                                  local!deActRelType,
                                  wherecontains(
                                    touniformstring(index(ri!userPods, "relType", null)),
                                    touniformstring(index(local!deActRelType, "key1", null))
                                  ),
                                  null
                                ),
                                "value1",
                                null
                              ),
                              index(ri!userPods, "relType", null())
                            )
                          )
                        )
                      ),
                      choiceValues: if(
                        a!isNotNullOrEmpty(
                          wherecontains(
                            touniformstring(index(ri!userPods, "relType", null)),
                            touniformstring(index(local!isActRelType, "key1", null))
                          )
                        ),
                        index(local!isActRelType, "key1", null),
                        reject(
                          a!isNullOrEmpty(_),
                          append(
                            index(local!isActRelType, "key1", null),
                            index(ri!userPods, "relType", null)
                          )
                        )
                      ),
                      value: ri!userPods.relType,
                      saveInto: {
                        ri!userPods.relType,
                        a!save(ri!selection, 0)
                      },
                      searchDisplay: "AUTO",
                      validations: {
                        if(
                          a!isNotNullOrEmpty(index(ri!userPods, "relType", null())),
                          if(
                            a!isNotNullOrEmpty(
                              wherecontains(
                                touniformstring(index(ri!userPods, "relType", null)),
                                touniformstring(index(local!relTypeData, "key1", null))
                              )
                            ),
                            null,
                            "Select a valid value"
                          ),
                          null()
                        ),
                        if(
                          and(
                            tostring(
                              index(
                                index(
                                  local!relTypeData,
                                  wherecontains(
                                    tostring(ri!userPods.relType),
                                    touniformstring(index(local!relTypeData, "key1", null))
                                  ),
                                  null
                                ),
                                "isActive",
                                null
                              )
                            ) = cons!TB_TEXT_ISACTIVE[2],
                            ri!userPods.isActive = cons!TB_TEXT_ISACTIVE[1]
                          ),
                          "The value is inactive, Please select another value",
                          ""
                        )
                      },

                    )
                  ),

GRID Column:

a!gridColumn(
                          label: cons!TB_LABEL_REL_TYPE,
                          sortField: "relType",
                          value: index(fv!row, "relType", null())
                        ),

Any insight on this would be really appreciated. Let me know if I need to add any additional code snippets to understand the issue more.

Thanks in advance,

Thomas

  Discussion posts and replies are publicly visible

Parents Reply Children