Hi all,
I have created a gallery which uses a collection as its data source, this collection is generated when the screen becomes visible as such - ClearCollect(Findings, {no:1}). I also have a button that creates additional rows in the collection - Patch(auditFindings, Defaults(Findings), {no:CountRows(Findings)+1). In the gallery, I have a field called reportnumber-00X whereby X is thisitem.no
The problem comes in when I try to delete the entry in the gallery (done through a button in the gallery with onSelect property of RemoveIf(Findings, no=thisitem.no) . I would like the field reportnumber-00X to update automatically. E.g. if i have reportnumber-001, reportnumber-002, reportnumber-003, reportnumber-004 and I delete reportnumber-002, the gallery should show reportnumber-001, reportnumber-002, reportnumber-003 instead of reportnumber-001, reportnumber-003, reportnumber-004. How can this be achieved? TIA!