Method Community

Hi Greg, I cleared all filters and only had 'FullName' in the grid and it was still empty in a portal session. However, when I was logged in under a normal account everything was visible. I noticed that the screen's base table was "Items" and the grid was as well, but the grid was "Attached". I deleted the ...

Hi Greg, Thank you for your help. When I add the screen to the portal page (as you did) I am able to see everything in the grid perfectly fine when I am the user logged in. However, the grid is empty if I log in as a contact through the portal. Could you please verify that your grid is visible in a portal session and not just while ...

I have a screenshot but I don't see where to upload it other than a URL... The filters for the Items table are: 1. ItemType is equal to Inventory 2. IsActive equals yes Is it possible to allow portal users to view the inventory table when it is not linked to the contact/customer record ID? This is NOT for a contact to view an ...

We have created a portal for our distributors but I have noticed that grids will not display data from a QuickBooks table unless it is linked to the portal entity logged in. If you create a portal screen and a grid which displays a few fields from the Items table in QuickBooks (for example, an item name and the quantity in stock), items will be ...

Hi, I'm trying to insert records from one table into another and I keep receiving an error that the column 'ServerTimeModified' is invalid. This is not a field name in these tables so it sounds like a bug in the system. Here is the error: FROM actInsertRecordsIntoTable - ...

+1 This is a feature I would really like to see implemented in a future release, along with the ability to create global functions and some way of doing a for/while loop.

So if it is a Method-only table I should use 'view' and if it is a QuickBooks table I should use 'viewacc'. I'll keep that in mind. Thanks for the help!

I was having a problem with the SQL Override in a grid and found the solution, however, I don't understand why it works and hope someone can help clarify the naming convention. I have a grid based on a table called "ProductFamily". I was getting a record count in another table called "Item" with the ...

Over the last couple of days I have been getting an incredible amount of errors in Method, 2 of them are making it hard to use the system: Error1: Anything I do in the screen designer gives an error "Invalid Viewstate" "Referer: https://app.methodintegration.com/stage/Designer/DesignerCallBackFunction.aspx". This makes it ...

Hi, I'm trying to generate a report using an advanced script filter but keep getting an error. I'm using the SalesOrder table and filtering fields Customer_RecordID and ShipDate. Here is what I'm assigning to an action result: Customer_RecordID IN (100,101,102,103) AND ShipDate BETWEEN 'Dec-01-2013' AND ...