Eesh, tricky!
For stuff like this, Views really aren't that great. They really require data to be well-formatted in one way or other, otherwise submissions that you want to show up aren't going to, and vice-versa...
In terms of the clients, would be a problem to just let them see all submissions, and just let them search the results by promo code / user? Guess so, huh...
Hmm... okay, how about this:
1. you could squish all the incoming data from those two fields (company name & promo code) into a single one. This would be a new field added in Form Tools & not actually in your form. [this step could be done very easily with the Submission Pre-Parser module]
2. Create a View for each client. Each View would have a Standard Filter that's been customized to that client. Namely:
Field: [your new squished field containing all info]
Operator: LIKE
Value(s): companyname|promocode
"companyname" would be their company name - or ideally a subset of the total string that is as unique as possible; promo code would be the promo code. The pipe symbol that separates them just tells Form Tools to look for either. So that View would match submissions that had either the company or promo code (or both).
It's not ideal, since you'd need to create a custom View for each client - but it's an option.
As I said - tricky problem!
- Ben
For stuff like this, Views really aren't that great. They really require data to be well-formatted in one way or other, otherwise submissions that you want to show up aren't going to, and vice-versa...
In terms of the clients, would be a problem to just let them see all submissions, and just let them search the results by promo code / user? Guess so, huh...
Hmm... okay, how about this:
1. you could squish all the incoming data from those two fields (company name & promo code) into a single one. This would be a new field added in Form Tools & not actually in your form. [this step could be done very easily with the Submission Pre-Parser module]
2. Create a View for each client. Each View would have a Standard Filter that's been customized to that client. Namely:
Field: [your new squished field containing all info]
Operator: LIKE
Value(s): companyname|promocode
"companyname" would be their company name - or ideally a subset of the total string that is as unique as possible; promo code would be the promo code. The pipe symbol that separates them just tells Form Tools to look for either. So that View would match submissions that had either the company or promo code (or both).
It's not ideal, since you'd need to create a custom View for each client - but it's an option.
As I said - tricky problem!
- Ben