How to Dynamically Display Fields Using Salesforce API in Bubble

[jollyinfo92]

Hello, I am developing an application in Bubble using the Salesforce API. Users authenticate with their Salesforce environment via OAuth and can retrieve records through the API. I am currently working on implementing the following functionality:

1. Users select a specific object from a list of Salesforce objects.
   

   

2. Based on the selected object, the list of fields for that object is displayed.
   

   

3. Users select fields.
   

   

4. Data for the records is displayed based on the selected fields.
   

   
   
   
   

I am encountering a particular issue with the last step, dynamically displaying record data based on the selected fields. I am trying to use Bubble’s Repeating Group to display the data, but I can’t figure out how to dynamically specify fields within the Current Cell. Specifically, I have been able to fetch data with an SOQL query like SELECT chosen_fields FROM chosen_object, but I am struggling to find a way to display this data in the Repeating Group.

If anyone has a solution or advice on how to approach this issue, please let me know. Any help would be greatly appreciated.

[Jici]

So the issue is to display fields value, not fields list right?
There’s two option
Can you show the result of the “fields” request and the result for the “values” request?

[jollyinfo92]

Yes, we are able to dynamically retrieve the fields list based on the Salesforce object selected (e.g., Opportunities, Accounts, Products…). However, the issue arises when we need to display field values, as it requires pre-specifying details like XXX’s id or XXX’s name in the editor. Unfortunately, we are unable to change the specified field name according to the selected object.

Regarding your request to see the results of the “fields” and “values” requests, I apologize for the confusion. Could you please clarify which part you would like to see again?