grid column coming as empty

Hi , I am building a document upload form after uploading the document it should be populating in the gridfield with the link format where user can download the lfile. but that field is coming as empty.  This is my code. The documentId field is  text now, we don't have access to edit it now . can changing the datatype will fix the issue or is there anything  elseI have to look into?

 

a!localVariables(
  local!documentId: null, 
  local!category: null,  
  local!comment: null,    
  local!showUploadSection: false(), 
  local!npdoDocumentList: ri!npdoDocument,

  a!formLayout(
    contents: {
      a!sectionLayout(
        contents: {
          a!boxLayout(
            label: "Supporting Documents",
            contents: {
              a!gridField(
                data: local!npdoDocumentList, 
                columns: {
                  a!gridColumn(
                    label: "Title",
                    value: a!linkField(
                      
                      label: fv!row['recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{0c0ce663-8d05-43a5-9c23-92394e8102ec}documentId'],
                      links: a!documentDownloadLink(
                        document: tointeger(fv!row['recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{0c0ce663-8d05-43a5-9c23-92394e8102ec}documentId'])
                      )
                    )
                  ),
                  a!gridColumn(
                    label: "Category",
                    value: fv!row['recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{408a7879-6ab6-45cb-a35e-7330c9caf15e}category']
                  ),
                  a!gridColumn(
                    label: "Comments",
                    value: fv!row['recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{dfc46fd3-86fc-4d85-b663-544b3b9d1031}comment']
                  ),
                  a!gridColumn(
                    label: "Uploaded On",
                    value: fv!row['recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{7481670c-f621-4872-bd46-d6d20909e139}uploadedOn']
                  ),
                  a!gridColumn(
                    label: "Uploaded By",
                    value: fv!row['recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{3ad4e016-cf0f-4bf3-8231-ef8cbf9bed92}uploadedBy']
                  ),
                  
                }
              )
            },
            style: "INFO",
            labelSize: "MEDIUM"
          )
        }
      ),
      a!sectionLayout(
        contents: {
          a!buttonLayout(
            primaryButtons: {
              a!buttonWidget(
                label: "Upload Docs",
                submit: false, 
                style: "SOLID",
                icon: "file-upload",
              
                saveInto: a!save(local!showUploadSection, true()),
                showWhen: not(local!showUploadSection) 
              )
            }
          )
        }
      ),
      a!sectionLayout(
        contents: {
          a!boxLayout(
            label: "Upload Document",
            contents: {
              a!fileUploadField(
                label: "Choose a file",
                required: true,
                target: cons!NPDO_REQUEST_DOCUMENTS_FOLDER, 
                maxSelections: 1, 
                value: local!documentId, 
                labelPosition: "ADJACENT",
                saveInto: local!documentId
              ),
              a!dropdownField(
                choiceLabels: { "New Request", "Miscellaneous" },
                choiceValues: { "New Request", "Miscellaneous" },
                label: "Category",
                required: true,
                labelPosition: "ADJACENT",
                placeholder: "Document category",
                value: local!category,
                saveInto: local!category
              ),
              a!paragraphField(
                label: "Comments",
                labelPosition: "ADJACENT",
                required: true,
                value: local!comment, 
                saveInto: local!comment
              )
            }
          )
        },
        showWhen: local!showUploadSection 
      )
    },
    buttons: a!buttonLayout(
      primaryButtons: {
        a!buttonWidget(
          label: "Submit",
          submit: true, 
          style: "SOLID",
          saveInto: {
            
            a!save(
              local!npdoDocumentList,
              append(
                local!npdoDocumentList,
              'recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document'(
                'recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{0c0ce663-8d05-43a5-9c23-92394e8102ec}documentId': local!documentId,
               'recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{408a7879-6ab6-45cb-a35e-7330c9caf15e}category': local!category,
               'recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{dfc46fd3-86fc-4d85-b663-544b3b9d1031}comment': local!comment,
               'recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{13c5c9df-b703-4040-baf4-64a65ffc62f3}uploadedBySOEID': loggedInUser(),
               'recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{7481670c-f621-4872-bd46-d6d20909e139}uploadedOn': now(),
               'recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{041e09bf-8b95-4f82-87c6-6289b8c22b57}isActive': 1,
               'recordType!{a1b2b5cb-c59b-4595-aff1-2d50b50e490a}NPDO Document.fields.{3ad4e016-cf0f-4bf3-8231-ef8cbf9bed92}uploadedBy': concat(user(loggedInUser(), "firstName")," ",user(loggedInUser(), "lastName"))
                  
                )
              )
            ),
            a!save(ri!npdoDocument,local!npdoDocumentList),
            
            a!save(local!documentId, null),
            a!save(local!category, null),
            a!save(local!comment, null),
            a!save(local!showUploadSection, false())
          }
        )
      },
      secondaryButtons: {
        a!buttonWidget(
          label: "Cancel",
          submit: false,
          style: "OUTLINE",
          validate: false,
          saveInto: {
           
            a!save(local!documentId, null),
            a!save(local!category, null),
            a!save(local!comment, null),
            a!save(local!showUploadSection, false())
          }
        )
      },
      showWhen: local!showUploadSection 
    )
  )
)

  Discussion posts and replies are publicly visible

Parents Reply
  • 0
    Certified Lead Developer
    in reply to iswaryan3520

    Is your record/database having the data for documentId in it then column should not be empty. Suggest you to verify the data is retrieved to the documentId field in your record by assigning the documentId directly to the value of the first column instead of linkfield(). If you can see the data there then next step is to check the link definition. If vaue is not visible in title column then check if data is correctly passed to the UI or not. Let me know how it goes

Children
No Data