Project Online – How do you write data back to PWA using SQL?

[Norman Christensen]

We would like o keep certain fields in PWA “read-only” while writing their content using SQL.
Is there a way to do that?

Thanks.. Norm

[Anonymous]

Hi Norm. Yes, you can do that. Create the field to update (let’s call it “Budget”). Then create another custom field called “View Budget” with the formula [Budget]. That will view the budget without being able to edit it. The one thing I don’t know with writing it using SQL is whether the field will get calculated. You may have to play around with saving or publish the project. Good luck…

[Author]

Posts