Please note that this mobile device update record action is used in both triggers. The second action of the ‘ Mobile Device Update Record’ type is called “Search Result”. The first action of the ‘ Update Record’ type is called “Generate DocumentA”. Moreover, each trigger should include two actions: Let’s name these triggers “If QRCodeA” and “If QRCodeB” respectively. In our example you need to create two similar Record Change Triggers. The next step is to create triggers with mobile device record update actions. 6.Triggers with Mobile Device Record Update actions As a result, a new record is added to the “Search Requests” table. The “Search for a record” mobile device ‘record create’ action allows QR code scanning and inserting this code into the “QR Code” column. Let’s set it up in the “Search Requests” table and name this action “Search for a record”. Now you need to add a mobile action allowing code scanning and searching.
After that add the RecordId()”0″ criteria and set the ‘Readonly’ option for the “QR Code” column in this criterion.
First, set the “Document” column as ‘Readonly’ on the Default Form. When all the columns are added, you need to adjust the form behavior in the “Search Requests” table. You need this formula-URL column to generate a URL referring to the document that belongs to a “Type A Part” record if the QR code of this record was scanned.Īlso, you should build a similar URL for the “DocumentB” formula-URL column. This is the name of the summary column described above. In this example the document name is “Document A”. This is the table name “Type A Part”, please note that spaces are replaced by “%20”. In your database you will use a different token. This is the REST API authorization token generated by the system. Your database will have a different number. This is a database id number that is visible in database URL, for example: For instance, the “DocumentA” formula-URL column should contain a URL that consists of the elements described below: The most difficult step is to build formula-URL columns. The “RecordIdB” summary column should be added to the second relation. Here is an example of the “RecordIdA” summary column: These columns pull a maximal record ID from the related “Type A Parts” or “Type B Parts” table if a scanned QR code value kept in the “Search Request” record matches the QR code value kept in the “Type A Parts” (or “Type B Parts”). With the following match condition: =Īs a result, you can now add “RecordIdA” and “RecordIdB” summary columns to each relation respectively. – between “Type B Parts” and “Search Requests” tables. – between “Type A Parts” and “Search Requests” tables On the next step it is important to add two Many-to-Many relations: It will be used in the workflow action setup. Then add a “ File Attachment” – type column called “Document”. Select “QR Code” option in the “Type” dropdown: This table should include the following columns: QR Code, Document, RecordIdA, RecordIdB, DocumentA, DocumentB.įirst, let’s create a “ Barcode type”- column called “QR Code”. Now you need to create a new auxiliary table. These columns will be used in the future adjustment. So, let’s create the “RecordId” formula-text column in the “Type A Part” table:Īlso, you should create the same column in the “Type B Part” table: Moreover, you need to add a “RecordId” auxiliary formula-text column to each table with the following formula: RecordId(). “Document B” can be generated in the “Type B Parts” table. For instance, “Document A” can be generated in the “Type A Parts” table. In this example each table contains a generated document that keeps all the data related to the part. What would you have to setup in your database to build this functionality? 1.Generated Document So, each user should be able to scan a particular part’s QR code to search the database for this component and get all the supplemental information related to this part. There are parts of two types: Type A and Type B, so you keep these types in two separate tables: The main idea of this database is that users can scan QR codes via a mobile device and then search database tables for records containing QR codes.Īssume that your database keeps descriptions and photos of different computer parts. Say you’ve built the “QR Code Scanner” application.
#ONLINE QR CODE READER HOW TO#
Let’s consider an example on how to link a QR code scanner to a database.
0 kommentar(er)
