Mo Adam asked 2 years ago
Hello All,
I hope there is a code snippet to FF team to add it as feature to get data to drop down menu from google sheet. This is will allow massive Integration between application.
Fluent Forms post this code on their website as an advantage they provide with their plugin. I hope someone can support me on this request. I need it this option URGENTLY.
Thanks a lot
Victor Font Staff answered 2 years ago
I've looked at the Fluent Forms Google Sheets add-on and it apparently is a one-way feed from Fluent Forms to the target Google Sheet. It does not allow you to pull data from the sheet to use in your form. In other words, it can only populate your google sheet from form data, not the other way around.
You can accomplish the same exact thing with Formidable using the Zapier add-on.
If you want to use a Google sheet as the source of a drop down, you have to export the Google sheet content as a csv or xml file and import it into a lookup form in Formidable.
Mo Adam
replied 2 years ago Thanks Victor for your reply.
I am already using the code they post to get data from google sheet (Dynamic Source). The import option will not work for my request. As this google sheet is very dynamic. So to populate the dropdown from google sheet is very smart solution provided by Fluent forms Team
Please check below link it has the code
https://fluentforms.com/docs/populate-dropdown-field-options-from-google-sheet/
You can do this exact same thing with Formidable using the https://formidableforms.com/knowledgebase/frm_setup_new_fields_vars/ and https://formidableforms.com/knowledgebase/frm_setup_edit_fields_vars/ hooks.
How you actually process the data depends on your server setup and PHP version.
Mo Adam
replied 2 years ago I can't develop such a code. Its very generic and can support a lot of people.
I hope Formidable team suggest us same example as snippet code that will open a lot of potential. If someone from this community Techy like you Victor could post a code, Like what you post on your website, it will help a lot.
Writing custom code like this is time consuming and beyond the scope of what I can provide as a community volunteer. If I get a paid project in the future that has a requirement to build a dropdown from a Google sheet, I'll be happy to post it. If you need to hire a developer, please visit the Formidable Masterminds Developers Directory at https://formidable-masterminds.com/developers-directory/. Good luck.
Russell Guilfoile
replied 2 years ago Was there ever a solution developed for this? I am also looking for the same. Feel free to contact me at russell.guilfoile@rbundle.com
@Mo Adam: I can't give you a ballpark estimate because I've never had this requirement to code before. Developer price ranges vary due to a number of variables such as skill, knowledge, geographic area, etc. I safe bet is to estimate 10hrs of effort. At today's current market prices in the US, a project like this could cost from $500USD to $2,000USD depending on who does the work.
@Russell Guilfoile: I'm not aware of any solutions that have been posted in the community forum.
Mo Adam answered 2 years ago
Just bring the topic again to attention, If anyone manage to find way to populate the fields from google sheet
You can certainly do this, but you're still looking at a custom code solution. You can use the Googlesheets API to read cell values. https://developers.google.com/sheets/api/guides/values
Please login or Register to submit your answer
