Method Community

Ashur, do we have a timeframe on getting this rolled out? Many thanks.

Is there any written documentation on implementing SQL overrides within grids? I am working with a grid based on the Customer table. I have the Contacts field in the grid. I have the following override script... '<b>' + ISNULL(viewCustomer.Contact,'') + '</b><br />' + '<i>'  + ...

Can I get a list of validation and error checks that are performed at the server when submitting a web form? We are building extra functionality (CAPTCHA etc...) and it could be quite useful. Thanks.

Ashur, would it be possible to send a Word document containing some screenshots? Andy

Sam, thanks for the information. I'll test those options.

Karen, I’m not sure if this can be achieved via a popup, but I have a few dashboards that include reports for cases and activities created by month. I have two date pickers on the screen. One is hidden and is set to the current date/ time. The other is set by the user. Then in step 2 of 4 on the report object wizard I have a ...

Step 4 of 9 on the grid for the estimate line items includes 3 dropdowns in which you can define the sort order for grid items (filter by any field in the table). So you can sort by record ID, then date then amount for instance. Also by clicking on the field heading on the live grid you can sort ascending or descending, again by ...

Ben, having just started implementing web forms myself I have a feeling this isn't possible. Certainly when creating an activity using a web form I experience the same issue. The 'activity.contacts' field is blank for activities created via the form. Somebody has to physically open the new activity and assign a contact to it.

I’ve noticed that when I add comments to an activity and check the HTML of the field a <p> tag is added, however if I copy and paste text there is no tag. If comments are added using a Mac again there are no tags added. This is causing some consistency issues with grid displays. Has anyone come across this before?

I have built some functionality into the work order and invoice screens to allow the work order number to be pulled through when creating an invoice (there is a dropdown field in the invoice table displaying record ID from the activity table). There are then 3-4 linked fields in the invoice via the activity record ID. On the desktop ...