[Solved] Last Modified

Discuss using and your tips/tricks for BookCAT
Post Reply
User avatar
Alex Ivanovich
Posts: 293
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

[Solved] Last Modified

Post by Alex Ivanovich » Thu Jan 12, 2017 12:19 pm

there is a field "Registered" in Library , indicating when and entered the record
one can also display a field "Last Modified", to know when the record was changed

it's possible? :|
Last edited by Alex Ivanovich on Sun Jan 15, 2017 6:07 pm, edited 1 time in total.

J.F. Le Deist
Posts: 41
Joined: Thu Aug 20, 2015 7:49 am
Location: Brittany, France
Contact:

Re: Last Modified

Post by J.F. Le Deist » Thu Jan 12, 2017 7:05 pm

I would be interested, too. but only if I don't have to go inside the program ( = rewriting some lines )

I have seen that this field is present in "Tools" > "Database setup" > but noted "internal use"
I never tried to move it to general or to appraisal.

User avatar
DougWilliams
Site Admin
Posts: 235
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA
Contact:

Re: Last Modified

Post by DougWilliams » Fri Jan 13, 2017 11:36 am

I have both being displayed on my Album form.
Capture.JPG
Capture.JPG (43.5 KiB) Viewed 623 times
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

User avatar
Alex Ivanovich
Posts: 293
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Last Modified

Post by Alex Ivanovich » Fri Jan 13, 2017 6:30 pm

This field is not present in BookCAT :|

User avatar
Alex Ivanovich
Posts: 293
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Last Modified

Post by Alex Ivanovich » Fri Jan 13, 2017 7:03 pm

I found the code :)

now is visible in BookBrowse

Code: Select all

<tr> 
            <td class="record_table_fieldname" nowrap=""><xsl:value-of select="/data/fld/book/lastmodified/@name"/></td>
            <td class="record_table_fieldvalue"><xsl:value-of select="lastmodified"/><xsl:text> </xsl:text><xsl:value-of select="lastmodified/@time"/></td>
          </tr>
but I can not see it in the record sheet :roll:
Attachments
Last Modified.png
Last Modified.png (20.42 KiB) Viewed 610 times
Screen Capture #069.png
Screen Capture #069.png (70.97 KiB) Viewed 610 times

User avatar
Alex Ivanovich
Posts: 293
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Last Modified

Post by Alex Ivanovich » Fri Jan 13, 2017 7:29 pm

solved the mystery ;)
go to "Forms Designer", Insert Field and "Internal" and visible
Attachments
Insert Field.png
Insert Field.png (100.64 KiB) Viewed 607 times

kevinrailway
Posts: 27
Joined: Thu Jan 07, 2016 8:32 am

Re: Last Modified

Post by kevinrailway » Sun Jan 15, 2017 12:45 am

I approached this from an entirely different angle. I had discovered the 'Forms Designer' method shown by Alex.

However, what I wanted to show, was entries that I had altered in to me a significant way. I wanted to see items with meaningful changes & not when it was last altered in any way. By default, if you make a change to an entry, then change it back to its original form, that counts as a 'change', when its not! I hope that is clear. :)


Some examples of what I mean is, I wanted to ignore minor changes such as fixing typos and spelling mistakes, but did want to show updated information.

It appeared to me that the best approach was to include a field that could be changed, when I felt it needed to and not automatically.

What I did was to change an existing field & enter it as required. I used 'Custom 09' (since it is already a date format) and renamed it 'Last Edited' (by me). That way, if I make what I think is a significant change, I can enter the date changed on an individual basis (usually of course it is 'Today' - but could be something else). Otherwise I ignore it.

I hope this is useful & shows just how wonderfully flexible the Cat series of databases is.

User avatar
LotsOCds
Posts: 177
Joined: Thu Aug 20, 2015 4:23 am
Location: California, USA

Re: Last Modified

Post by LotsOCds » Sun Jan 15, 2017 4:09 am

For those who don't know, there are some handy keyboard shortcuts you can use in date fields.
  • Ctrl-d will enter today's date
  • + will add one day to the date in the field
  • - will subtract one day from the date
Cheers,
Dave

User avatar
Alex Ivanovich
Posts: 293
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Last Modified

Post by Alex Ivanovich » Sun Jan 15, 2017 5:42 pm

Thanks Dave for tips ;)

Post Reply