ContributionsMost RecentMost LikesSolutionsRe: Remove HTML from URL fieldI tried everything, except that! This works. Thank you, Chuck. And thanks for the fast reply.Remove HTML from URL fieldHi! I have set up a URL formula that will be embedded in email notifications and sent to clients. I have done some customisation to the button in the notification and written all the HTML there. It looks something like this: <a href="[quickConfirmURL]" style="background-color:#37A637; border:1px solid #2F8C2F; border-radius:2px; color:white; display:inline-block; font-family: Roboto, Open sans, Helvetica, Arial, sans-serif; font-style: normal; font-size:12px; font-weight:normal; height:29px; line-height:29px; min-width:54px; outline:0px; padding:0 8px; text-align:center; text-decoration:none" target="_blank">CONFIRM JOB</a> When I add the field to the email it brings with it the opening "<a href=" and closing "</a>". I have tried text fields and URL fields and it seems that either way if Quickbase detects a url it adds the "<a href=" and "</a>" tags. Is there any way to avoid this? Thanks!Re: Confirmation button in emailThank you! Do you have any advice or best practices for hiding the user token from users? Or do you just fine-tune the permissions so that particular user token can only edit particular fields, and not view tables?Re: Confirmation button in emailWe're still building the website, so for now could you use www.example.com?Re: Confirmation button in emailDo you know any way to redirect the user to another URL after changing the field?Re: How to combine multiple customer records into a single record?This is amazing. Thank you for getting back to me so soon. I'm keen to start setting this up and getting it working as soon as I can.Using the Quickbase PHP SDK for displaying data on the webHi! I am trying to use the QuickBase PHP SDK to lookup data and display it on a website for clients. I'm having some trouble setting it up. It seems that the data is returned is in an XML format, which I am unfamiliar with. I would just like to know how to get that data to a useable format that can be rendered in HTML. Ideally the data in the field will be all that is returned. Any help or a push in the right direction would be amazing.Re: Confirmation button in emailAmazing. Thank you.How to combine multiple customer records into a single record?We collect our customer data from many sources - eg. They sign up for the newsletter, their details are received when a job is booked, or they sign up for a membership. Each source collects different details from the customer and creates a new record in a MEMBERS table. The only common detail that is collected is the email address. At the data collection end we have no way of checking that the record doesn't already exist, so I am looking for a way to combine these records in Quickbase. Ideally there will be an automated solution, but I'm not sure where to start looking. I considered having a MEMBERS DATA table which is essentially every record collected from the different sources, and a clean MEMBERS table which looks up email addresses from the MEMBERS DATA table and creates new records, collecting data from the multiple records in MEMBERS DATA and combining them. There will be no conflicting data so there is no need for a preference in which record a particular field is pulled from. A field in the MEMBERS table can be associated with multiple fields in the MEMBERS DATA table. Any help or a nudge in the right direction would be helpful. Thanks.Confirmation button in emailWe have designed a HTML 'Booking Ticket' email to be sent as an email notification to clients when booking details are received. The email notification is sent to the client directly via Quickbase notify upon saving the form. We would like to include a button in the email which the client presses that 'confirms' the booking. How would we go about building this button that changes the 'job status' field in a job row to 'confirmed'?