Method Community

 I was not using the spreadsheet you sent me.  I tried doing so just now and got the same error.

 Hey Dale,   Are you using the new spreadsheet that we sent you? This should have allowed you to use the comma.

It's your built in "user" table so I wasn't able to add "UserType" to it.  :( All the Field Service Engineers are in the "FIELD SERVICE" Role.  Can I sort by that?

Excellent!  So glad to hear this.   I find myself using this trick a lot now myself when designing screens in Method, and it really does make a difference. Glad to be of help. Paul

 Ok.  Figured it out. Problem:  There were comma's contained in one, and in some cases, two fields.  The comma creates a separate record.  This was a problem in both the Name field where I was entering them as "Last, First" and in the Company filed where there some listings such as "ABC Company, ...

I have a "Call Report" Screen and it has a "Field Service Report" Section, I also have a Field Service Report Screen. I create a Call Report and save it.  Then after, if someone goes out to the Field to work on something related to the Call they create  a Field Service Report. Then I have to manually cut and past ...

Paul, this totally works.  thank you so much for posting this.  my screens look soooo much nicer now. thanks, Wavetec

  We were all using IE, but it didn't autozoom at all.  We have since switched to Firefox and it seems to work better but the font is very blocky where as IE is very smooth and looks better but doesn't function right. Also I found out that when we run a report in IE we had to hold down the 'ctrl' key to keep the pop up ...

 Ryan, I realized that after I posted the above, added the name field, and get the same error one number higher (25 fields, 26 records.) ?? Also, I've tried eliminating various combinations of columns to see if one in particular was causing a problem.  I got the import to work with the Name and LeadSource columns ...

Is there a way to have the drop down list sort the list from Z to A, in reverse order?  This particular list is for "Call Reports", we only need to see the last few Reports on the dropdown list.  but it shows reports 1 - 10 up to 50.  I'd rather have reports 99 - 89 down to 50, because the first 50 will be old and ...