Search
-
Great to hear! Thanks arrowplane.
-
Thanks, Jonathan. I have actually made some headway. Once I've got everything 100% working I'll create a new post with a WordPress Gravity Forms PHP example, something that I and a few others had been looking for. I post a reference in this thread as well.
-
Hello kefpa01,
In addition to my previos comment, you can get the screen value for 8daysAway by clicking on Advanced on DueDateEnd
anc click on SQL Override.
The important thing on SqlOverride is Step 3 as we are more focused on getting the screen value for 8DaysAway field.
In step 1, you can choose Activity table and in Step ...
-
To Whom It May Concern,
I haved added new drop down fields into the estimate line grid and everything seems to pull into the drop down fine. However, I attempted to add the payment terms drop down link from QB into the grid and the drop down values will not show. How do I get this values to appear so I can ...
-
I am glad that your issue is resolved now.
-Inder
-
Hello kefpa01,
According to your requirement the code should look like this. In this code it is looking for value on the grid column and comparing it with screen.
CASE WHEN viewActivity.DueDateEnd < ScreenValue THEN '<font color="red"><b>' + Entity + '</b></font>'
WHEN ...
-
Of course. QB does not let you use more than 5. There's no option to add more.
Anyway, it eventually worked. I'm not sure why it didn't work the first time.
Perhaps there was a syncing lag/issue.
-
The SQL Override is on the grid column DueDateEnd and I want to compare it to a value on the screen called 8DaysAway. So, I'm wanting the override to look something like this.
(CASE WHEN [DueDateEnd] < 'screen value 8DaysAway' THEN ... ) Where 'screen value 8DaysAway' is a date on the screen. How do ...
-
Hello kefpa01,
You syntax should look something like this:
(CASE WHEN [DueDateEnd] < viewActivity.8DaysAway THEN '<font color="red"><b>' + Entity + '</b></font>'
WHEN [DueDateStart] < viewActivity.8DaysAway THEN '<b>' + Entity + '</b>'
ELSE ...
-
Hello MikeB,
There first thing I would check is how many custom fields you have in your QB file. The item list has a limit of 5 custom fields in Pro and Premier version. In Enterprise (starting with V10) you can add up to 15 custom fields in the item list.
Please check it and let me know if that is the issue.
-Inder
|
|
|