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
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?
Other fields are coming properly only documentId column is coming as empty.
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