Import a reference table to validate unique entries.
Contents
What is it?
This feature allows you to upload a file that can consist of client account/membership numbers, first and last name, email and more, and connect this to your competitions to validate unique entries. This feature gives you the ability to gate access to exclusive competitions based on user membership details.
How do I use it?
- Step 1: Go to the Reference Tables setting
- Step 2: Create a Reference Table
- Step 3: Upload your Reference Table file
- Step 4: Update the Data capture form
- Step 5: Link the Reference Table to your competition
- Step 6: Update mapping fields
Step 1: Go to the Reference Tables setting
- Head to the Workspace settings followed by Reference Tables.
Step 2: Create a Reference Table
- (1) Click on Create table.
- (A) Give your reference table a name.
- (B) Add a column you have included in your file.
-
- (a) Add your column name e.g. Membership Number.
- (b) You can mark this column as a key column. The key column refers to the column that will be scanned first against the reference table on the data capture.
Note: We recommend marking the unique field as the key column e.g. membership numbers, account numbers etc.
Step 3: Upload your Reference Table file
- (1) Upload your file here as a .CSV or .XLSX format.
- (2) After you have uploaded your file, you will need to update mapping for each column created.
- (A) Enter the CSV column name of the data you want to be located in each column of the reference table.
E.g. the Membership Number reference table column is to pull all the data under the Account Numbers column and complete all columns created.
Step 4: Update the Data capture form
- Go back to your Hub and select the Settings cog on the relevant card.
- Select Data Capture on the left menu.
- Click on Form and then Entry form.
- Then click on the plus icon and add a text field.
- (A) You can make this field required.
- (B) Give the field a Label on the form.
- (C) You can give this a Unique ID for analytic purposes.
- (D) Add a placeholder text in the field.
Step 5: Link the Reference Table to your competition
- (1) On the right sidebar, click on the edit icon next to Validation lookup.
- (2) Using the drop down, select the reference table to connect to the data capture.
Step 6: Update mapping fields
- (1) Map the relevant form field against the reference table column.
- (A) Using the drop-down menu, select the form field you want to validate against the reference table column.
- (B) Here you can edit the message that appears when a value entered is not found in the reference table file.
- (2) Once you have mapped the columns you wish to validate, click on Update rules to save the validation settings.
FAQ:
What files can I import my Reference table from?
You can only import your Reference table from a CSV or XLSX file.
What can I use a Reference Table for?
You can use a reference table to qualify your users in order to enter a competition. If you want to run a competition for your members only, you can validate entries based on membership numbers, emails, first name and/or last name. This is to ensure only account owners can enter a competition, not another user using the account number to enter.
One last note:
At Komo, we pride ourselves on not only the results our clients achieve with us but the service they receive whilst bringing their Hub's to life.
If you ever have any questions about an upcoming activation, how you can best utilise Komo to get the best possible outcome, or just a general query, please don't hesitate to reach out to your Customer Success Specialist or email us at support@komo.tech
We also love your feedback, so please let us know if this article helped you by selecting from the options below.
Louis Docherty
Head of Customer Success