Hi, in my data view I would like to display a kind of footnote saying something like "data was last modified on ..." and show the date when the last time a record was added or modified, depending on which was most recent. How could I accomplish this?
Thank you for helping,
Beate
Thank you for helping,
Beate
Hi Beate,
Add a DB Read action to get the last saved data (you may already have that) and add the column name with that info to a Custom Code element e.g.
Bob
Add a DB Read action to get the last saved data (you may already have that) and add the column name with that info to a Custom Code element e.g.
<p>Data was last modified on {last_modified}.</p>
. . . but use the correct column name; and you may also want to add some code to format the date before displaying it.
Bob
Hi GreyHead,
umm, thanks, but if I understand you correctly, this would be shown in each line instead of at the bottom of the page?
Sorry, I am very new to Connectivity (just started this morning) and have yet to find my way around.
umm, thanks, but if I understand you correctly, this would be shown in each line instead of at the bottom of the page?
Sorry, I am very new to Connectivity (just started this morning) and have yet to find my way around.
Hi Beate,
If you call it in the listing footer then it will be displayed one time only, and its strongly advised to use v6 for new projects as it has many more features.
Best regards,
Max
If you call it in the listing footer then it will be displayed one time only, and its strongly advised to use v6 for new projects as it has many more features.
Best regards,
Max
Hi Max,
thanks for your reply. You say "it is displayed one time only" - yes, thats the idea. I want only the newest "someone has changed something" date displayed. People dont care for too much information - if or when each single record was modified is highly unimportant to them. They want to quick check if there is news at all. If not, they go on, else they will have a closer look at the list or print it out.
Since I use Chronoforms5 as well, I reckon I need to use the same version for connectivity. Especially when it is recommended to re-install CronoForms after installing Connectivity.
Greetings,
Beate
P.S: You may want to try not to sound so aggressive, especially when not offering a solution. People usually have reasons for what they do, even if those reasons might not be obvious. I was asking for help, not to be bullied.
thanks for your reply. You say "it is displayed one time only" - yes, thats the idea. I want only the newest "someone has changed something" date displayed. People dont care for too much information - if or when each single record was modified is highly unimportant to them. They want to quick check if there is news at all. If not, they go on, else they will have a closer look at the list or print it out.
Since I use Chronoforms5 as well, I reckon I need to use the same version for connectivity. Especially when it is recommended to re-install CronoForms after installing Connectivity.
Greetings,
Beate
P.S: You may want to try not to sound so aggressive, especially when not offering a solution. People usually have reasons for what they do, even if those reasons might not be obvious. I was asking for help, not to be bullied.
Hi Beate,
I understand, but for this you will need a custom query, if you use v5.
You can use Connectivity v6 to list the data of any table, but integrating a v5 form to edit the data will not be straight forward, but if you do that, you can use a "data read" function to get the record with last modified date and show the date on the list.
Best regards,
Max
I understand, but for this you will need a custom query, if you use v5.
You can use Connectivity v6 to list the data of any table, but integrating a v5 form to edit the data will not be straight forward, but if you do that, you can use a "data read" function to get the record with last modified date and show the date on the list.
Best regards,
Max
This topic is locked and no more replies can be posted.