I’m new to this. Can someone please explain where the long strings within single quotes in the first few lines of the example come from? I want to make this as a demo in order to figure out how it works so as to apply to my problem.
Those are the field identifiers in your form. It would be better if the variable names in this example code ended with ‘_id’ as they do when you create them in the script editor,
Excellent suggestion. I probably wrote that script before I defaulted to appending “_id” to the field titles.
I’ve just updated the manual.
Nice! Readability is so much better.
Thanks for the replies but can you go back a step or two? Are the field identifiers generated automatically? Where can they be found?
From the documentation:
Please note that the field IDs in the above script (e.g. movie_title_id = ‘fld-….’) are unique to the form this script was written for. You would need to use your own field IDs from your own form to make this script work.
You create them inside the script editor by selecting the field and then clicking on the ID button.
Brendan, it might be helpful to update the screen captures of the script editor as well to show all the buttons available right now.
Many thanks Daniel, I’ll try it!
Doh! I am struggling to make sense of the examples although I do know Google Apps Script for Sheet. Can someone kindly help get me started with scripting my planned application?
I have successfully imported into TF on iPhone a .csv file of names, membership numbers and some other details of ticket bookings for an event. Each ticket will have a printed QR or barcode of the person’s membership number. I wish to create a TF script which enables the QR or barcode on each ticket to be scanned by the iPhone on attendee registration, retrieving the relevant ticket and automatically completing a field in the form to record their attendance. That’s all . . .
Thanks in hope and in advance!
I’m not sure you can fully do what you need with a script right now, the scripting interface doesn’t have a way of scanning anything.
That said, what you can do is use the barcode scanner the search feature has to look up the record and if you had a checkmark for registration you could add a field script to watch that checkmark field and do what ever business process you need.
Sam thanks for this suggestion. Could the record found by scanning the code then be displayed using a custom Layou; and can the Layout include the checkmark field so the checkin agent just taps that to confirm, and then moves on to the next person in line?
Ah apparently Layouts aren’t supported in TP ios version presently. . . .
I hope that one day I can use the Prompter for scanning items. Then things could be automated with a script.
To workaround the prompter limitation, I have an iOS app called “ScanKey” that is a custom keyboard with a built in barcode and QR code scanner. I think it also does NFC but I’ve never had a chance to use that. That lets me use a barcode scanner in the standard prompter. It’s not the greatest interface, it’s a bit clunky but it does the job. I also use Shortcuts’ built in scanner to do quick ingest via CouchDB post.
.
