1EarEngineer Posted June 26, 2016 Report Share Posted June 26, 2016 I am currently attempting to make an event attendance submission form and am having some issues getting the form to recognize multiple UserNames correctly. What I need is that for all names entered, they are also associated with a points value. After each member obtains enough points, they get a price (gift card etc), and then be able to run a Pivot Table and see that Person X has X amount of points. What I run into is that while on 1 entry Person 1 may be in UserName1 field for one event, they might be in a different field another time, so when I run the report, it doesn't combine them all entries for Person 1 into a single field. Perhaps I'm overthinking this, but basically I want it so that we can have up to 64 names submitted, all names submitted recieve the points value and then when I run a report for John D. I can simply type in John D and i see he has say, 120 points. Quote Link to comment Share on other sites More sharing options...
MayMusic Posted June 27, 2016 Report Share Posted June 27, 2016 As I understand you want to search for a value among all username fields for all records, if that is the case, you can create a separate search and in Configure Filtering Fields screen receive the same parameter you are searching for, for all Username fields. Comparison type would be OR between them Quote Link to comment Share on other sites More sharing options...
1EarEngineer Posted June 27, 2016 Author Report Share Posted June 27, 2016 (edited) Hi MayMusic, I was hoping to have a Pivot table that has the Username on the left with their point totals on the right like below John D 120 points Adam S 75 points John H 10 points My issue is currently each Username entry is a different field, so in the table there is Username1, Username2 etc. So when I do my Pivot table, it shows Username1, Username2 and it won't combine the points, so that if one entry had John D as Username 1, and then another entry he was Username34, it doesn't see those as the same person. I'm trying to find a way so that I can combine those into 1 field. I am just not sure how. I assume it's going to have to be a change in my submission form, just not sure how to do this. Edited June 27, 2016 by 1EarEngineer Adding more information/clarification Quote Link to comment Share on other sites More sharing options...
1EarEngineer Posted June 27, 2016 Author Report Share Posted June 27, 2016 Also, can you post a screenshot of where you are referring to? I don't see those options anywhere, or I am simply not seeing them. I apologize I found it, i misunderstood where you were saying it was located.However, that did not resolve my issue Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.