Andrew Peden asked 4 weeks ago
Hi,
I thought this might be simple and straight forward but it seems I'm completely out of my depth.
What I'm trying to achieve with my form is when someone selects a Store Location (Aberdeen in the image attached) the Store Month Key and the Store Partner Email should autofill with entry information from another separate form 'Stores'.
The other form contains Store Name and Partner Email entries that I have imported from a CSV and so far it's pulling in the entry ID for Aberdeen (407 in the store month key) so that's grand.
However, for the convenience of the user I wanted to display the '407 - February 2026' as 'Aberdeen - February 2026'... and then in the Store Partner Email I wanted the 'Partner Email' from the 407 entry to autofill the Store Partner Email field.
I've tried all kinds of shortcode and I have no idea what I'm missing or if it's even possible... I mean it should be as it's clearly reading the correct entry ID when I select different stores.
Any help appreciated.
Thanks,
Andrew
To achieve this without custom code, you'll have to use either cascading dynamic fields or cascading lookup fields. Noting the example of Country/State/City, in both cases, you'll have to have every possible combination stored in the data form(s). If you can't do that, then I suggest custom jQuery code that uses Ajax to retrieve the values from PHP, based on the selected Store Location. If that's beyond your comfort level, I suggest you reach out to a developer here - https://formidable-masterminds.com/developers-directory/
Thank you so much Rob, I ended up using the https://formidableforms.com/knowledgebase/dynamic/#kb-dynamically-display-values-from-selected-entry
It achieved what I needed! Amazing.
Have a lovely day.
Please login or Register to submit your answer
