ParamQuery Grid
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
Help
Search
Login
Register
ParamQuery grid support forum
»
General Category
»
Help for ParamQuery Pro
»
Date of export
« previous
next »
Print
Pages: [
1
]
Author
Topic: Date of export (Read 301 times)
neoinbiz
Pro Ultimate
Newbie
Posts: 22
Date of export
«
on:
August 08, 2023, 06:15:03 pm »
I want to be able to add the date the export was done.
Example: When a user clicks export button, I want to capture today's date and include it in the report and place in a row or title so it is visible.
Logged
paramvir
Administrator
Hero Member
Posts: 6309
Re: Date of export
«
Reply #1 on:
August 08, 2023, 10:43:37 pm »
1) you can get current date with new Date() and format it to mm/dd/yy with jqueryui formatdate api: $.datepicker.formatDate
https://api.jqueryui.com/datepicker/
2) Export the pqgrid to js workbook, update any cell value with above date and export it to xlsx.
Logged
neoinbiz
Pro Ultimate
Newbie
Posts: 22
Re: Date of export
«
Reply #2 on:
August 08, 2023, 10:48:58 pm »
Well that is close. My objective was during the export the date is injected into a row or somewhere on the workbook dynamically once you hit export button.
Logged
paramvir
Administrator
Hero Member
Posts: 6309
Re: Date of export
«
Reply #3 on:
August 08, 2023, 10:56:19 pm »
above logic is for injecting the date dynamically into the workbook, you can place this in click event handler of button.
Logged
Print
Pages: [
1
]
« previous
next »
ParamQuery grid support forum
»
General Category
»
Help for ParamQuery Pro
»
Date of export