I have created a BAQ with information from the Part Maintenance and Part Rev table and I am looking for a way to update a UD date field with the information from the Effective Date field in the BAQ. Is there a way to accomplish this without having to open each record? My BAQ contains Part.Part#, PartRev.Rev#, PartRev.Effective Date and Part.Date01. I am looking for a way to populate Part.Date01 with the information showing in PartRev.Effective Date.
You can use copy to excel to open the data in excel, copy/paste the Effective Date into the Date01 column and then copy the excel sheet and right click paste update in the dashboard.
I think you will need allow multiple row update to make paste update active. Also be sure the grid is positioned at the top.
So I am still not able to do a paste update in either the BAQ or the Dashboard, I’m not sure what I"m missing. The dashboard doesn’t even have the option available when I right-click in the grid and in the BAQ the paste update is greyed out so not available. We are on version 9.05.702a if that makes a difference.
I started to do some testing to answer Calvin’s question and it did not make a difference on the multi row save. I had made the leap based on the one dashboard having paste update greyed out, but that made no difference.
I discovered that having Show Group by enabled in the dashboard makes the paste update not available.
Lori, this is for E10 but the setup is the same. Make sure your dashboard
properties are set to updateable = true then use the Update all or select
the fields you want to be updateable in the dashboard