SIGN UP

Using FF lookup field to access data in Memberpress tables

By: brett Marsh | Asked: 06/20/2024
Forums › Category: How-to › Using FF lookup field to access data in Memberpress tables
0 Vote Up Vote Down
brett Marsh asked 3 months ago
I have Wordpress website using Memberpress.  I've now also added FF (which I think is awesome). I want to use the lookup fields in formidable forms to be able to access data that is managed within the Memberpress plugin.  For example, when a new member (user) subscribes, they enter their address, which Memberpress records in the Members table.  When I create a FF form, insert a lookup field, I cannot access that member (or the address, date of birth, etc) to use in the form.  I can only 'lookup' tables/forms created within FF. Is there a way the FF lookup field can access the Memberpress tables?  I have no experience with coding, but do have access to a WP developer. Thanks in advance. Brett 
2 Answers
0 Vote Up Vote Down
Rob LeVineRob LeVine answered 3 months ago
You can populate dropdowns with whatever you want using frm_setup_new_fields_vars and frm_setup_edit_fields_vars. They won't, however, be linked (lookup-style) to the tables if that data is outside of Formidable's data. You'll have to make that connection manually. Potentially a better way to handle it is to create an FF form with the member data you want. Then when member data is saved into the MemberPress table, you use a MemberPress developer hook to write the data to the Formidable table. That way you could link the member data form to your new form.
0 Vote Up Vote Down
Victor Font answered 3 months ago
See this: https://formidable-masterminds.com/populate-dropdown-from-sql-query/
brett Marsh replied 3 months ago

Thanks Victor, much appreciated. This will be very useful. My web guy will hopefully be able to incorporate this. Many thanks.

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right