Drawing list revision date

[TKA]

in both issue and revision reports issue data is used for the date, I am trying to use revision date in my set up, I changed the formula but it doesn't seem to work, below first one works and second doesn't, wondering if anybody has an idea how to do it.

 

=SUBSTRING(FORMATFIELD('Title Block Issue Data-1', 'Date'), '/', 1)

=SUBSTRING(FORMATFIELD('Title Block Revision Data-1', 'Date'), '/', 1)

[Nikolay Zhelyazkov]

Hello @TKA,

 

Revisions are not document wide as Issues. That is why they are not stored in their record formats and cannot be extracted using Format Field.

 

In order to extract revision data you will have to use database row with title blocks in it and extract the data from the records attached to the title blocks. If you are using VW 2020, you can easily create report extracting revision data using Tools->Reports->Create report and select the revision records you want. In VW2020 revision data is extracted the same way as any other record data using <Record Name>.<Field Name> in the database row.

 

Let me know if you need any additional help.

 

Best Regards,

Nikolay Zhelyazkov

[TKA]

thanks, that pert I know, another question is why revision  number and name and date shows properly and all other data shows inverted, meaning "BY", "ZONE" specific to the sheet revision shows in another revision column?  In rev pop up it shows the same as the title block and TB Manager, however in the spreadsheet whether ready made from VW or my own it shows in reverse order.

Edited August 11, 2020 by TKA

[Nikolay Zhelyazkov]

11 hours ago, TKA said:

thanks, that pert I know, another question is why revision  number and name and date shows properly and all other data shows inverted, meaning "BY", "ZONE" specific to the sheet revision shows in another revision column?  In rev pop up it shows the same as the title block and TB Manager, however in the spreadsheet whether ready made from VW or my own it shows in reverse order.

 

Could you give me some more information about this one? Maybe a test file and an image with the desired results? I do not see any difference in the Revision Number and Revision Zone order in reports.

 

Thanks,

Nikolay Zhelyazkov

[TKA]

Of you look on the right hand side in the worksheet the ++ is assigned to rev 1 and on the title block and pop up window is assigned to rev 2.  If I have 3 or more revisions then the reverse order will be maintained rev 1 will have rev 9 zone assigned in the worksheet only.

[Nikolay Zhelyazkov]

17 minutes ago, TKA said:

Of you look on the right hand side in the worksheet the ++ is assigned to rev 1 and on the title block and pop up window is assigned to rev 2.  If I have 3 or more revisions then the reverse order will be maintained rev 1 will have rev 9 zone assigned in the worksheet only.

I think that this is valid for all Revision Data fields, as well as Issue Data. What is happening here is that both Revision and Issue data records are managed in such a way that the latest revision/issue is stored in the record with index -1. The reason for this is that we want an easy way to get the latest revision/issue.

 

If this is what is happening, it is working as designed and you should reverse the order of your worksheet formulas to get the desired results.

[TKA]

So what you are saying is that rev 1 data column will always display the latest revision say 3 or 7 and rev 3 or 7 will display data for rev 1?

[Nikolay Zhelyazkov]

1 minute ago, TKA said:

So what you are saying is that rev 1 data column will always display the latest revision say 3 or 7 and rev 3 or 7 will display data for rev 1?

- Yes. The latest input is always stored in the record with index 1.

[TKA]

so every time I have a new revision I have to redo all revision columns! That is a bit crazy that there is no option to have it read left to right as it is required by the building dept and all contractors.

[TKA]

who came up with this order and for what reason?

[Nikolay Zhelyazkov]

13 hours ago, TKA said:

who came up with this order and for what reason?

This is the way issues and revisions are working from at least VW2018, if not earlier. You can change the order they are displayed in the Title Block Border layout, but for worksheets, you will have to modify your formulas.

[TKA]

I have no issue with the title block as the info there is consistent (rev #"" "date" and "by") with TB Manager, however, in the worksheet rev 1 formula displays revision 2 data and vice versa.  I select from pull down menu "rev 1" (as in the pic below) and the data displayed in this column is from "rev 2", and once I have more revisions than the whole thing gets more complex.  So the question is how to make the records work as per their pull down menus??  Rev 1 = rev 1 Data, Rev 2 = rev 2 Data, and so on.

[Nikolay Zhelyazkov]

11 hours ago, TKA said:

I have no issue with the title block as the info there is consistent (rev #"" "date" and "by") with TB Manager, however, in the worksheet rev 1 formula displays revision 2 data and vice versa.  I select from pull down menu "rev 1" (as in the pic below) and the data displayed in this column is from "rev 2", and once I have more revisions than the whole thing gets more complex.  So the question is how to make the records work as per their pull down menus??  Rev 1 = rev 1 Data, Rev 2 = rev 2 Data, and so on.

 

It is not possible to change how the data is stored in the records. Let me give you an example:

 

If you have 3 revisions, the newest revision will be stored in the record Revision Data-1 and the oldest will be stored in the record Revision Data-3. This is how the revision data works from the inside and it cannot be changed. Do not get confused by the index in the record name, it is not corresponding to the revision data number. The revision and issue data is stored in reverse order in the records. That way, if you want to always see the latest N revisions/issues, you simply create your drawing list with records [1-N] and you do not have to modify it anymore.

 

If there is something that I do not understand correctly, please, send me an example file with the actual results and with what you expect to see and I will tell you if it is possible with the current functionality.

[TKA]

On 8/11/2020 at 3:23 PM, TKA said:

I was hoping that it is not the case, but I see what you are saying, unfortunately, the building dept or contractors require chronological history of revisions issues so I will have to keep doing this manually.  There is another thing about the revisions, normally we are required to indicate one of 4 statuses of any sheet: New, Updated, No change, Removed.  I have been using one of the fields ("BY") for inputing that info but in reality it would be way better to have just check boxes, I guess that may never happen.