ContributionsMost RecentMost LikesSolutionsImporting data into a Multi-select Text Field This is more of an Excel rather than Quickbase question. I want to update a Multi-select Text Field for hundreds of Quickbase records from 8 .csv files The .csv files contain just two columns, Customer ID (key field) and Group, like the examples below. flooring.csv Cust ID Group A123 Flooring B123 Flooring C123 Flooring roofing.csv Cust ID Group A123 Roofing B123 Roofing C123 Roofing carpeting.csv Cust ID Group A123 Carpeting B123 Carpeting C123 Carpeting Is there a way for Excel (or an Excel add-on) to Merge data from two or more .csv files so that I end up with the example below that I can then import into the Multi-select Text field in Quickbase? Cust ID Group A123 Flooring; Roofing; Carpeting B123 Flooring; Roofing; Carpeting C123 Flooring; Roofing; Carpeting Thanks, Jim Re: Getting Customer signatures with Covid-19 Thank you for the quick responses. I didn't think about the Pipelines connection for DocuSign. I'll look into that option as well as add-on software. ------------------------------ Jim ------------------------------ Getting Customer signatures with Covid-19 We use Quick Base to assign Field Techs to service customer equipment in southern California and the Techs get the customers signature on a Work Order form on a smart phone or tablet using Signatures for Quick Base. We're starting starting to have issues with employees and customers not wanting to handle other people's phones or tablet for signatures. Any suggestions on how to collect customer signatures without handling other people's phones or tablet for signatures? Would DocuSign for Quick Base be a possible solution? Thanks, ------------------------------ Jim Lieder ------------------------------ Is there a way to print a form & update a checkbox field to show the form has printed?Is there a way to construct a button that will print a form, and then update a checkbox field in the record to show that the record has been printed? This is the formula I'm using, and it prints the form (URLONE, but doesn't do the 2nd & third steps. var text URLONE = URLRoot() & "db/" & [_DBID_REPAIR_TASKS] & "?a=printr" & "&dfid=10" & "&rid=" &[Record ID#]; var text URLTWO = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&_fid_92=true" & "&apptoken=abc" & "&rid=" &[Record ID#]; var text URLTHREE = URLRoot() & "db/" & Dbid() & "?a=q&qid=1"; $URLONE & URLEncode($URLTWO) & URLEncode("&rdr=" & URLEncode($URLTHREE)) ------------------------------ Jim ------------------------------ Re: How can I insert a new step in an existing Pipeline?Mark, Thanks for your reply. I couldn't get this to work, but I might not be dragging the new step into just the right spot. I'll keep at it. Jim ------------------------------ Jim ------------------------------ How can I insert a new step in an existing Pipeline?I have an existing Pipeline with 5 steps and I need to insert a new step 1. Is it possible to insert a step at the beginning? If that's not possible, I'll create a new Pipeline with the new step ,and have that call my existing Pipeline. But the instructions on how to call another Pipeline aren't very clear (see the attached screen shot). Does anyone know how the enter the Call Definition for called Pipelines? ------------------------------ Jim ------------------------------ Re: Table relationships using phone numberThe list of Phone numbers and Customer ID' has lots of duplicates, so using this as a key field won't work. The Cytracom call records are imported into QB on a weekly basis. Arg! I'm going to put this at the bottom of the work pile for now. Thanks for your quick replies Mark. I'm still amazed how quickly you respond over so many years! You have hundreds of appreciative QB developers and end-users. ------------------------------ Jim ------------------------------ Webhooks message body formatI'm trying to make Webhooks call into another system and have a question on how to construct the message body section. I'm using a JSON message format. The message body needs three parameters. I've tried entering the parameters like this: parm1=xxxx&parm2=xxxxxxxx&parm3=xxxxxx but the error is{"ERROR":"IMPROPER DATA"} Also tried this: parm1=xxxx parm2=xxxxxxxx parm3=xxxxxx also error'ed with{"ERROR":"IMPROPER DATA"} ------------------------------ Jim ------------------------------ Button to perform a Google Search of a Phone NumberHas anyone created a button to do a Google search of a phone number from QuickBase? Is it as simple as constructing a URL that looks like this? "https://www.google.com/search?q="&[phone] ------------------------------ Jim ------------------------------ Re: Epoch & Unix Timestamp ConversionSending new Contacts entered in HubSpot to QuickBase using Zapier. Want to display the date & time the contact was created in HubSpot. The Contact transaction date & time is inUnix timestamp like '1555079067'