AndrewAndrew2
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
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. AndyDisplay 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: 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?128Views0likes0CommentsRe: 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.99Views0likes0CommentsThis 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 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 Mark55Views0likes0Comments