Adding multiple files to an item in an editable grid

Question

Hi, 
 I want to upload multiple files to each item in an editable grid. I am using a link to add documents outside of the grid. When I submit the form for adding documents, I want to associate the documents with relevant item. I am using rule inputs of request _tems and request_item_documents CDTs. Because the requestitemId is null, I am not able to fetch the documents for the relevant request item.

How do I resolve this? Thanks in advance. 
 a!localVariables(
 local!hardwareClassList: rule!AMF_QR_getHardwareClassifications(),
 local!currentUser: loggedInUser(),
 
 local!selectedId,
 {
 a!gridLayout(
 label: "",
 labelPosition: "ABOVE",
 headerCells: {
 a!gridLayoutHeaderCell(label: "PDM Number", align: "CENTER"),
 a!gridLayoutHeaderCell(label: "Serial Number", align: "CENTER"),
 a!gridLayoutHeaderCell(
 label: "Part Description",
 align: "CENTER"
 ),
 a!gridLayoutHeaderCell(label: "Revision", align: "CENTER"),
 
 a!gridLayoutHeaderCell(label: "HW Class", align: "CENTER"),
 a!gridLayoutHeaderCell(label: "Quantity", align: "CENTER"),
 a!gridLayoutHeaderCell(label: "Document(s)", align: "CENTER"),
 a!gridLayoutHeaderCell(label: "")
 },
 columnConfigs: {
 a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 2),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 2),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3),
 
 a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 2),
 a!gridLayoutColumnConfig(width: "NARROW", weight: null),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 1),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 1),
 a!gridLayoutColumnConfig(width: "ICON")
 },
 rows: {
 a!forEach(
 items: ri!requestItems,
 expression: a!gridRowLayout(
 contents: {
 a!textField(
 value: fv!item.pdmNumber,
 saveInto: fv!item.pdmNumber,
 characterLimit: 64,
 showCharacterCount: false,
 
 ),
 a!textField(
 value: fv!item.serialNumber,
 saveInto: fv!item.serialNumber,
 characterLimit: 400,
 showCharacterCount: false,
 
 ),
 a!textField(
 value: fv!item.partDescription,
 saveInto: fv!item.partDescription,
 characterLimit: 255,
 showCharacterCount: false,
 
 ),
 a!textField(
 value: fv!item.revision,
 saveInto: fv!item.revision,
 characterLimit: 64,
 showCharacterCount: false,
 
 ),
 
 a!dropdownField(
 placeholder: "HW Class",
 choiceLabels: index(
 local!hardwareClassList,
 'recordType!{3ec8fedc-5057-4343-8c39-cf34c46901cf}AMF Hardware Class.fields.{bc9287be-dd00-4682-9f35-6a706a8e1c5d}name'
 ),
 choiceValues: index(
 local!hardwareClassList,
 'recordType!{3ec8fedc-5057-4343-8c39-cf34c46901cf}AMF Hardware Class.fields.{30f9e578-81cf-4a40-b567-9bf85020c4b9}hardwareClassId'
 ),
 value: fv!item.hardwareClassId,
 saveInto: fv!item.hardwareClassId,
 
 ),
 a!integerField(
 value: a!defaultValue(value: fv!item.quantity, default: 0),
 saveInto: fv!item.quantity,
 showWhen: if(
 a!isUserMemberOfGroup(
 local!currentUser,
 cons!AMF_GRP_VENDOR_USERS
 ),
 false,
 true
 )
 ),
 a!linkField(
 links: {
 a!dynamicLink(
 label: "Upload Documents",
 value: fv!index,
 saveInto: local!selectedId
 )
 }
 ),
 a!richTextDisplayField(
 value: a!richTextIcon(
 icon: "times",
 altText: "Remove" & fv!index,
 caption: "Remove ",
 link: a!dynamicLink(
 value: fv!index,
 saveInto: {
 a!save(fv!item.isActive, false()),
 a!save(
 ri!requestItems,
 remove(ri!requestItems, save!value)
 )
 }
 ),
 linkStyle: "STANDALONE",
 color: "NEGATIVE"
 )
 )
 }
 )
 )
 },
 addRowLink: a!dynamicLink(
 label: " Add Request Item",
 value: 'type!{urn:com:appian:types:AMF}AMF_Request_Item'(
 isActive: true(),
 createdOn: now(),
 createdBy: local!currentUser,
 
 ),
 saveInto: {
 a!save(
 ri!requestItems,
 append(ri!requestItems, save!value)
 )
 }
 ),
 showWhen: isnull(local!selectedId),
 rowHeader: 1,
 
 ),
 a!localVariables(
 local!selectedItem: if(
 isnull(local!selectedId),
 {},
 displayvalue(
 local!selectedId,
 ri!requestItems.requestItemId,
 ri!requestItems,
 {}
 )
 ),
 
 local!documents: {},
 {
 a!sectionLayout(
 
 label: "Documents for " & local!selectedItem.partDescription,
 contents: {
 rule!AMF_FRM_AddRequestItemDocuments(documents: local!documents),
 a!buttonArrayLayout(
 a!buttonWidget(
 label: "Submit",
 saveInto: {
 local!selectedId,
 a!save(
 ri!documents,
 append(ri!documents,local!documents)
 ),
 a!save(local!documents,{})
 
 }
 )
 )
 },
 showWhen: not(isnull(local!selectedId))
 ),
 
 }
 )
 }
)

Mike Schmitt · Answer

If you don't want to mess with nested CDTs (and i also try my best to avoid them), a modern potential solution might be some elegant advanced usage of nested MAP local variables. Each parent layer map would contain one "request item" member then a "documents" member which would store an array of your document CDTs (zero to many). 
 You could assemble this map fairly easily on your interface (and it would look sensible as you fill things out, in the preview pane), then in your process, split the map entries out into the appropriate individual PVs, and write them to the DB. For instance, after writing your array of Request Items (and capturing the autogenerated PKIDs into the process), you would have a subsequent node loop over the map yet again and save the Document Array map entries into an array of Documents, filling in the Request Item ID with the PV array member that corresponds with the current location in the Map (i.e., when reading the documents from Map entry 1, fill in the request item ID found in the written request item PV entry 1, and so on for subsequent entries).

Adding multiple files to an item in an editable grid

Top Replies