-
MoAsked on February 27, 2019 at 7:42 AM
-
Victoria_KReplied on February 27, 2019 at 7:48 AM
Could you let us know which fields are not shown in a dropdown and also name the form you with SalesForce integration? Please check if the fields are not hidden somehow, on this step:
-
five_bettyReplied on February 27, 2019 at 9:00 AM
Hi Victoria_K
I need to populate these fields from Salesforce to jotform. These all field already have FLS permission.
Company
First Name
Last Name
Email
Phone
Subject_L__c
Project_Parameters_L__c
ITAR_Required_L__c
Parts_Quantity_L__c
Finish_Texture_Requirements_L__c
Requested_Color_L__c
Shipping_Preference_L__c
Ship_Street_Address__c
Ship_City__c
Ship_State_Province__c
Ship_Postal_Zip_Code__c
Ship_Country__c
Billing_Street_L__c
Billing_City_L__c
Billing_State_L__c
Billing_Zip_L__c
Billing_Country_L__c
What_brought_you_to_GoProto__c
Stay_in_Touch__c
Enter_the_message_as_it_s_shown__c
Is_FastQuote__c
Thanks
Mo
-
Victoria_KReplied on February 27, 2019 at 10:31 AM
Hello Mo, What about next step, 'Add to page layouts', which goes right after FLS? I've made some research and appears that this can be the reason too.
-
five_bettyReplied on February 27, 2019 at 10:45 AM
Hi Victoria_K,
Thanks for prompt reply and all assistance, I have tried by adding on layout also it does not work, the layout does it matter? I can see all the fields in the JSON but not showing in the dropdown.
{"message":"{\"customFields\":[{\"ID\":\"Linkedin_Profile__c\",\"Name\":\"Linkedin Profile\",\"type\":\"url\",\"required\":false},{\"ID\":\"Title_Category__c\",\"Name\":\"Title Category\",\"type\":\"picklist\",\"required\":false},{\"ID\":\"School__c\",\"Name\":\"School\",\"type\":\"string\",\"required\":false},{\"ID\":\"Career_Duration__c\",\"Name\":\"Career Duration\",\"type\":\"string\",\"required\":false},{\"ID\":\"Duration_in_current_position__c\",\"Name\":\"Duration in current position\",\"type\":\"string\",\"required\":false},{\"ID\":\"Personal_Item__c\",\"Name\":\"Personal Item\",\"type\":\"string\",\"required\":false},{\"ID\":\"Industry_sub_category__c\",\"Name\":\"Industry sub category\",\"type\":\"string\",\"required\":false},{\"ID\":\"CAD_Software__c\",\"Name\":\"CAD Software\",\"type\":\"multipicklist\",\"required\":false},{\"ID\":\"Linked_In_Long__c\",\"Name\":\"Linked In Long\",\"type\":\"textarea\",\"required\":false},{\"ID\":\"Touch_Status__c\",\"Name\":\"Touch Status\",\"type\":\"multipicklist\",\"required\":false},{\"ID\":\"Corp_Phone__c\",\"Name\":\"Corp Phone\",\"type\":\"phone\",\"required\":false},{\"ID\":\"Notes__c\",\"Name\":\"Notes\",\"type\":\"textarea\",\"required\":false},{\"ID\":\"Call_Back_Date__c\",\"Name\":\"Call Back Date\",\"type\":\"date\",\"required\":false},{\"ID\":\"Extension__c\",\"Name\":\"Extension\",\"type\":\"string\",\"required\":false},{\"ID\":\"CTCT21__Opted_Out_by_CTCT__c\",\"Name\":\"Opted Out by Constant Contact\",\"type\":\"boolean\",\"required\":false},{\"ID\":\"Region_discontinue__c\",\"Name\":\"Region\",\"type\":\"picklist\",\"required\":false},{\"ID\":\"pi__Needs_Score_Synced__c\",\"Name\":\"Needs Score Synced\",\"type\":\"boolean\",\"required\":false},{\"ID\":\"pi__Pardot_Last_Scored_At__c\",\"Name\":\"Pardot Last Scored At\",\"type\":\"datetime\",\"required\":false},{\"ID\":\"pi__campaign__c\",\"Name\":\"Pardot Campaign\",\"type\":\"string\",\"required\":false},{\"ID\":\"pi__comments__c\",\"Name\":\"Pardot Comments\",\"type\":\"textarea\",\"required\":false},{\"ID\":\"pi__conversion_date__c\",\"Name\":\"Pardot Conversion Date\",\"type\":\"datetime\",\"required\":false},{\"ID\":\"pi__conversion_object_name__c\",\"Name\":\"Pardot Conversion Object Name\",\"type\":\"string\",\"required\":false},{\"ID\":\"pi__conversion_object_type__c\",\"Name\":\"Pardot Conversion Object Type\",\"type\":\"string\",\"required\":false},{\"ID\":\"pi__created_date__c\",\"Name\":\"Pardot Created Date\",\"type\":\"datetime\",\"required\":false},{\"ID\":\"pi__first_activity__c\",\"Name\":\"Pardot First Activity\",\"type\":\"datetime\",\"required\":false},{\"ID\":\"pi__first_search_term__c\",\"Name\":\"Pardot First Referrer Query\",\"type\":\"string\",\"required\":false},{\"ID\":\"pi__first_search_type__c\",\"Name\":\"Pardot First Referrer Type\",\"type\":\"string\",\"required\":false},{\"ID\":\"pi__first_touch_url__c\",\"Name\":\"Pardot First Referrer\",\"type\":\"textarea\",\"required\":false},{\"ID\":\"pi__grade__c\",\"Name\":\"Pardot Grade\",\"type\":\"string\",\"required\":false},{\"ID\":\"pi__last_activity__c\",\"Name\":\"Pardot Last Activity\",\"type\":\"datetime\",\"required\":false},{\"ID\":\"pi__notes__c\",\"Name\":\"Pardot Notes\",\"type\":\"textarea\",\"required\":false},{\"ID\":\"pi__pardot_hard_bounced__c\",\"Name\":\"Pardot Hard Bounced\",\"type\":\"boolean\",\"required\":false},{\"ID\":\"pi__score__c\",\"Name\":\"Pardot Score\",\"type\":\"double\",\"required\":false},{\"ID\":\"pi__url__c\",\"Name\":\"Pardot URL\",\"type\":\"url\",\"required\":false},{\"ID\":\"pi__utm_campaign__c\",\"Name\":\"Google Analytics Campaign\",\"type\":\"string\",\"required\":false},{\"ID\":\"pi__utm_content__c\",\"Name\":\"Google Analytics Content\",\"type\":\"string\",\"required\":false},{\"ID\":\"pi__utm_medium__c\",\"Name\":\"Google Analytics Medium\",\"type\":\"string\",\"required\":false},{\"ID\":\"pi__utm_source__c\",\"Name\":\"Google Analytics Source\",\"type\":\"string\",\"required\":false},{\"ID\":\"pi__utm_term__c\",\"Name\":\"Google Analytics Term\",\"type\":\"string\",\"required\":false},{\"ID\":\"ebsta1__Ebsta_Score_Trend_Last_30_Days__c\",\"Name\":\"Ebsta Score Trend Last 30 Days\",\"type\":\"double\",\"required\":false},{\"ID\":\"ebsta1__Ebsta_Score_Trend_Last_7_Days__c\",\"Name\":\"Ebsta Score Trend Last 7 Days\",\"type\":\"double\",\"required\":false},{\"ID\":\"ebsta1__Ebsta_Score_Trend_Last_90_Days__c\",\"Name\":\"Ebsta Score Trend Last 90 Days\",\"type\":\"double\",\"required\":false},{\"ID\":\"ebsta1__Ebsta_Score__c\",\"Name\":\"Ebsta Score\",\"type\":\"double\",\"required\":false},{\"ID\":\"ebsta1__Last_Ebsta_Stats_Update__c\",\"Name\":\"Last Ebsta Stats Update\",\"type\":\"datetime\",\"required\":false},{\"ID\":\"ebsta1__Last_Email_Activity_Date__c\",\"Name\":\"Last Email Activity Date\",\"type\":\"datetime\",\"required\":false},{\"ID\":\"ebsta1__Last_month_emails_exchanged_inbound__c\",\"Name\":\"Last month emails exchanged inbound\",\"type\":\"double\",\"required\":false},{\"ID\":\"ebsta1__Last_month_emails_exchanged_outbound__c\",\"Name\":\"Last month emails exchanged outbound\",\"type\":\"double\",\"required\":false},{\"ID\":\"ebsta1__Last_week_emails_exchanged_inbound__c\",\"Name\":\"Last week emails exchanged inbound\",\"type\":\"double\",\"required\":false},{\"ID\":\"ebsta1__Last_week_emails_exchanged_outbound__c\",\"Name\":\"Last week emails exchanged outbound\",\"type\":\"double\",\"required\":false},{\"ID\":\"ebsta1__Out_of_office_until__c\",\"Name\":\"Out of office until\",\"type\":\"date\",\"required\":false},{\"ID\":\"ebsta1__Total_emails_exchanged_inbound__c\",\"Name\":\"Total emails exchanged inbound\",\"type\":\"double\",\"required\":false},{\"ID\":\"ebsta1__Total_emails_exchanged_outbound__c\",\"Name\":\"Total emails exchanged outbound\",\"type\":\"double\",\"required\":false},{\"ID\":\"LID__LinkedIn_Company_Id__c\",\"Name\":\"LinkedIn Company Id\",\"type\":\"string\",\"required\":false},{\"ID\":\"LID__LinkedIn_Member_Token__c\",\"Name\":\"LinkedIn Member Token\",\"type\":\"string\",\"required\":false},{\"ID\":\"Hide_From_Pardot__c\",\"Name\":\"Hide From Pardot\",\"type\":\"boolean\",\"required\":false},{\"ID\":\"Force_Sync_with_Pardot__c\",\"Name\":\"Force Sync with Pardot\",\"type\":\"double\",\"required\":false},{\"ID\":\"Subject_L__c\",\"Name\":\"Subject\",\"type\":\"string\",\"required\":false},{\"ID\":\"Project_Parameters_L__c\",\"Name\":\"Project Parameters\",\"type\":\"textarea\",\"required\":false},{\"ID\":\"ITAR_Required_L__c\",\"Name\":\"ITAR Required\",\"type\":\"picklist\",\"required\":false},{\"ID\":\"SrNo__c\",\"Name\":\"SrNo\",\"type\":\"double\",\"required\":false},{\"ID\":\"StartUrl__c\",\"Name\":\"StartUrl\",\"type\":\"url\",\"required\":false},{\"ID\":\"Parts_Quantity_L__c\",\"Name\":\"Parts Quantity\",\"type\":\"double\",\"required\":false},{\"ID\":\"Finish_Texture_Requirements_L__c\",\"Name\":\"Finish \\\/ Texture Requirements\",\"type\":\"string\",\"required\":false},{\"ID\":\"Requested_Color_L__c\",\"Name\":\"Requested Color\",\"type\":\"string\",\"required\":false},{\"ID\":\"Shipping_Preference_L__c\",\"Name\":\"Shipping Preference\",\"type\":\"string\",\"required\":false},{\"ID\":\"PersonProfileLink__c\",\"Name\":\"PersonProfileLink\",\"type\":\"textarea\",\"required\":false},{\"ID\":\"Billing_Street_L__c\",\"Name\":\"Billing Street\",\"type\":\"string\",\"required\":false},{\"ID\":\"Billing_City_L__c\",\"Name\":\"Billing City\",\"type\":\"string\",\"required\":false},{\"ID\":\"Billing_State_L__c\",\"Name\":\"Billing State\",\"type\":\"string\",\"required\":false},{\"ID\":\"Billing_Zip_L__c\",\"Name\":\"Billing Zip\",\"type\":\"string\",\"required\":false},{\"ID\":\"Billing_Country_L__c\",\"Name\":\"Billing Country\",\"type\":\"string\",\"required\":false},{\"ID\":\"Manufacturing_Process_L__c\",\"Name\":\"Manufacturing Process\",\"type\":\"multipicklist\",\"required\":false},{\"ID\":\"Materials_L__c\",\"Name\":\"Materials\",\"type\":\"multipicklist\",\"required\":false},{\"ID\":\"Username_L__c\",\"Name\":\"Username\",\"type\":\"string\",\"required\":false},{\"ID\":\"Password_L__c\",\"Name\":\"Password\",\"type\":\"string\",\"required\":false},{\"ID\":\"Confirm_Password_L__c\",\"Name\":\"Confirm Password\",\"type\":\"string\",\"required\":false},{\"ID\":\"What_brought_you_to_GoProto_L__c\",\"Name\":\"What brought you to GoProto\",\"type\":\"multipicklist\",\"required\":false},{\"ID\":\"Tenure__c\",\"Name\":\"Tenure\",\"type\":\"string\",\"required\":false},{\"ID\":\"LinkedIn_Company_Profile__c\",\"Name\":\"LinkedIn Company Profile\",\"type\":\"url\",\"required\":false},{\"ID\":\"Location_Filter__c\",\"Name\":\"Location Filter\",\"type\":\"string\",\"required\":false},{\"ID\":\"Industry_Filter__c\",\"Name\":\"Industry Filter\",\"type\":\"string\",\"required\":false},{\"ID\":\"Company_Size_Filter__c\",\"Name\":\"Company Size Filter\",\"type\":\"string\",\"required\":false},{\"ID\":\"Job_Function_Filter__c\",\"Name\":\"Job Function Filter\",\"type\":\"string\",\"required\":false},{\"ID\":\"Seniority_Filter__c\",\"Name\":\"Seniority Filter\",\"type\":\"string\",\"required\":false},{\"ID\":\"Keywords_Filter__c\",\"Name\":\"Keywords Filter\",\"type\":\"string\",\"required\":false},{\"ID\":\"Testfield__c\",\"Name\":\"Testfield\",\"type\":\"string\",\"required\":false},{\"ID\":\"Override_Ownership__c\",\"Name\":\"Override Ownership\",\"type\":\"boolean\",\"required\":false},{\"ID\":\"CompanyLinkedInID__c\",\"Name\":\"CompanyLinkedInID\",\"type\":\"double\",\"required\":false},{\"ID\":\"LinkedIn_Geography__c\",\"Name\":\"LinkedIn Geography\",\"type\":\"picklist\",\"required\":false},{\"ID\":\"LinkedIn_Company_Specialties__c\",\"Name\":\"LinkedIn Company Specialties\",\"type\":\"textarea\",\"required\":false},{\"ID\":\"LinkedIn_Company_Type__c\",\"Name\":\"LinkedIn Company Type\",\"type\":\"string\",\"required\":false},{\"ID\":\"Company_Year_Founded__c\",\"Name\":\"Company Year Founded\",\"type\":\"string\",\"required\":false},{\"ID\":\"Company_HQ_Address__c\",\"Name\":\"Company HQ Address\",\"type\":\"string\",\"required\":false},{\"ID\":\"Success__c\",\"Name\":\"Success\",\"type\":\"boolean\",\"required\":false},{\"ID\":\"Lead_Source_Detail__c\",\"Name\":\"Lead Source Detail\",\"type\":\"string\",\"required\":false},{\"ID\":\"Territory__c\",\"Name\":\"Territory\",\"type\":\"picklist\",\"required\":false},{\"ID\":\"Batch__c\",\"Name\":\"Batch\",\"type\":\"string\",\"required\":false},{\"ID\":\"Quote_Email_Opt_In__c\",\"Name\":\"Quote Email Opt In\",\"type\":\"boolean\",\"required\":false},{\"ID\":\"Company_Name_Clean__c\",\"Name\":\"Company Name (Clean)\",\"type\":\"string\",\"required\":false},{\"ID\":\"No_Account_Found__c\",\"Name\":\"No Account Found\",\"type\":\"boolean\",\"required\":false},{\"ID\":\"Bria__Bria_leads_first_contact__c\",\"Name\":\"Bria leads first contact\",\"type\":\"datetime\",\"required\":false},{\"ID\":\"Bria__Bria_leads_last_contact__c\",\"Name\":\"Bria leads last contact\",\"type\":\"datetime\",\"required\":false},{\"ID\":\"Bria__Bria_leads_total_inbound_calls__c\",\"Name\":\"Bria leads total inbound calls\",\"type\":\"double\",\"required\":false},{\"ID\":\"Bria__Bria_leads_total_outbound_calls__c\",\"Name\":\"Bria leads total outbound calls\",\"type\":\"double\",\"required\":false},{\"ID\":\"Bria__Bria_leads_total_talk_time__c\",\"Name\":\"Bria leads total talk time\",\"type\":\"double\",\"required\":false},{\"ID\":\"Bria__UniqueCallId__c\",\"Name\":\"Unique Call Id\",\"type\":\"string\",\"required\":false},{\"ID\":\"AU_NZ_Flags__c\",\"Name\":\"AU\\\/NZ Flags\",\"type\":\"string\",\"required\":false},{\"ID\":\"Convert_Account_Destination_ID__c\",\"Name\":\"Convert Account Destination ID\",\"type\":\"string\",\"required\":false},{\"ID\":\"GoQuote_Id__c\",\"Name\":\"GoQuote Id\",\"type\":\"string\",\"required\":false},{\"ID\":\"Ship_Street_Address__c\",\"Name\":\"Ship Street Address\",\"type\":\"string\",\"required\":false},{\"ID\":\"Ship_City__c\",\"Name\":\"Ship City\",\"type\":\"string\",\"required\":false},{\"ID\":\"Ship_State_Province__c\",\"Name\":\"Ship State \\\/ Province\",\"type\":\"string\",\"required\":false},{\"ID\":\"Ship_Postal_Zip_Code__c\",\"Name\":\"Ship Postal \\\/ Zip Code\",\"type\":\"string\",\"required\":false},{\"ID\":\"Ship_Country__c\",\"Name\":\"Ship Country\",\"type\":\"string\",\"required\":false},{\"ID\":\"What_brought_you_to_GoProto__c\",\"Name\":\"What brought you to GoProto?\",\"type\":\"picklist\",\"required\":false},{\"ID\":\"Stay_in_Touch__c\",\"Name\":\"Stay in Touch\",\"type\":\"boolean\",\"required\":false},{\"ID\":\"Enter_the_message_as_it_s_shown__c\",\"Name\":\"Enter the message as it's shown\",\"type\":\"string\",\"required\":false},{\"ID\":\"Is_FastQuote__c\",\"Name\":\"Is FastQuote?\",\"type\":\"boolean\",\"required\":false}],\"recordTypes\":[]}","success":true,"duration":"0.681"}
-
Victoria_KReplied on February 27, 2019 at 12:20 PM
Would you mind integrating a JotForm to your Salesforce account and let us know which form it is?
Also, could you provide a screenshot of fields/types in SalesForce?
-
Victoria_KReplied on February 27, 2019 at 12:21 PM
Also, please try resetting security token at SalesForce, it may help to refresh fields list.
-
five_bettyReplied on February 27, 2019 at 12:51 PM
Hi Victoria_K,
I tried reset token but no luck :-(
I am doing integration with "Clone of Quote Request Form" Form.
I can not do with Account, it needs to be on Lead, below is the screenshot of the showing some of the fields:
-
David JotForm Support ManagerReplied on February 27, 2019 at 1:57 PM
I checked that form, and it appears not to be integrated with Salesforce:
Could you please integrate again, and leave it like that, so we can see which fields do not show in the fields mapping options?
-
five_bettyReplied on February 27, 2019 at 3:21 PM
HI BDAVID,
Its done, I had removed to give retry by resetting token connection etc. but now you can see integration.
Thanks,
Mo
-
David JotForm Support ManagerReplied on February 27, 2019 at 4:42 PM
I have checked your integration, and those Salesforce fields:
Are appearing in the JotForm side too:
So, they can be mapped with your jotform fields. Let us know if you need more help.
-
MoReplied on February 28, 2019 at 8:48 AM
Hi BDAVID,
I am not able to see these field in jot form side. I need to map Salesforce ship street to jot form ship street and so on.
Ship_Street_Address__c
Ship_City__c
Ship_State_Province__c
Ship_Postal_Zip_Code__c
Ship_Country__c
Thanks
Mo
-
David JotForm Support ManagerReplied on February 28, 2019 at 10:18 AM
It seems like you have removed the Salesforce integration again. Are those fields having "Visible" permission? I would suggest you to check with Salesforce support to make sure that they are accessible.
-
five_bettyReplied on February 28, 2019 at 10:31 AM
Yes because it was not working at all, I checked all is set in Salesforce, my concerns is related with JotForm Fields it is not showing street, city, state, and country showing Ship to Address instead which is not making sense.
If it is not possible by Salesforce app is there any way to do it my Webhook, if yes the should be the structure of the Webhook?
Please advise!
Thanks,Mo
-
David JotForm Support ManagerReplied on February 28, 2019 at 11:58 AM
The Street, City, State, Postal Code, and Country fields from your Ship to Address field:
Will not be shown separately in the Dropdown option since the "Ship to Address" field is read as one field in the Salesforce integration:
So, if you want to match them individually with your Ship_Street_Address__c, Ship_City__c, Ship_State_Province__c, Ship_Postal_Zip_Code__c, and Ship_Country__c fields, you need to set up your "Ship to Address" field in individual Short Text Entry fields:
So, they will be shown individually in the SalesForce integration:
Hope this helps.
-
five_bettyReplied on February 28, 2019 at 12:04 PM
HI BDAVID,
Thanks for the details it is really helpful but unfortunately, I can not change page structure, Is there any other way I can get data in my public URL like webhook? when it user click on submit/save?
Please advise!
Thanks,
MO
-
five_bettyReplied on February 28, 2019 at 12:05 PM
I tried https://www.jotform.com/help/245-How-to-Setup-a-Webhook-with-JotForm
but it not really helpful, am I missing something?
-
David JotForm Support ManagerReplied on February 28, 2019 at 1:19 PM
That Webhooks guide helps developers that are experienced with the Webhook technique to find out/debug the webhook request(form parameters) that will be used in their own development.
However, any further development goes beyond our support scope. So, you might hire a developer to help you develop a connection to Salesforce via Webhook.
Open a new forum thread if you have a new question, we will be glad to assist you.