I was wondering if there is any way for Smartsheet to capture or populate information if we swipe a card that has a magnetic strip? I.E. can we have employees swipe their ID badges and capture their employee ID number?
Hello,
Smartsheet doesn't have a way to do this "out of the box" but if you have development resources available to you, you may be able to use our API to develop an integration between your swiping software and Smartsheet.
Our API documentation is available here: https://smartsheet-platform.github.io/api-docs/
Hi,
I think this can be achieved thru Zapier or maybe a prepopulated form somehow.
I assume that you can't reprogram the cards because you use them for other things also. Correct?
Can you tell us more about the use case?
I hope this helps you!
Andrée Starå - Workflow Consultant / Get Done
Yes that is correct. The card id's are used for other purposes. Everything from secure door access to payment with attached billing accounts.
I was looking through Zapier can dont seem to find that feature.
I think we may have to go with an API approach
Ok.
The API route sound good but i just came to think about a potential workaround.
Would it work if you attached a QR code or a RFID sticker to the card with the correct information?
Best,
I am trying to setup an upload workflow where I bring data from an excel spreadsheet into a sheet in Smartsheet. The Data Shuttle workflow will not find the columns in my source sheet. The column headers start on row 2 in my excel sheet but the mapping portion of the workflow builder will not find the columns. Any…
I want to do what I think is a simple cross-table join. I have a table with a list of project week start dates (lets assume 40 weeks). I have a separate table with a list of all resources working on the project (lets assume 20 resources) I would like an automated way to create a new master table which has a row for unique…
Seeing if anyone has a similar experience or guidance. We have two sheets which we are using data shuttle between: • Client project tracker • Internal project tracker We have setup matching column names and types, which we want to use data shuttle to communicate updates between our two sheets. We pull unique store numbers,…
