Method Community

and the date format....

Here are the images to the setup and preview. setup preview

Hi Guy, In order to display one of the fields from the customer equipment table on the work order template, the process is like this: Work orders are based on the Activities table, so you will need to add a dropdown type field to that table, which references the CustomerEquipment table. Chose the Name field to display. Add the dropdown to ...

Hi John, Here's my answer. As the Screen was working fine with oct version and it is showing error in feb version, I would suggest that you regenerate your CASE and ACTIVITY table simply by going to Customize > Tables/Fields > then click on the Cases table first and click Finish Editing Fields. Again same process ...

Hi Robert, Yes, the Build Selection List filter is equivalent to a SQL IN clause, and that's how it's parsed. There are other parts of Method that can be closer to pure SQL, such as filtering tables, grids, and reports. For more information, please see this article: ...

I am having the same issue and have tried everything I could find in the posting and I still cannot get customer equipment to show up in report designer under the fields list. 

Greetings from Las Vegas and BUMP on an old post which does not appear to have been answered. Is there a way to insert a DYNAMIC grid of info into an email template? For example, a list of open invoices on an email to a customer or a list of open bills on an email to a vendor? Thank you!

Are you guys planning on releasing a 64-bit version of the sync engine any time soon? I feel like the sync is not happening fast enough when performing large updates in the 10's or 100's of thousands record-wise. Yes, I am a speed freak. Thoughts? EDIT: Maybe a stupid question, but are do you guys have a version of the sync engine that ...

I will try this.  Is this a SQL IN () clause?  Are you parsing the commas into ',' and adding ( and ) on the ends?  That must be what you are doing because in another filter I have the following working fine: RecordID > 0  AND Class IN ('<City>','_National').   "Build Selection ...

Hi homeproav, There are many ways to accomplish this, and this falls outside of the scope of support, but I'll point you in the right direction. If you are having issues with this, we won’t be able to help as we can only troubleshoot if there are errors with the code generated. The simplest way would be to use CSS, so that you can ...