Method Community

Hey Ben, Welcome to the Forums! There are a few ways to retrieve that data into a Grid, here is one way: SELECT Count(viewaccInvoice.RecordID) FROM viewaccInvoice WHERE viewaccInvoice.Customer = viewContacts.Entity Using SQL Count function we retrieve the total number of unique Invoice RecordIDs related to Customer. -- Mortaza

Hi Mike, We just spoke on the phone regarding this. The values in the LeadStatus table are not editable, as the values are automatically inserted when converting a lead to a customer. You can read more about this in the forum threads HERE and HERE. Your alternative would be to create your own custom dropdown field and table for storing custom ...

Is anyone looking into this? Been a few days since my forum post. 

I have a screen with a grid on it that contains the values for a "Lead Status" dropdown box field that is in the Customer/Lead table. Values are in the Lead Status table and there are only 2 columns in the table: RecordID and LeadStatus.  I need to add further items to the list but it is impossible to do so. I can export the Lead ...

Hey Karrena, That is very odd, another route to customize the page is to head over to: Customize > Screens The screen we are going to customize is CRM_CustomerList. Highlight the screen name, make a copy and when you highlight the copied screen you will now have an option to Edit. -- Mortaza

Hi Mortaza, Can you give any guidance on how to do this? I've looked at the button actions on both the screens and can't see anything that would help. In the email, I see a url for the http://urlforportal but nothing that I could modify to load the actual estimate. Thanks, Greg

I have looked at this a bit but I am confused. In your first suggestion, I was adding a Dropdown for the RecordID, and adding the version number as a linked field. In your latest suggestion, it looks like the version number is now being done via a Dropdown instead of a linked field. The version numbers in my Registrations section are entered in a ...

Greetings. I was looking at your post and i thought yea i have done this before.  In my business landscaping i was having a issue trying to group plants, sprnkler parts, sprinkler repair parts, pesticides, fertlizers, lighting, rock, mulch, etc. For you, you have products like tick, wormer, eye, food, health related, play related, last ...

Greetings. Long time user here as well. Put alot of time in both mobile and desktop screens.  I do know mobile screens in classic can be a pain to program but after learning it i got it to do some pretty great stuff.  I try to keep it as simple as possible.  Things like work orders, time checking and in my case made a special ...

Hi Mortaza, Fran's comments got me wondering last night, and maybe I am overthinking this. Looking at the Listbuilder screen, it will do half of what I am trying to achieve. So with a few small adjustments, maybe this would give me a solution. On Step one, I only need the lower half of the screen ( fill from invoices ), and I don't need ...