Method Community

I would recommend having a look at some database normalization articles to better understand good database design. ~C

Mark- This is a current limitation of the SDK. You can read more about this here. -Michael

[quote user="Wavetec"]I have created a large number of fields to document contact information for each Customer.  Some of my customer sites have 15 contacts.  So I have created ContactName1; ContactCell1; Contactemail1; ContactName2; ContactCell2; etc.[/quote] Please see my solution about adding more than one email to a ...

@smoyee  If you are using the Outlook plugin with Method then you can set up the Email Open Notification (Request a Read Receipt) when sending an email from Outlook. If you are send an email straight from Method then we do not have this function.  Please let me know if I can be of further assistance

[quote user="Wavetec"]Now we would like to have multiple Field Service Visits per Call. i.e. Customer A has Issue 1 and we went to the site 3 times to fix it. Right now we have 3 Calls and 3 FSRs to document this.  I'd like to have 1 Call with a referrence to all 3 FS visits.[/quote] In this scenario I could see one table being ...

@Wavetec Just another note to help with the case. After retrieving the value of the previous Call Report, you will need to perform a Basic Math action to increment the Call Report number by 1 I hope this helps  

@Wavetec You can take a look at the Character Function action. Use this action to  -      Retrieve value from table to get the number for the last record.  -      Use the character function perhaps more than once to do the rest.  Please let me know if I can be of further assistance.

I have created a large number of fields to document contact information for each Customer.  Some of my customer sites have 15 contacts.  So I have created ContactName1; ContactCell1; Contactemail1; ContactName2; ContactCell2; etc. I need to be able to search for names in these fields.  If someone needs a phone number for "Mr. ...

 Dave, This issue should now be fixed. Please try now Dave

Currently we have a Call Report Screen and in the screen is a Call Report #.  The format of the number is CR 12 - xxxx, where the first digit is the year and the remaining 4 digits are entered manully. i.e. CR 12 - 0001 Is there something I can put into the logic so when I SAVE a NEW Call Report is automatically looks to see what the last ...