This one is going to be hard! Zapier to Quickbase

Hi Jennifer,

I work for Juiced Technologies, and we have an add-on called Text My QB that allows people to send and receive texts to and from Quickbase. We are able to have the received messages be related to the record that sent the text to them, even if you have multiple records with the same phone number. You can use this link to demo it yourself: DEMO: Text My Quick Base Our add-on also uses CDYNE for hosting the phone numbers which is cheaper than SimpleText. Are you using Zapier for anything else?

James Malone

Junior Quickbase/Software Developer

Juiced Technologies, Inc

Phone: 631-617-5060

Web: https://www.juicedtech.com

3505 Veterans Hwy, Suite O

Ronkonkoma, NY, 11779

------------------------------
James Malone
------------------------------

@Jennifer Meyer

This one is going to be a little messy.

When receiving messages, you can't really deliver the context of what "project" a message is associated with, unless you can somehow convince your customer to write the id with every message

If a phone number is unique to a project, you have a couple options.

Option 1:
Create a table for "phone numbers" and change the primary key to the "phone number" field. Then relate every "message" to it's parent "phone number" record. Then relate "projects" to "phone numbers", where each phone number can have many projects. With that done, you can create a "report link" field in the "Projects" table that shows messages when the field Project: Related Phone Number is equal to the field Message: Related Phone Number. Now, when a message is created all you need to do is write the sender's phone number to the "Related Phone Number" field of the message table, and your messages should show as expected.
Here is a relationship diagram:

Lucid Chart Link

Option 2:
Add a step to your incoming message recipe. This step should search for "projects" where the value in "phone number" is equal to the number of the message sender. For each project found, create a "message" record and write the "Project ID" to the corresponding reference field in each new message record.

I expect that you may run into some issues with formatting, but as long as you standardize input from those creating phone number records or entering phone number values to match the way that Zapier formats the text, it should work out okay. 

------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------

Let's discuss in general terms first. The text obvious does not know the Record ID# of the job.  But I presume it knows the the mobile # which sent the text.  ​Does the job know that?  If so you can populate that into the text record ( maybe you already do that) and then trigger a Pipeline to scan for jobs which have that mobile #, finding the first Job, and write the Record ID to the respect, thus linking it.​

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------