Hi all,
After 3 hours of solid searching + trial and error attempts, I've finally given in and come on here to ask a question. Great forum by the way.
I'm building a Project cost app, which is currently using Excel for datasources:
I have a list of unique projects in a Project Table, and each has an assigned Status; Draft, Submitted, Approved.
And each project has a Cost section where you can allocate a number of cost items to each project. These elements are held in a Cost_table. These link to the Projects using a project_ID field.
What I'm hoping to do is update a field in the Cost_table called Status which gets updated whenever the Project Status gets updated, but despite lots of attempts with the Patch / ForAll commands I've had limited sucess.
I managed to get it to update one record, but it didn't do all of them.
This is what I used to get one record updated:
CTC is a collection of the Cost_table
Gallery1 is displaying the Project Table
ForALL(CTC,Patch(Cost_table,Lookup(CTC, Project_ID=Gallery1.Selected.Project__ID),{Status:Status}))
All help greatly appreciated.
Thanks
