A visitor check-in form with autocomplete results

Check-in

A while ago, I created this visitor check-in form, and I figured it may come handy to other community members. The scenario is an hypothetical co-working space / startup incubator featuring a touch screen at their front desk for users to self check-in.

As a visitor, you are prompted to register with your first / last name and email. Then you can select your hosting startup and notify them of your arrival.
As you type the name of the startup, a filtered list of companies appears. Select the desired one to complete the check-in.

How the filtering works

The progressive filtering of the company names happens as a results of a text is updated trigger in the startup text input field. After each letter is pressed, the new text is being processed by a separate Excel sheet which determines the length of the string. This value feeds another formula in a separate column of the company database, which will be used by Intuiface to populate the filtered asset grid collection.

Excel LEN

Real time communications

Using a communication service like Twilio APIs, it’s possible to generate SMS notifications to specific persons / phone numbers associated to each startup. This can be particularly handy, since a self-service kiosk shouldn’t require a real person to call your host and let them know you arrived.

There may be an easier way to accomplish the same results, but that’s what I came up with :slight_smile:
In the meantime, feel free to download the XP here (10MB).

4 Likes

If you want to check, that’s something implemented in the sample “Cosmebox” B2B Sales Presentation - Manufacturing on the Catalog scene. It looks like this:

It’s implemented using an extra worksheet in Excel, using a copy of products that is filtered just for the completion. See below the 2 columns:


(Product column)


(Column used for completion)

Regards,

Alex.

3 Likes

@Alex thanks for the pointer. Your approach is much simpler than mine, and it returns any item that contains the string being typed. This may be the best solution for most cases. My example focused on filtering items which name started with the string being typed. Maybe an edge use case. Thanks!

1 Like

Awesome stuff.
I was looking at doing similar for work but for deliveries, and built the initial concept in MS Powerapps. Given we are using Intuiface for our main reception, I have started to think about
which would entail checking against an excel document from OneDive, or against a SharePoint list… the Delivery person could simply type in a Name, and their Block number… and do a sign/drop off, or even better, scan using OCR Detect text in images  |  Cloud Vision API  |  Google Cloud.

Great work as usual tosolini, very inspiring mate, and great suggestion Alex.

Thanks @Ryan. I like the idea of the OCR, something to explore for sure. As per OneDrive, I think if the Intuiface XP lives there, then you inherit the benefits of accessing the Excel file remotely too.

1 Like

Hi @tosolini, I find your project really interesting and I wonder if some more advanced visitor management solution (like the ones offered by Proxyclick and / or Envoy) would be possible to develop using Intuiface. Would it be possible in your opinion? Thanks!

Hi @r.armas,

I’m not familiar with these 2 solutions. Could you tell us more about the usages and scenarios you’d like to build with Intuiface?

I never heard myself about Proxyclick and Envoy. Based on quick glance at their web sites, they seem pretty robust solutions with a lot of integrations with other platforms. As @seb mentions, it’d be good to know your goals, which would help figuring out if Intuiface could replace them and to what extent.

I know a web dashboard and a mobile interface is not the goal of the Intuiface solution and that those should be accomplished through some HTML programming for example, but regarding the kiosk application I was wondering if it would be possible to not only register visitors exploring an Excel file and letting the local employee know when a visitor arrives through SMS messages but to use other platforms like WhatsApp / Google Hangouts / Microsoft Teams to communicate. Also if it would be possible to take photos of visitors (or reading a QR code on the visitor’s mobile phone) and finally what other database could be used if not using a spreadsheet.

I am not expecting to have all the huge amount of integrations Proxyclick and Envoy have as in my opinion they are not strictly necessary.

Thanks @Seb and @tosolini for your fast response!

Hi @r.armas,

Scanning a visitor’s QR Code on a phone is completely doable. We actually used this mechanism for the registration at the Intel event during ISE 2020.

It was too crowded for me to shoot a video but basically

  • a guest would either scan the QR Code on his mobile or enter his first name / last name on the screen.
  • the XP would lookup in the back-end database, using web services through API Explorer, to find the corresponding guest.
  • If found, the XP would then propose to print the badge, sending a commend to a specific badge printer (web service again).

In your scenario, replace “print a badge” with “send an SMS to host” web service and that should answer a big part of your needs.

2 Likes

Thanks @Seb!

How do you integrate the camera to capture QR codes with the rest of the XP? I just would like to know in which direction to point for running some tests.

Thanks again!

Hi @r.armas,

We were using a barcode scanner device, not a camera, plugged in USB and appearing as a Serial Port device. I don’t remember the reference used in this particular kiosk, but I have an Elo scanner with me which works the same way. It’s all about configuring the scanner properly to be seen on a COM port.

You can see more information on the Interface Asset used in this article: https://support.intuiface.com/hc/en-us/articles/360007433851-Communicate-with-devices-through-a-serial-port

3 Likes