Method Community

[quote user="Blake C"]Make sense?[/quote] It makes sense but I'll have to do some more testing to recreate your scenario described.  In my testing I was using the Insert Records action and I created a blank table with 2 fields, name and date.  I added several records with and without dates then created a button to copy the ...

Thanks Ted, I'll look forward to it. Rolf

Ted, I've switdched to the June version and this is working great now. thanks for the help, Rolf

[quote user="Winston Lo"]can method track the real revenue and cost of a job so that commission can be calculated based on the profit from the job?[/quote] Anything is possible within Method - if the information is available to us from QB then you can build a custom screen to review/modify/update the information and sync it back with ...

[quote user="Winston Lo"]... through Method, would I be able to assign certain currency to a particular customer account?[/quote] You would first assign the currency per customer in QuickBooks then Method will respect that currency when you create invoices for them.  If you want to assign the currency of a customer inside Method ...

I want to enter leads from both Method and Outlook but the Lead Entry screen puts the information in the Contact table while Outlook only allows the entry in the Customer table.  Also, they both need to be linked to the Enity table.  Consequently, I have half of my leads in the Contact table and the other half inthe Customer table.  ...

This is custom table of mine. The date field is not currently required. The screen where we maintain this data has a Date dropdown that allows an empty value to be saved. I've exported this data and it's currently saved as an empty value. However, in my custom action where I retrieve the empty date value from one record, then insert that ...

[quote user="Blake C"]is it possible to use Shared Results in a Filter[/quote] Yes.  If the shared result is available then it will filter based on that criteria, if not then it will not filter.  This allows you to setup some dynamic filtering triggered by user action on a page - a very cool feature. ~C

[quote user="Blake C"]Does this make sense?[/quote] I was just able to recreate this problem and it only happens when you try to insert no date into a table which requires a date.  You cannot write a NULL value into a table when that field is required. ~C

[quote user="Blake C"]Why is this?[/quote] Which table are you copying into?  Depending on the table the date might be a required field so it may not accept a NULL value.   ~C