Method:Classic General Q&A

Re: Searchable Item List for Mobile

Method_Michael — Mon, 07 Mar 2011 20:02:16 GMT

pdirect,

I would try something along the lines of:

FieldName1 + Fieldname2 + (CASE WHEN [FieldName3] IS NULL OR [FieldName3] = '' THEN '' ELSE [FieldName3] END)

Where FieldName represents the fields you are trying to use. The Case helps prevent potential issues caused by null or blank values.

You may also have to add all the field used into the Filter fields section.

-Michael

Re: Searchable Item List for Mobile

Method_Michael — Fri, 04 Mar 2011 14:22:26 GMT

pdirect,

I will have to look into this further. The IncomeAccount field is a drop down type field that references FullName in the Account table, I will need to verify if drop down fields are a special case. Do you mind posting the SQL you have at the moment or emailing it to me?

-Michael

Re: Searchable Item List for Mobile

pdirect — Thu, 03 Mar 2011 22:12:11 GMT

Ok, what about IncomeAccount. This won’t display either in a grid. Is there special code for this as well?

Re: Searchable Item List for Mobile

Method_Michael — Thu, 03 Mar 2011 16:03:34 GMT

pdirect,

Since they are numeric values you will need to cast them to varchars an example of casting would be CAST( EmployeeID as varchar(5) ).

-Michael

Re: Searchable Item List for Mobile

pdirect — Wed, 02 Mar 2011 21:22:45 GMT

Yes, that allowed the item list to be added to the dropdown list instead of a tab.

Now I'm trying to get numerical fields to display. I got the following code to work in the grid view custom SQL:

'<b>' + FullName + '</b><br />' + SalesDesc

BUT it won't work when I add QuantityOnHand and/or SalesPrice into the code. I assume this is because they are numerical fields. Is there something special I need to do in the code for numerical fields?

Re: Searchable Item List for Mobile

Method_Michael — Wed, 02 Mar 2011 18:35:41 GMT

pdirect,

When you created the screen did you optimize it for mobile? If not to do this edit the Screen and click Advanced you should see a check box for Optimize for mobile device, make sure that is checked.

-Michael

Re: Searchable Item List for Mobile

pdirect — Wed, 02 Mar 2011 17:16:52 GMT

More specificallym, how do I get my new items list to show up in the mobile dropdown list currently occupied by customers, invoices and estimates? When I add it as a tabbed link, it shows up as a tab instead of in the dropdown menu.

Searchable Item List for Mobile

pdirect — Wed, 02 Mar 2011 16:55:01 GMT

Is it possible to add a searchable item list for the mobile screen? I didn't know if there was good reason to avoid this as it's obviously been avoided by Method.

If this is possible and ok to do, can someone give me a hint as to how to make this happen?