Method Community

Hi Robert, Report designer scripting generally falls beyond what we can help with on the forums. That being said, I was able to figure this out with some help from our professional services team and some Google searching. The foreground color and background color can be altered using the .ForeColor & .BackColor properties. Here is an ...

Is it possible for me to customize Google Gadget screens?  Thanks.

In report Designer, I need the VB syntax for altering the colors of the font (foreground) and background.  I need to change colors of report fields which are not tied directly to a table column.  Thanks.

We use Class in the SalesOrderLine (SOL) grid in our Sales Order (SO) screen (customized of course).  I have yet to be successful using a Text Change action in a grid column to update a value in the grid row.  I can call the Text Change action and see the changes made via a Text Change action on the grid but once ...

Here is the FOR...LOOP construct I am using successfully: ..... FOR Week as integer = 1 to WeekCount '' what if its one week and WeekCount = 0?? Does the loop fire once at least?    newrate = cSng(WeekCounter.text) + 1 ' or to create a loop that calcs it once correctly, including W,1,B SOL freq   WeekCounter.text = ...

How can we do this in OnBeforePrint events?  I've got some complex formulas to use to change the background colors of certain derived (calculated) values.  The values of these "cells" are not tied to a table field, they are completely calculated within OnBeforePrint events.   I'm going to try using ...

Hi Matt, I believe the default filter should populate your grid with records without the need to add this action to the screen’s Load actions. I’ll create a ticket and post back here with any updates. I believe the reason your date picker is being reset is due to your Back or Save & Back button’s Go To Screen ...

Hi Audisho, The screen does load without error now. I am having the same results as you that the grid does not load right away. Its worth checking to see if it should be doing that, but its not a big problem as i can put a refresh grid action on the screen load and still get the desired results. On a related note I noticed the date picker ...

Hi Matt, This issue should be resolved. Try this again and let me know if you’re still running in to any issues. One thing that I noticed on my end is that the grid is not being populated when the screen loads using this filter. I have to select refresh on the grid for it to be populated. I’m unsure if this is just an error with ...

Hi ghawton, You can accomplish this using conditional formatting. I recommend that you watch the video at the bottom of the article so that you first understand what conditional formatting is and how to implement it. Once you have done this, you can create your own formatting rules that apply formatting when the condition is true. If the ...