Hi @SteveYao ,
Yes, each item in this gallery is capturing the timestamp and the notes.
To give you more context, I'm currently building an for the field team to complete the service reports from field. The step has Master gallery nested with three more galleries, Job notes, resources and material. Each gallery will collect the data and patch to a SP list on clicking the save & close, of course excluding the blank rows. On selection from previous screen, the app will create a temp collection for each section to facilitate the repeating tables within the galleries. Data entry is fine. I'm able to submit as many as entries required. However, when editing the previously recorded lines, the app is not letting me go in to the text box after 5th row. the formulas as follows.
Select Icon from previous page:
This will collect existing entries from the SP list and adds a blank row to the collection for new entries. It also adds few columns for the variables i need to show edit/delete options as necessary.
ClearCollect(
ThisSOJobNotes,
AddColumns(
Filter(
MySPList,
Title = MySOGalleryList.Selected.JobNumber
),
"ShowAddIcon",
false,
"ShowEditIcon",
true,
"EditThisNote",
false,
"NewJobNote",
false,
"ExistingNote",
true,
"NewNoteAdded",
false
)
);
Collect(
ThisSOJobNotes,
{
Title: "",
DateTimeWorked: "",
JobNoteDetails: "",
ShowAddIcon: true,
ShowEditIcon: false,
EditThisNote: false,
NewJobNote: true,
ExistingNote: false,
NewNoteAdded: false
}
)
Once the user is in the execution screen, the + icon will do the below.
Patch(
ThisSOJobNotes,
ThisItem,
{
Title: MySOGalleryList.Selected.JobNumber,
DateTimeWorked: ClockTimerText.Text,
JobNoteDetails: ThisSOJobNotesText.Text,
ShowAddIcon: false,
ShowEditIcon: true,
EditThisNote: false,
NewJobNote: false,
ExistingNote: false,
NewNoteAdded: true
}
);
Collect(
ThisSOJobNotes,
{
Title: "",
DateTimeWorked: "",
JobNoteDetails: "",
ShowAddIcon: true,
ShowEditIcon: false,
EditThisNote: false,
NewJobNote: true,
ExistingNote: false,
NewNoteAdded: false
}
)
The edit icon in the gallery will set the editing mode
Select(Parent);Patch(ThisSOJobNotes,ThisItem,{EditThisNote:true})
The check icon will become visible and patches the changes made and sets the edit mode off.
Select(Parent);Patch(ThisSOJobNotes,ThisItem,{JobNoteDetails:ThisSOJobNotesText.Text,EditThisNote:false})
The display mode of the text input control is set to below.
If(ThisItem.EditThisNote=true||ThisItem.NewJobNote=true,DisplayMode.Edit,DisplayMode.Disabled)
This is all working as expected. Only issue is if the number of items are more than 5, making changes to the text is not possible.
Some use cases requires the job to be carried over few days. In that scenario, there will be changes needed to the data from the field or from the office. The same gallery mechanism will be used in the web app and rest of the galleries as well.
Hope this helps. Let me know if you need more details.
Appreciate your help. Thank you!!
Sasi.
