Question

grid column coming as empty

Forum|Forum|7 months ago
December 12, 2025
12 replies
0 views

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 
    )
  )
)

gridfield

shubhama926776

Your grid is empty because a!fileUploadField() saves a Document value, but your record field documentId is Text.
Changing the record field datatype to Document would also fix it (and is the cleaner option).

I

iswaryan3520Author

in 24.2 we dont have the document datatype . Should changing it to integer work?

shubhama926776

Have you tried changing it?

mikes0011

Brainy

Can you clarify - you mentioned the DocumentId field is typed as text currently, but when you try it, is it actually being populated with any value? What happens between when the user uploads the new document and the download link is supposed to show up in the grid? FWIW, i believe even now still a form will need to be submitted before a newly-uploaded file is available to be targeted by a Document Download Link (this has changed slightly in the 2025 versions, but certainly not in 24.2).

I

iswaryan3520Author

When the user upload the file in the documentId field value is populated in both local and on submit ruleinput With this format "Document -some integer" , Document:223445. But this is not being populated in the grid.

mikes0011

Brainy

If you set the column to plaintext, what shows up then?

BTW, just for design flexibility, I recommend you make the column use the RichTextDisplayField component to handle showing anything you want as far as links - it allows mixed plaintext and links including formatting (with icons) as well as not showing a link in some cases (for example rows with no document ID present), which is not possible with the plain LinkField component (which i recommend against using in basically any case, since we have the RichTextDisplayField).

harshas2775

When you pass test values for ri!npdoDocument does the grid shows the Document Id label under title column? Also, are the values coming properly for other fields like category, Comments etc?

I

iswaryan3520Author

Other fields are coming properly only documentId column is coming as empty.

harshas2775

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

Sign up

Login with SSO

Login to the community

Login with SSO