By NeueArbeit on Thursday, 11 March 2021
Replies 4
Likes 0
Views 616
Votes 0
Hello Tony,

I managed to set up a "Click & Meet" scenario with the powerful addon RSVP PRO.
It looks almost perfect now.
My next quest is to set up a frontend page to let output a table with the following parameters:

Form-Select: Select a category (in my case: one of our second-hand-shops)
Form-Select: Select a date
Form-Select: Select an event


Form-Submit: output a html-table with all attendees of this single event.

Output: I have some custom fields in my specific template, because we need this information by law (corona-virus):

- names of the attendees,
- surnames of the attendees,
- email-adresses of the attendees,
- phone numbers of the attendees.


So, If an admin (logged in in the frontend) selects a category and a date, there should be all the events of that date and category in the third select: event. This should be possible by ajax.
I know, this is possible but it will be a very very hard work to generate the MySQL-Selects for this.

Before I do a day and night work, I just have a question: do you have these selects somewhere and could you give them to me?

If neccessary, I can give you the front end link and I could generate a super user - backend account for you, so you can have a glance on this.

Kind regards
Oliver
Hello Oliver,

That's great to hear!

What about just including the information in the event underneath it? You can click to include the attendee list. Then in each of the RSVP Pro Template fields you can configure them to show in list for what you want to show?

Many thanks
Tony
·
4 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Tony,

thank you for your advice.
I still have to develop a custom module for this list, which should not be so difficult.
My only problem is to develop the MySQL-Selects, because I am not familiar with things like "LEFT JOIN...".
I have never been using such selects. They are complicated and I just hoped you already have these kinds of selects somewhere.

Kind regards
Oliver
·
4 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello again,

I have been thinking and thinking of this...
and now I have an idea:
the code is already there: in the frontend there is a simple way to navigate to all of the events.
Then, I just have to magage a simple thing:

If the user is logged in as an admin, all the attendees of this event should be listed.
Therefore I just need to know where to code a switch: if the user state is "logged in as an admin" -> then list all the attendees.
If not -> don't show them (privacy).

Could you please give me an advice where I can implement such a switch?
This would be very nice.
If I cannot solve this problem, we need to look for an alternative to jevents, which will be sad for us.

Kind regards
Oliver
·
4 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Tony,

I managed to give the admins of our second hand shop - click&meet the possibility to let out a proper attendee list. Just found out something:
if I allow the attendees to be listed in the frontend under the event view, the uer has to be logged in to see their names and data. For the public this data is not to be seen. So we can keep this privacy, but simply print out a attendee list to be kept several weeks as we are told by law.

Diolch for everything and have a nice weekend.
Many greetings
Oliver
·
4 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post