Search found 87 matches

by dhickey76
04 Jun 2021, 18:37
Forum: Discussion
Topic: Webdatarocks Pivot Table Pro
Replies: 3
Views: 377

Re: Webdatarocks Pivot Table Pro

Ok cool I'll give that a shot
by dhickey76
04 Jun 2021, 02:12
Forum: Discussion
Topic: Webdatarocks Pivot Table Pro
Replies: 3
Views: 377

Webdatarocks Pivot Table Pro

Hi Sergey, I'm wanting to create my own theme for the Pivot Table Pro reports. According to the Webdatarocks.com guide I have to add a link to the new custom css file. Can you let me know which file I have to add the link to? Screenshot_5.png See https://www.webdatarocks.com/doc/custom-report-themes...
by dhickey76
26 May 2021, 19:04
Forum: Discussion
Topic: List of records by MySql Query field filter
Replies: 1
Views: 387

List of records by MySql Query field filter

Hi Sergey, Im using the List of records by MySql Query field to pull information from Entity A to Entity B. Shipments table (Entity B) InkedScreenshot_2_LI.jpg I am not able to add a filter to the "PO's" and "Part PO's" fields. They are both "List of Records by MySql Query&q...
by dhickey76
20 May 2021, 01:37
Forum: Suggestions
Topic: Menu shortcuts
Replies: 0
Views: 293

Menu shortcuts

Any chance we could get some top menu shortcuts for admins? The amount of times I click "Application Structure | Entities" is mind numbing. The links (icons) could be set up to link to your most used admin pages (field config, listing config, item page config etc) InkedScreenshot_3_LI.jpg ...
by dhickey76
17 May 2021, 19:09
Forum: Discussion
Topic: Calculate time between automatic status changes
Replies: 4
Views: 404

Re: Calculate time between automatic status changes

Sergey I realize it can be done using a sql function. Im just not sure how to write it. How would I pull in the date the automatic status was changed to "CLOSED"?

Thanks,
Damien
by dhickey76
14 May 2021, 02:14
Forum: Discussion
Topic: Calculate time between automatic status changes
Replies: 4
Views: 404

Calculate time between automatic status changes

Is there a way to calculate the days difference between two statuses? Due to restrictions on my hosting provider I cannot use the "Days Difference" field. I need to calculate the days between when the record was added [date_added] and when the automatic status "Closed" was set (v...
by dhickey76
25 Mar 2021, 21:12
Forum: Discussion
Topic: Database Error: 1418 When select time difference
Replies: 1
Views: 310

Re: Database Error: 1418 When select time difference

I get the same error and was told by my hosting company that its a security feature on the database admin side that prevents the field from running properly. You can still manually perform the calculation using a formula. The date is stored as a unix timestamp so its fairly simple to work with.
by dhickey76
16 Mar 2021, 19:23
Forum: Discussion
Topic: Pivot Table Pro formatting
Replies: 2
Views: 277

Re: Pivot Table Pro formatting

Thanks Sergey. I was able to use "Y-m" which breaks the year, month and day into separate fields.

date fields.png
date fields.png (7.75 KiB) Viewed 251 times

I could then sort the row by year and month

Row field value.png
Row field value.png (2.11 KiB) Viewed 251 times
Date sort.png
Date sort.png (10.33 KiB) Viewed 251 times

Thanks!
by dhickey76
15 Mar 2021, 22:03
Forum: Discussion
Topic: Pivot Table Pro formatting
Replies: 2
Views: 277

Pivot Table Pro formatting

Hi Sergey, When sorting dates on the pivot table pro report are you able to sort by chronological order? The dates are formatted and grouping correctly but they look like they are sorting alphabetically. Pivot Pro Pivot Table Pro.png Is it possible to sort from oldest to newest instead? See excel ex...