SIGN UP

Lookup without lookup field

By: Russell Guilfoile | Asked: 01/31/2024
Forums › Category: General questions › Lookup without lookup field
0 Vote Up Vote Down
Russell Guilfoile asked 11 months ago
I understand that the typical way to cascade lookups has to start with a lookup field then can use text fields. (as explained by FF here: https://www.youtube.com/watch?v=fNg--e4zCrg ). However, is there a way to do it that does not start with a lookup field? I have a link that runs a .php to that creates a form entry (in Form01) and populates a field (i.e. Field01) with a value. If that Field01 is a lookup field it doesn't work. If Field01 is a text field it does work, meaning that the field is populated by the value from the .php. The issue is that I need another field (i.e. Field02) to reference the value in Field01 which is associated with a unique entry in another form (i.e. Form02) and populate Field02 with certain value associated with the entry called by Field01. This whole thing is not a problem if Field01 is a lookup. But, since it is not, when I try to use the lookup function in the text field (Field02), it does not list Field01 as a field to watch.   Any ideas?
1 Answers
0 Vote Up Vote Down
Victor Font answered 11 months ago
This is an interesting question and I’d like to dig into it, but I’m watching my grandsons right now. I’ll respond when I can later. 
Victor Font replied 11 months ago

These requirements are really muddy. It's difficult to follow the logic, because you should be able to set the value of a dropdown through whatever you're doing in you PHP snippet. You need to answer the following requirements elicitation questions as completely as possible:

1. How are you creating the form entry?
2. You say you have a link, how is the link getting created? For what purpose? How is the link disseminated and to whom?
3. What does the PHP script do? Please create a pastebin for your code and post the pastebin link back here so we can examine the code.
4. This is the muddiest part of your post. What form is Field02 on?
5. It sounds like that after Field01 is populated, you want to run another process that takes the value of Field01 and look up a matching entry in Form02 and retrieve the value of some field in Form02 and populate Field02 on Form01?

You really need to be specific with what you are trying to do, because right now, I don't know how to answer your question.

I'm referring you to this column I published yesterday. It's all about capturing good requirements. https://formidable-masterminds.com/be-careful-what-you-ask-for/

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