ContributionsMost RecentMost LikesSolutionsRe: Converting a QB entered/formatted Phone number to a 10-digit numberWorked Perfectly - Thanks Mark!Converting a QB entered/formatted Phone number to a 10-digit number I have a Phone Number Field that the user enters a phone number into. QB returns with a formatted number in the following format: (555) 555-1212 I am using this number in an Email field to send an SMS text message using my e-mail program. I need to strip out the spaces, the parenthesis, and the hyphen to get 5555551212 Brain dead tonight; I am sure someone has a quick answer to this one. Thanks for your help. Andy Display URL link to a record I am sending a survey to a group of employees. Each employee is to complete their own specific survey. I'd like to be able to send them the link to their survey using Word Mail Merge to Outlook. Once I create a record, I need to be able to store the URL link to the survey record in a table. I'll grab the link data through an export and manipulate through mail merge. Is there a way I can get this programmatically vs. copying and pasting the link into my field each time. I realize I can't get a link until the record is saved. I am thinking that I could create a field that concatenates the record ID into the URL as the only thing that changes is the record ID from record to record - correct? And if this is the case, is there a way to have this created through a formula that populates when the record is saved? Re: Can I display a date field as YYYY-MM, where MM would be a two-digit rendering for the month?The "trick is to zero pad the month"! I almost gave up in my search for the answer until I stumbled upon this - thanks Mark!Re: This XML file does not appear to have any style information associated with it. The document tree is shown below.Mark - now I want to add a statement to check if the checkbox is false, and if it is, execute the URL fomula above, otherwise, respond with a message that the detail records have already been copied, and return to the form and do nothing. Possible?Re: This XML file does not appear to have any style information associated with it. The document tree is shown below.Perfect .... thanks for your help Mark - much appreciated as usual.Any idea where I can get some more specific directions regarding how to compile URL formulas? The API Documentation is good, but it doesn't do a very good job of explaining the nuances for the newbies like me.This XML file does not appear to have any style information associated with it. The document tree is shown below. Below is my URL formula ... URLRoot()& "db/" &Dbid()& "?a=API_CopyMasterDetail" & "&relfids=38" & "&sourceRID=159" & "&destrid="& [Record ID#]; Records copy, but when I click the button for copying the detail records I receive the XML File with the following data: <qdbapi> <action>API_CopyMasterDetail</action> <errcode>0</errcode> <errtext>No error</errtext> <parentrid>3</parentrid> <numCreated>3</numCreated> </qdbapi> Any help is appreciated!Re: How can I get the text of a number in the way one would speak it? For example $100.00 = One Hundred DollarsAs usual ... you are da man!Re: How would I specify a form rule to make all fields in a record read only on fulfillment of a condition, without specifying each field individually? The record has about a 50 odd fields.What don't I learn to check this before I create a rule and set each field to read only! Argghhh ... so simple! Thanks MarkRe: can i widen the embedded table?Not sure that there is a width setting any longer. The only setting is height. As Mark suggested, removing the height setting allowed the report to default correctly to see all columns. Perfect ... Thanks for your help Mark Shnier.