Am I able to take fields from a connected table (like salesforce) and create those fields in quickbase?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

So I am creating a new database in Quickbase to 'mimic' a Salesforce database that we are sun setting.  I am reading up on connected tables.  It seems to me connected tables will read and display the information from Salesforce but it is not editable.

So, Is it possible to use a connected table relationship to create the new database?  Could I connect them and have them populate and create the new fields?

I am trying to figure out the easiest way to create this by using the framework already in Salesforce and creating this in Quickbase.  Any suggestions would be really helpful

Photo of Cecelia

Cecelia

  • 160 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Fascinating question

I looked at he HELP for connected tables and found this:

No, you can’t copy a connected table. However, if you want to make the data in your connected table editable, you can make a copy of your app with data. Doing this creates an editable copy of the table in the copied app.

This copy of the connected table is not connected to the data service and can’t be re-connected.



So it sounds like all you need to do is to make a connected table and then Copy that app!

I found that Help text under FAQs
http://www.quickbase.com/user-assistance/Default.html#faqs_about_connected_tables.html
Photo of Ricardo Tsai

Ricardo Tsai

  • 40 Points
Hi,

Although this question is 5 months old, I'm doing something similar. Bringing Salesforce data into QB has now proven to be a nightmare. 

So, I have X amount of Salesforce fields connected into one of my QB tables. Then, I manually created table fields to copy those connected fields. Once they are local, it is pretty much easy to manipulate the data. 

Now, if you create new fields in Salesforce, you would still need to manually add these new fields into QB as connected fields, create local fields to copy those new connected fields and then work with them.

I haven't found an automated way when you create salesforce new fields, automatically, QB table will know that, add the new connected fields.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Can you explain why you feel that you need to create a mirror duplicate field for every field that you Sync from Sakesforce. Why can't you just use the Sync'd fields directly?
Photo of Ricardo Tsai

Ricardo Tsai

  • 40 Points
In Salesforce its done in X way and in Quickbase its done in Y way. For example. Being Salesforce managed by Sales department and Quickbase PMO and viewed by customer. Customer doesn't need to see Salesforce details so the values brought from Salesforce into Quickbase, there are chunks of naming conventino and standards that should be removed before it reaches the customer. That's just one example why values from one place to another needs to be configured for customer usage.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
But you are free to rename any of the Sync'd fields so I'm not seeing the need to mirror them with duplicate fields.
Photo of Ricardo Tsai

Ricardo Tsai

  • 40 Points
The issue in question is not renaming the field, is to be able to edit the values it holds that was imported from Salesforce. Values in a connected field can't be edited, that's Cecelia original question. If you mirrow the value and have a field that enables/disables connected field to be mirrored, or not, to a local field, then the values of the local field can be edited.