Hi! I have 2 forms:
Inside Form B (Student profile) I'm using the following shortcode inside a field to count the amount of entries in Form A: [frm-stats id=x type=count]
It works well.
However, I need to only count entries that contain a value from Form B inside Form A. Example: Only if field "Student ID" in Form A contains the same "Student ID" in Form B.
I see there are dynamic filters to do this using URL parameters. However, for a technical reason, this is not a viable solution.
Is there any other way to use dynamic values from Form B for this filter?
Thanks for your help and time!
What I am missing is why are you counting the recommendations first instead of loading the student ID and working in the other direction which is much easier?
Why do you think dynamic fields could help solve the problem? Dynamic fields are highly flexible look ups where their flexibility shines when displaying data in a view. Dynamic fields store the entry id of the lookup record in the form's data where the field is used.
I guess I'm just not understanding your business process.
Based on what I understand now, I think you may have to re-engineer your design or have someone take an eyes-on look to help structure the data flow more efficiently.
Hi @Victor Font ,Thanks for your help and sorry for not being clear. Let me give you details about my case:* Form A: Here we receive the recommendations of the students being submitted by teachers and parents. This is the "child" form as you say. In this form there is a "Student ID" field that indicates the student that is being recommended. There could be many recommendations for the same student (many to 1).* Form B: Students can login into their WordPress account and look at this form. This is the "parent" form. Inside this form there is a field called "Amount of recommendations" that has the shortcode [frm-stats id=x type=count] as the default value. However, this shortcode is counting the recommendations of ALL the students in Form A and not the recommendations of ONLY the current student.Our idea is to only count the amount of recommendations where the "Student ID" field in Form A is equal to the "Student ID" field in Form B.We need to show this result in a field in Form B.Any ideas? Please let me know if it's clear enough. I really appreciate your help and time.
Sorry for the BLOCK of text. I don't know why my answer is not being organized by parragraphs in the forum.
Don't worry about the block of text. The HTML works better in replies to answer rather than in the answer box itself.
Form A is submitted by teachers and parents.
How are you populating the student id? Dropdown, text field, or something else?
Do the teachers and parents have WordPress user ids? Do they have to log in to submit the form?
Thanks @Victor Font . My replies to each question: Form A is submitted by teachers and parents. How are you populating the student id? Dropdown, text field, or something else? In Form A, the "Student ID" is a hidden field that auto-populates with a URL parameter. Example: If the Student ID is 123, the parameter is taken from the URL mysite.com/?student=123 Do the teachers and parents have WordPress user ids? Do they have to log in to submit the form? No, they don't have or need a WordPress account. Each student knows the link they need to share with their teachers and parents (example: mysite.com/?student=123) to gather their recommendations. Please let me know any other doubts. Thanks again.
Hi @Victor Font , just wanted to make sure you received my answers to your questions. Thanks for your support.
Please login or Register to submit your answer