Method Community

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? 

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.

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

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?

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

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

 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

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