So I have a multi screen app that the user fills in items one page at a time.
Is it possible to do the following.
At the end of page 1 they save the data in a collection something like this
ClearCollect(
MyCollection,
{
Column1: "Value 1", //this is a unique ID
Column2: 123,
Column3: true
}
)
When they complete the items on page 2 I would like to add them to the same collection, same row. Is this possible? As you can see Column1 on page 1 is a unique identifier.
I don't want to wait till the end of page 2 to collect all of the items from page 1 and 2 because this is an offline app so there could be a gap between when they save the items on page 1 to when they do the same for page 2 and also they could even close it down... (obviously I'm also loading to a local data to allow this) but I just was wondering if the above is possible?
Would I achieve it by patching to the collection? or is there a more efficient way to do this?
TIA
