Search results by user ID 6771

A previously working screen, no longer works

kefpa01 — Fri, 17 Nov 2017 03:27:44 GMT

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. I've seen other posts on this forum describing similar situations where a perfectly working screen is now broken.

Since the Live screen IS still working, I do not want to touch it l'est the process of bringing it into an edit session will break the only working version I have. However, I need to know what the fields were previously, that are now blanked out in the "copy" of the screen. Is there a way to get a listing of the live screen so that I can fix the copy and move forward. I want to see the details of every object and every action as it exists on the live version.

As a side note, this is not the first time I've experienced a previously working screen that becomes broken even though no changes have been made. It is extremely frustrating and I am losing confidence in Method. I cannot keep spending hours fixing screens that were working before. I know I'm not alone. How are others handling this? I really like Method, I want to make it work.

Re: SQL Override syntax to use Action Results, Shared Results, Screen fields in the condition

kefpa01 — Thu, 03 Mar 2016 02:07:05 GMT

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 the trick, but I'm glad to know how to do it this way and can avoid the multi step customization here.

Thanks again.

Start Loop through Table Where Field Ends With not working

kefpa01 — Sat, 06 Feb 2016 19:25:52 GMT

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 ')

notice that extra space... I verified I do not have an extra space in my TypeIn field where Federal is specified.

I believe this is likely a bug in the method code and request it be reviewed.

Re: SQL Override syntax to use Action Results, Shared Results, Screen fields in the condition

kefpa01 — Thu, 04 Feb 2016 19:21:32 GMT

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 I reference 8DaysAway in an SQL Override?

Thank you.

Pam

Re: SQL Override syntax to use Action Results, Shared Results, Screen fields in the condition

kefpa01 — Thu, 04 Feb 2016 18:28:15 GMT

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

SQL Override syntax to use Action Results, Shared Results, Screen fields in the condition

kefpa01 — Mon, 01 Feb 2016 15:45:47 GMT

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 or Action Results or Shared Reults in SQL Override statements? Is it possible? If anyone has some syntax examples, I would be very grateful. Or point me to documentation that goes into detail on SQL Override. I'm not seeing much on the Method Customization pages.

(CASE
WHEN [DueDateEnd] < GETUTCDATE() THEN '' + Entity + ''
WHEN [DueDateStart] < GETUTCDATE() THEN '' + Entity + ''
ELSE '' + Entity + '' END)

Thanks for your help,

Pam

Send email body - number of lines

kefpa01 — Thu, 24 Sep 2015 00:04:10 GMT

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 lines set to 30, but no matter what only 6 lines are viewable at a time.

Thanks for your help.

Pamela Keffer

Radio button "Editing takes place directly in the grid" is not selectable

kefpa01 — Mon, 21 Sep 2015 00:10:45 GMT

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

Do not allow editing of rows
Editing takes place directly in the grid

I've done this on many other screens and never had problems setting this option. I am wondering if there are situations where this is not allowed? The table I want to allow editing directly is "Vehicle Mileage" table. Is there a restriction?

Thanks in advance for any help/suggestions.

Regards,
Pam

Re: Do While in Screen Actions

kefpa01 — Wed, 16 Sep 2015 21:12:34 GMT

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.

Do While in Screen Actions

kefpa01 — Wed, 16 Sep 2015 19:53:09 GMT

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 than Type In 99". I would like to be able to stop looping when I reach some condition and not keep looping for 99 iterations. I can't use Stop Processing More Actions, because I DO need to be able to process actions after the End Loop Through Table command.

I would greatly appreciate any suggestions or tips...

Thanks,

Pam