Method Community

I'd like to populate a cell in a grid row but the data will come from a different, unrelated table, rolled up (comma separated) over multiple rows. Anyone doing something like this? Is it possible to do this with SQL Override or will I have to get more creative and retrieve the data in a separate action then enter the values in the ...

No worries. The security was isoloated solely to that particular button. The security on the other buttons on the screen worked as I had configured it. The security error message I was getting was incorrectly indicating the user was not in the correct role even though the user was in the proper (Sales) role. Simply creating a new button and ...

Yeah, that's exactly what I wound up doing. Seems weird, but it works

YES! That's it. It's the Trans. history setting. I never thought to look at that. I don't do ANY work with QB. I don't even have it installed on my system. So I forget the data created makes it way HOME to QB eventually, but then only gets synced out to Method based on this setting. I will definitely need to create a QB export ...

BTW, I immediately thought of a workaround. I just loop through the table for the field I'm trying to get the value for and inside the loop assign the value to an action result. Knowing there will be only one record to possibly loop over affectively sets the value if one exists. GOT to be a better way than this...what am I missing?

Is there any way I can check a value for NULL or empty prior to attempting to use it in an action? I've customized my Item table by adding a couple fields. Most Item records will not have a value set for these new custom fields but if an Item does have a value I need to use it in a series of custom Actions. When I use the 'Retrieve Value ...

For some reason a handful of Estimates were purged from the Estimate table for a time period a couple months back. Is there some sort of auto data cleanup task Method has that goes through tables and deletes records that look a certain way? I certainly don't remember removing 40 Estimates on my own. Nor did my salesmen do this. During ...

My theory was confirmed. The security on the original button was corrupted somehow. I created a new button, copied the actions from the original one, set the security the way I wanted it, and the new button security works just fine for everyone. Is this related to the recent screen security UI weirdness? Are there any other reports out there of ...

For some reason the security on a button of mine is not working after working well over the last week or two. Everyone (e.g. All user groups) has access to click this button, but for some reason, the error message being popped up says the user doesn't have access. This is preventing salesmen from creating Sales Orders from Estimates. I ...

I've used Debug Tracing more this week as I've been creating more customized, detailed Actions. While doing so, I noticed the tracing results just ended at a point I was expecting an INSERT action. I spent a lot of time checking the Actions on the screen to make sure things seemed good. Finally, I turned debug tracing OFF, then tried ...