CiviCRM Community Forums (archive)

The organization that I am supporting uses CiviCRM to manage their memberships. However some of their activities are simultaneous and take place at multiple locations and they are looking at a quick way to update a member's record. In particular, whether or not they attended the event and also if a donation was made. They want to perform these updates via tablets with wireless connections. The tablets will be issued to the site coordinators. They also want to allow someone to purchase a membership onsite and to also issue a member card that includes a "Member  ID"  right on the spot.

I have been experimenting with QR codes and it is quite simply to include it on the member card. The code would be based on the unique url of the member's record. If the site coordinator is logged into the site they can easily scan the code,  bring up the record for that member, and update their record accordingly. For existing members, we can create a card and issue just them.

However, I have not found a good solution for being able to provide a member card on the spot for a new member that does not already have a record in the database. Due to cost and few other factors, the organization wants to preprint cards with codes in advance. For now, the membership signup has to be paper based. This application is submitted and the membership card will be issued. There are literally hundreds of people in line and no time to create the record with the necessary details on site via the tablet. This will be done later.  Any suggestions on how I could solve this problem?

- If the format of url to each record is always the same with the variable being the "CiviCRM ID". Should I just create a block of generic/blank records and base the url in the QR Code on the ID numbers?  Note: The organization wants their own unique numbering system, but I am not aware of how a custom field can be included in the url. Since they are not interested in typing a number in a search field my main objective is to bring up a record by scanning the QR code.

-How do I search for the "CiviCRM ID"? I do not see an option to search for this identifier even in the advance search and search builder.

-Does anyone know of any good mobile/tablet profile type views in existence?

I am open to any suggestions on different approaches on how to solve this problem. Thanks in advance

Any luck with this? I'm on Wordpress but am looking to do the EXACT same thing. Association has 1500 current members, we just migrated them to CiviCRM and members dont' have cards. Their AGM is coming up and I'm looking to use QR codes to bulk email their membership data, which they will then print and bring with them to the AGM. Once they arrive, we scan with iPad or iPhone, verify their membership and allow them to vote.

If you have solved this, maybe we can work together to source some more info together?

Hi,

For friskis, I have a custom module to create incremental numbers in a custom field.
For events, I did play with qrcode (generated on the client side in javascript). The easier it probably to add it on the event confirmation or dashboard.

The code is probably too specific to be re-used directy but if you think it helps, happy to git share "works for me but your mileage might vary"

Not sure how important the security is in your case, it's fairly easy to generate a qrcode with a number. You might want to add a checksum or other measures to avoid cheating.