Method Community

I need to make an update to a Method:New screen that is currently working.  I made a copy, and did not make any changes at all and tried to execute it.  I get errors right away.  If I try to edit the screen, I see actions that are blank and objects that have blank entries.  I do not know what was there before.  ...

Thank you so much.  I did not realize you could generate SQL. I know it was staring me in the face but I hadn't tried it... Good tip.   In order to get that screen name, i have been executing an action GeField/ObjectID, and displaying in a field, and then going back to customization and updating my SQL code.  It did ...

I have an action "Start Loop through Table" with two where conditions.  One of the conditions is an "Ends With" condition.  It is failing. When I enable debug tracing I see the generated SQL is putting an extra space before the ending single quote. So the code becomes (ActivityTypeTag LIKE '%Federal ') ...

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 ...

Yes, 8DaysAway is a date field on a screen and the comparison field is a grid field from the Activity table

I found SQL Override examples on the forum which allow me to change color/font of cells of a grid based on a condition.  It works great.  However, in the example below, the condition is against GETUTCDATE().  I would like the condition to be against a date field on the screen called 8DaysAway.  How do I reference screen fields ...

On the Activity screens, there is an option to Send Email.  I would like to make the body section have more lines to work with.  Currently it only shows 6 lines in a scrollable pane. I have Show in HTML Editor checked to Yes. Is there a way to make that editor section larger.  In the Text Box properties, I have number of Input ...

I am customizing a screen and have a grid where I would like to specify "Editing takes place directly in the grid".  However the radio button on the grid wizard (Step 5 of 9 Allow Edit) is not selectable.  It is set to "Do not allow..." and the other radio option is disabled and not ...

Thanks for the note Mortaza. I am parsing a field of data using Seek Next in Selection List.  I don't know how many items are in the list. When I get to the point where the Seek result is blank, I want to stop that section of the screen actions.

I would like to be able to process screen actions in a "Do While" fashion where I don't know how many iterations will be needed.  Because Method does not have DO While or Do Until capability, I've set up a loop through a dummy table with a Counter column and specify "Start loop through table, where Counter is less ...