regarding grids with form

Question

How can we get in uploaded Document name ,uploaded by and uploaded on in supervisor form using grids of 3 column.

Chris · Answer

Replace your local!doc config with a!forEach() to iterate over your list of folders, such as: 
 a!localVariables(
 local!doc: a!flatten(
 a!forEach(
 items: {
 cons!FOLDER1,
 cons!FOLDER2,
 cons!FOLDER3
 },
 expression: folder(fv!item, "documentChildren")
 )
 ), 

 a!gridLayout(
 headerCells: {
 a!gridLayoutHeaderCell(label: "Document Name"),
 a!gridLayoutHeaderCell(label: "Uploaded By"),
 a!gridLayoutHeaderCell(label: "Uploaded On")
 },
 rows: a!forEach(
 items: local!doc,
 expression: a!gridRowLayout(
 id: fv!index,
 contents: {
 a!richTextDisplayField(
 value: a!richTextItem(
 text: document(fv!item,"name")
 )
 ),
 a!richTextDisplayField(
 value: a!richTextItem(
 text: document(fv!item,"lastUserToModify")
 )
 ),
 a!richTextDisplayField(
 value: a!richTextItem(
 text: document(fv!item,"dateCreated")
 )
 )
 }
 )
 )
 )
)

Chris · Answer

Assuming that document is already uploaded, as Stefan notes, you can retrieve those properties using the document() function, such as: 
 a!localVariables(
 local!doc: /* Your Document(s) here */,

 a!gridLayout(
 headerCells: {
 a!gridLayoutHeaderCell(label: "Document Name"),
 a!gridLayoutHeaderCell(label: "Uploaded By"),
 a!gridLayoutHeaderCell(label: "Uploaded On")
 },
 rows: a!forEach(
 items: local!doc,
 expression: a!gridRowLayout(
 id: fv!index,
 contents: {
 a!richTextDisplayField(
 value: a!richTextItem(
 text: document(fv!item,"name")
 )
 ),
 a!richTextDisplayField(
 value: a!richTextItem(
 text: document(fv!item,"lastUserToModify")
 )
 ),
 a!richTextDisplayField(
 value: a!richTextItem(
 text: document(fv!item,"dateCreated")
 )
 )
 }
 )
 )
 )
)

Chris · Answer

Gotcha, correct while you can't point to the folder directly in the code above, you can retrieve the documents that are within the folder using: 
 folder(cons!YOUR_FOLDER, "documentChildren") 
 Updating my code with the logic to retrieve docs from the folder: 
 a!localVariables(
 local!doc: folder(cons!YOUR_FOLDER, "documentChildren"),

 a!gridLayout(
 headerCells: {
 a!gridLayoutHeaderCell(label: "Document Name"),
 a!gridLayoutHeaderCell(label: "Uploaded By"),
 a!gridLayoutHeaderCell(label: "Uploaded On")
 },
 rows: a!forEach(
 items: local!doc,
 expression: a!gridRowLayout(
 id: fv!index,
 contents: {
 a!richTextDisplayField(
 value: a!richTextItem(
 text: document(fv!item,"name")
 )
 ),
 a!richTextDisplayField(
 value: a!richTextItem(
 text: document(fv!item,"lastUserToModify")
 )
 ),
 a!richTextDisplayField(
 value: a!richTextItem(
 text: document(fv!item,"dateCreated")
 )
 )
 }
 )
 )
 )
)

Mike Schmitt · Answer

This is what will happen if you don't use the folder() function correctly. Please refer back to how Chris used it in his example, in particular the highlighted part: 
 
 The properties you can pass into folder() are strictly defined, you can't just pass in random strings as you've done (i.e. passing in "SG_Document"), and expect it to work.

regarding grids with form

Top Replies