Method Community

Hi FW, As I said, the query throws an error if more than one value is returned per field. -Audisho

Not possible, okay, but WHY?

Hi FW, Unfortunately, this isn’t possible using an SQL override, as they only allow 1 value to be returned. Your only alternative would be to build an action set to loop through the table and build a list. Then store the list in a custom field and display it on your grid. Sorry for the inconvenience. -Audisho

Thanks for the tip

Hi Mahlon, Thank you for bringing this to our attention. I was able to replicate this on my test account and have created a ticket to have our development team investigate. I will keep you posted on any updates that I receive via this thread. Sorry for the inconvenience. While we’re on the topic, you may want to consider using an object ...

The Customer table now has a field called Mobile that seems to update with the primary contact. Is this New for M:N? This is great

Hi Steve, Thanks for your feedback. It’s extremely important to us if we are to improve and grow the platform. I’ve done some testing on my end and will address your points as best I can. 1) You are correct that there are a few places within the Donations app where we are referring to Donors or Donor Leads as Customers and Customer ...

We are attempting to build a query for an SQL override grid field that could return more than one result, i.e. query Item FullName to determine associated open sales order line items, returning the sales order refnumber. Problem is, all we can do currently is display the most recent, or MAX sales order refnumber. What I would like to do is to ...

Hi Matt, I wasn’t able to find any further details regarding why this app ribbon item doesn’t work. It was recommended to me that I create a ticket so that is what I have done. Hopefully our development team can correct this or at the very least, provide me with some further detail as to why this doesn’t work. I’ll keep ...

There seems to be an issue with a dropdown field when a public page link is displayed in an iframe. See this link  In this screen shot the iframe is 300px wide When you click a dropdown it cuts off the left side of the text. If we make the iframe 650 px wide and the section in the public page 400 px it's fine. Is ...