Hi @rbalza :
Thanks for your feedback.If there is anything wrong with my understanding please tell me:
1\There is a Gallery and it's items is a collection named GalleryPricingData
2\You use a button to add a new record into "GalleryPricingData" to add a new row into the Gallery.The code in the 'add a new row button' is:
Collect(
GalleryPricingData,
{
Job_x0020_Category: JobCategory.Selected.Result,
Entity_x0020_Type: EntityType.Selected.Result,
Job_x0020_Type: JobType.Selected.Result,
Invoice_x0020_Description: InvoiceDescription.Value,
Min_x0020_Fee: MinFee.Value,
Qty: Quantity.Value,
Nominal_x0020_Value: NominalValue.Value,
Complexity_x0020_Value: ComplexityValue.Value,
Total: Total.Value,
Client_x0020_Name: ClientName.Selected.Result,
ClientGroup: ClientGroup.Value,
ClientCode: ClientCode.Value
}
)
3\You want to automatically synchronize all the modifications you make in the gallery to the collection GalleryPricingData.
If my guess is correct, then this requirement is very easy to achieve——
There are many controls for input in your gallery, you can achieve your needs by setting their OnChange property:
For example:
I assume there is a textinput control(TextinputValue) to Update the Value field of the current record in GalleryPricingData,then you could set the TextinputValue's OnChange property to:
Patch(GalleryPricingData,ThisItem,{Value:Self.Text})
if Value is a number column it should be
Patch(GalleryPricingData,ThisItem,{Value:Value(Self.Text)})
By analogy, you only need to set the OnChange familiarity of all the controls in the Gallery, and any changes you make in the Gallery can be synchronized to the collection GalleryPricingData in real time.
Best Regards,
Bof