Complete List of Database Module How Tos
How To: Add a Database Field
To create a database field, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Fields” opening the Fields for database (DatabaseName) Page.
There are two ways to add a field to the Field Table. Click the “New Field” button above the Field Table or click the three dot (…) icon to the right of the page header opening the context menu and select “Add Entry”.
This opens the New Database Field Modal.
The creation of a new field will always require you to enter a field name. Include an input for the displayed label and select the field type from a dropdown menu. The inputs on the New Database Field Modal will vary based on the Field Type.
Possible field types in the database module include Form Fields, Formatting Fields, Utility Fields, or a Reference to Another Database.
A database field can only have one field type. If you need to utilize another (e.g., for formatting purposes), you can set the displayed label to be same, but the field label must be unique.
For an explanation of field types and the formatting choices associated with each one, reference the Understanding Fields Section of the Database Module in the User Manual.
Once you are finished inputting the information for the new field, select “Save” and the new database field will show in the Field Table.
Fields can also be imported in bulk into a Database from a CSV.
How To: Import Fields from a PDF Field Import
This method of importing Fields from a PDF requires access to Adobe Acrobat Pro.
If a field has already been added to a database, you are no longer able to bulk import database field names from a PDF Field Import. You are now required to enter each field name individually.
How To: Add a Database Field
{{@321}}
To import field names in bulk from a CSV file, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Fields” opening the Fields for database (DatabaseName) Page.
Click the “PDF Field Import” button opening the PDF Field Import Modal.
To import fields using a PDF, use the “Prepare Form” tool in Adobe Acrobat Pro. Add the fields you wish to use for your form. Add a button on your document.
Use the URL link provided on the PDF Field Import Modal in KAStrack.
Confirm that the Export Format is “PDF The complete document”.
Open the PDF and submit the form to generate the fields here.
You do not need to fill in any of the fields, and you must not sign it.
Select “Allow” and the PDF will confirm that the fields were added to the database.
Go to the Fields Table in the database Monday, and a warning now states that a PDF is associated with the form and that adding/editing or deleting fields may result in the PDF no longer being compatible.
How To: Add a Database Group
To add a database group, go to the Groups Page of the Database Module.
Select the “New Group” button opening the New Group Modal.
Input the desired name of the new group and select the “Save” button.
The new group will now show in the Group Table.
How To: Add a Database Rule
To add a database rule, go to the Home Page in the Database Module.
Click the three dot (…) icon to the right of the database you want to edit to open the context menu. Select “Rules” opening the Rules Tab that contains the Rules Table.
Before any rules are created, the Rules Table will show the fields rule name, conditions, actions and status with no entries.
Select the “New Rule” button opening the New Database Rule Modal.
Input a Rule Name, a required field.
Select a status from the dropdown menu: Active or Inactive. This is a required field.
Click the plus icon to the right of Conditions to add a condition to the rule, expanding the section for the input of the trigger, what must be true, and what happens if it is true.
Once the condition has been entered, select “Save” to return to the New Database Rule Modal.
The condition created will show in the modal.
As many conditions as desired can be entered, as well as none at all.
Click the plus sign to the right of the Actions to add an action to the rule, expanding the section to all for the configuration of the action to be taken when the conditions are met.
Once the rule as been entered, select “Save” to return to the New Database Rule Modal.
The action will show in the modal.
Select “Save”. A popup will confirm that the rule was saved. It will now show in the Rules Table.
How To: Add a New Module Level (Database Module)
To add a new module level in the Database Module, go to the Settings Page and select the “New Module Level” button.
This opens the New Module Level Modal.
Input a name for the new module level and select the “Save” button.
The new module level will now show in the module level table on the Settings Page. Module levels created by your organizations can be customized.
Select the bulleted list icon to add permissions to the new module level.
Click the checkboxes for the permissions you would like to be granted to the new module level.
Select “Save” when done added permissions.
How To: Add an Individual Database Entry
To add a database entry, go to the Home Page of the Database Module. Click the three dot (…) icon to the right of the database you wish to add an entry to opening the context menu. Select “Add Entry”.
You can select “Add Entry” from any context menu in the Database Modal without returning to the Home Page.
Selecting “Add Entry” opens the New Database Entry modal. Two visual examples of this modal have been included below.
The New Database Entry Modal will vary for every database, based on the fields that have been created for it.
Input the entry data into the modal. Select “Save” for the new entry to be added to the database.
If no fields have been created for the database, the New Database Entry Modal will show without any fields as seen below.
If you select to “Save” a database entry prior to the creation of database fields, an entry will be assigned an Entry ID by the system and will show in the Entries Table. The submitter, approval status, and entry date will be logged.
How To: Add Tags to a Database Entry
Select “Manage Entries” from the context menu opening the Entries for database (DatabaseName) Page.
To the right of every Entry ID is a three-dot icon. Click the three-dot icon for the entry you wish to add tags to opening the Database Entries Table context menu.
How To: Bulk Edit/Delete Database Entries
To bulk edit database entries, go to the Home Page of the Database Module. Click the three dot icon opening the database context menu.
Select “Manage Entries” opening the Entries for database (DatabaseName) Page.
To the right of every Entry ID is a three-dot icon that opens a context menu with the options to View Entry, Edit Entry, Tags, Audit Log, and Delete Entry. An explanation of each option
Select the “Enable Bulk Edit Mode” checkbox. A delete selected button appears. A checkbox now shows to the left of every Entry ID. Selecting checkboxes allows for the bulk deletion of entries.
Hovering the cursor over any field entry will show an edit icon.
Click the edit icon, and the form field will now open for edits.
Click the disc icon for your changes to be saved by the system.
How To: Copy a Database
To copy a database, go to the Home Page in the Database Module.
Click the three dot (…) icon to the right of the database you want to copy to open the context menu. Select “Copy Database” opening the Copy (DatabaseName) Database Modal.
The modal will automatically create a new title, (DatabaseName) Copy, that can be altered if desired.
If there are any PDF versions of this database, they will need to be updates with the new submission URL and uploaded to the copied database. Associated entries will not be copied.
Click “Copy”.
You will be directed to the Fields Table for your newly copied database.
The copied database will now show in the Database Table on the Home Page.
How To: Create a Database
To create a new database, go to the Home Page of the Database Module.
Click the “Create Database” button, opening the New Database Modal.
Input a Title for the new database. Select any groups the database should be associated with. Provide a description of the database and its purpose in the textbox provide. Select any tags desired.
Select the “Allow Default Access” checkbox to indicate that the database should follow the defaults established by module and access levels. If this checkbox is not selected, you will be required to establish user specific access based on individual or certification roles.
The following database specific permissions are selected via drop down menu lists that include all individuals and certification roles that can be assigned permission.
Admins allows users or role to have admin module level permissions for this particular database. A list of all admin module level permissions is shown in the table below.
Database Admin Module Level Permissions |
Manage roles (add/view/edit/delete, assign hidden roles, role permissions) Database (view/edit/delete/list/add, upload csv) Database Fields (edit/delete/view/list) Database Entry (view/edit/delete/list/add) Can delete entries from other modules |
Manage Entry Permissions gives the indicated users permission to view, add, edit, and delete database entries.
View Entry Permissions gives the indicated users permission to view database entries.
Allow Integration With denotes which other modules can link with and integrate with this database or forms for reference.
The Database Module can be integrated with the following modules:
- Forms
- Database
- Inventory
- Grid
Click “Cancel” and return to the Database Module Home Page without any changes being made. Select “Save” to create the new database and you will be directed to the Fields Table for your newly copied database.
Once a database has been created, you can enter database fields into it.
How To: Import Fields from a CSV File Into a Database
To import database entries from a CSV, database fields must already have been created.
How To: Add a Database Field
{{@321}}
How To: Import Fields from a CSV File Into a Database
{{@339}}
How To: Import Fields from a PDF Field Import
{{@340}}
To import database entries from a CSV, go to the Home Page of the Database Module and click the three dot menu to the right of the database you wish to import entries into.
Select “Upload CSV” opening the Upload CSV for (DatabaseName) Modal.
You can also import entries by selecting “Manage Entries” from the context menu and selecting the “Import Entries” button underneath the Database Entries Page header, which opens the same Upload CSV Modal.
Click the “Download Template” link at the top of the modal and a CSV file will be downloaded to your personal device. See Notes on the Download Template before uploading your CSV file to ensure it is done correctly.
Notes Regarding the Downloadable Template for Uploading CSV Files
The first row of the CSV file is for each of the database fields. If you download a CSV Template from the Upload CSV Modal, two additional column headers will show that are not database fields: Entry ID and Modify Existing Entry.
If you are importing database entries and no entries have been added to the database yet, leave these columns blank in your upload.
If database entries already exist in the database, the Entry ID column will contain the unique system generated ID for each pre-existing database entry. Leave this column blank if the row is to be imported as a new entry. The second column, Modify Existing Entry, should have a “Y” input if the existing entry is being modified and an “N” input if it has not been modified. Leave it blank if the entry is new.
After creating your Database Fields CSV File, save it as a CSV UTF-8 for importing.
Click the “Choose File” button and open the relevant file from your personal device.
Confirm that the correct CSV file now shows in the Upload CSV Modal.
Select the “Upload” button.
The entries imported from the CSV file will now show on the Upload CSV for (DatabaseName) Page.
The system automatically indicates to ignore the first row. Click “Import Now” if there are no errors.
A summary of the import will now show on the CSV Upload Page.
Click the “Entries for (DatabaseName)” link to see all imported entries in the Manage Entry Table.
How To: Import Fields from a PDF Field Import
This method of importing Fields from a PDF requires access to Adobe Acrobat Pro.
If a field has already been added to a database, you are no longer able to bulk import database field names from a PDF Field Import. You are now required to enter each field name individually.
How To: Add a Database Field
{{@321}}
To import field names in bulk from a CSV file, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Fields” opening the Fields for database (DatabaseName) Page.
Click the “PDF Field Import” button opening the PDF Field Import Modal.
To import fields using a PDF, use the “Prepare Form” tool in Adobe Acrobat Pro. Add the fields you wish to use for your form. Add a button on your document.
Use the URL link provided on the PDF Field Import Modal in KAStrack.
Confirm that the Export Format is “PDF The complete document”.
Open the PDF and submit the form to generate the fields here.
You do not need to fill in any of the fields, and you must not sign it.
Select “Allow” and the PDF will confirm that the fields were added to the database.
Go to the Fields Table in the database Monday, and a warning now states that a PDF is associated with the form and that adding/editing or deleting fields may result in the PDF no longer being compatible.
How To: Add a Database Field
To create a database field, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Fields” opening the Fields for database (DatabaseName) Page.
There are two ways to add a field to the Field Table. Click the “New Field” button above the Field Table or click the three dot (…) icon to the right of the page header opening the context menu and select “Add Entry”.
This opens the New Database Field Modal.
The creation of a new field will always require you to enter a field name. Include an input for the displayed label and select the field type from a dropdown menu. The inputs on the New Database Field Modal will vary based on the Field Type.
Possible field types in the database module include Form Fields, Formatting Fields, Utility Fields, or a Reference to Another Database.
A database field can only have one field type. If you need to utilize another (e.g., for formatting purposes), you can set the displayed label to be same, but the field label must be unique.
For an explanation of field types and the formatting choices associated with each one, reference the Understanding Fields Section of the Database Module in the User Manual.
Once you are finished inputting the information for the new field, select “Save” and the new database field will show in the Field Table.
Fields can also be imported in bulk into a Database from a CSV.
How To: Import Fields from a PDF Field Import
{{@340}}
Once you have entered database fields, you can add database entries into it.
How To: Add an Individual Database Entry
To add a database entry, go to the Home Page of the Database Module. Click the three dot (…) icon to the right of the database you wish to add an entry to opening the context menu. Select “Add Entry”.
You can select “Add Entry” from any context menu in the Database Modal without returning to the Home Page.
Selecting “Add Entry” opens the New Database Entry modal. Two visual examples of this modal have been included below.
The New Database Entry Modal will vary for every database, based on the fields that have been created for it.
Input the entry data into the modal. Select “Save” for the new entry to be added to the database.
If no fields have been created for the database, the New Database Entry Modal will show without any fields as seen below.
If you select to “Save” a database entry prior to the creation of database fields, an entry will be assigned an Entry ID by the system and will show in the Entries Table. The submitter, approval status, and entry date will be logged.
How To: Import Database Entries from a CSV
To import database entries from a CSV, database fields must already have been created.
How To: Add a Database Field
{{@321}}
How To: Import Fields from a CSV File Into a Database
{{@339}}
How To: Import Fields from a PDF Field Import
{{@340}}
To import database entries from a CSV, go to the Home Page of the Database Module and click the three dot menu to the right of the database you wish to import entries into.
Select “Upload CSV” opening the Upload CSV for (DatabaseName) Modal.
You can also import entries by selecting “Manage Entries” from the context menu and selecting the “Import Entries” button underneath the Database Entries Page header, which opens the same Upload CSV Modal.
Click the “Download Template” link at the top of the modal and a CSV file will be downloaded to your personal device. See Notes on the Download Template before uploading your CSV file to ensure it is done correctly.
Notes Regarding the Downloadable Template for Uploading CSV Files
The first row of the CSV file is for each of the database fields. If you download a CSV Template from the Upload CSV Modal, two additional column headers will show that are not database fields: Entry ID and Modify Existing Entry.
If you are importing database entries and no entries have been added to the database yet, leave these columns blank in your upload.
If database entries already exist in the database, the Entry ID column will contain the unique system generated ID for each pre-existing database entry. Leave this column blank if the row is to be imported as a new entry. The second column, Modify Existing Entry, should have a “Y” input if the existing entry is being modified and an “N” input if it has not been modified. Leave it blank if the entry is new.
After creating your Database Fields CSV File, save it as a CSV UTF-8 for importing.
Click the “Choose File” button and open the relevant file from your personal device.
Confirm that the correct CSV file now shows in the Upload CSV Modal.
Select the “Upload” button.
The entries imported from the CSV file will now show on the Upload CSV for (DatabaseName) Page.
The system automatically indicates to ignore the first row. Click “Import Now” if there are no errors.
A summary of the import will now show on the CSV Upload Page.
Click the “Entries for (DatabaseName)” link to see all imported entries in the Manage Entry Table.
How To: Delete a Database
To delete a database, go to the Home Page in the Database Module.
Click the three dot (…) icon to the right of the database you want to delete to open the context menu. Select “Delete Database” opening the Delete Database Confirmation Modal.
Confirm you wish to delete the database by clicking the “Delete” button.
A popup will briefly appear, confirming that the database has been deleted.
Selecting “Cancel” will return you to the Databases Home Page without any alterations being made.
How To: Delete a Database Entry
To delete a database entry, go to the Home Page of the Database Module. Click the three dot icon to the right of the database you wish to delete an entry in opening the database context menu.
Select “Manage Entries” from the context menu opening the Entries for database (DatabaseName) Page.
To the right of every Entry ID is a three-dot icon. Click the three-dot icon for the entry you wish to delete opening the Database Entries Table context menu.
Select “Delete Entry” opening the Delete Database Entry Confirmation Modal that states, “Are you sure you want to delete this Database Entry?”
Select “Delete” to confirm deletion of the database entry.
How To: Delete Database Groups
To delete a database group, go to the Groups Page of the Database Module.
Select the three dot icon to the right of the Group Name you wish to delete, opening the Group Table context menu.
Select “Delete Group” from the context menu opening the Delete Group Confirmation Modal.
The modal states, “Are you sure you want to delete this Group?” and lists the Group Name on the modal. Select the “Delete” button and a pop up confirms that the group has been deleted.
The deleted group no longer shows on the Groups Table.
How To: Edit a Database
To edit a database, go to the Home Page in the Database Module.
Click the three dot (…) icon to the right of the database you want to edit to open the context menu. Select “Edit Database” opening the Edit Database Modal.
The title, groups, tags, or database description can be altered from the modal, as well as the additional database specific permissions established when the database was created.
How To: Create a Database
To create a new database, go to the Home Page of the Database Module.
Click the “Create Database” button, opening the New Database Modal.
Input a Title for the new database. Select any groups the database should be associated with. Provide a description of the database and its purpose in the textbox provide. Select any tags desired.
Select the “Allow Default Access” checkbox to indicate that the database should follow the defaults established by module and access levels. If this checkbox is not selected, you will be required to establish user specific access based on individual or certification roles.
The following database specific permissions are selected via drop down menu lists that include all individuals and certification roles that can be assigned permission.
Admins allows users or role to have admin module level permissions for this particular database. A list of all admin module level permissions is shown in the table below.
Database Admin Module Level Permissions |
Manage roles (add/view/edit/delete, assign hidden roles, role permissions) Database (view/edit/delete/list/add, upload csv) Database Fields (edit/delete/view/list) Database Entry (view/edit/delete/list/add) Can delete entries from other modules |
Manage Entry Permissions gives the indicated users permission to view, add, edit, and delete database entries.
View Entry Permissions gives the indicated users permission to view database entries.
Allow Integration With denotes which other modules can link with and integrate with this database or forms for reference.
The Database Module can be integrated with the following modules:
- Forms
- Database
- Inventory
- Grid
Click “Cancel” and return to the Database Module Home Page without any changes being made. Select “Save” to create the new database and you will be directed to the Fields Table for your newly copied database.
Once a database has been created, you can enter database fields into it.
How To: Import Fields from a CSV File Into a Database
{{@338}}
How To: Import Fields from a PDF Field Import
{{@340}}
How To: Add a Database Field
{{@321}}
Once you have entered database fields, you can add database entries into it.
How To: Add an Individual Database Entry
{{@325}}
How To: Import Database Entries from a CSV
{{@338}}
Confirm you wish to edit the database by clicking the “Save” button.
Selecting “Cancel” will return you to the Databases Home Page without any alterations being made.
How To: Edit a Database Entry
To edit a database entry, go to the Home Page of the Database Module and click the three-dot icon to the right of the database you wish to edit opening the database context menu.
Select “Manage Entries” from the context menu opening the Entries for database (DatabaseName) Page.
To the right of every Entry ID is a three-dot icon. Click the three-dot icon for the entry you wish to edit opening the Database Entries Table context menu.
Selecting “Edit Entry” from the Database Entries Table opening the Edit Database Entry Modal.
Make changes as desired to edit the entry and select the “Save” button.
Your edits will now show in the Database Entries Table.
How To: Edit Database Groups
To edit a database group, go to the Groups Page of the Database Module.
Select the three-dot icon to the right of the Group Name you wish to edit, opening the Group Table context menu.
Select “Edit Group” from the context menu opening the Edit Group Modal.
Make the desired changes to the group name and select “Save”. The edited group name will now show in the Groups Table.
How To: Edit the Status of a Database Rule
To change the status of a database rule, go to the Home Page in the Database Module.
Click the three dot (…) icon to the right of the database you want to edit to open the context menu. Select “Rules” opening the Rules Tab that contains the Rules Table.
To the right of an entry’s status is an icon. Click it and it will change and active status to inactive (and vice versa).
How To: Export Database Entries
To export the existing database fields and entries, go to the Home Page of the Database Module.
Click the three dot (…) icon to the right of the database you want to export to open the context menu. Select “Manage Entries” to open the Database Entries Page.
Select the “Export Entries” button and a CSV file with database fields and entries will be downloaded to your personal device.
How To: Import Database Entries from a CSV
To import database entries from a CSV, database fields must already have been created.
How To: Add a Database Field
To create a database field, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Fields” opening the Fields for database (DatabaseName) Page.
There are two ways to add a field to the Field Table. Click the “New Field” button above the Field Table or click the three dot (…) icon to the right of the page header opening the context menu and select “Add Entry”.
This opens the New Database Field Modal.
The creation of a new field will always require you to enter a field name. Include an input for the displayed label and select the field type from a dropdown menu. The inputs on the New Database Field Modal will vary based on the Field Type.
Possible field types in the database module include Form Fields, Formatting Fields, Utility Fields, or a Reference to Another Database.
A database field can only have one field type. If you need to utilize another (e.g., for formatting purposes), you can set the displayed label to be same, but the field label must be unique.
For an explanation of field types and the formatting choices associated with each one, reference the Understanding Fields Section of the Database Module in the User Manual.
Once you are finished inputting the information for the new field, select “Save” and the new database field will show in the Field Table.
Fields can also be imported in bulk into a Database from a CSV.
How To: Import Fields from a PDF Field Import
{{@340}}
How To: Import Fields from a CSV File Into a Database
If a field has already been added to a database, you are no longer able to bulk import database field names from a CSV file. You are now required to enter each field name individually.
How To: Add a Database Field
{{@321}}
To import database field names from a CSV file, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Upload CSV” opening the Upload CSV for (DatabaseName) Modal.
When creating your CSV file, the first row of the CSV file is used. Each individual cell in that row will be a database field used as columns for data entry. When importing bulk field names, the notes in the Upload CSV Modal on “Entry ID” and “Modify Entry ID” are not relevant.
After creating your Database Fields CSV File, save it as a CSV UTF-8 for importing.
Click the “Choose File” button and open the relevant file from your personal device.
Confirm that the correct CSV file now shows in the Upload CSV Modal.
Select the “Upload” button.
Configure each database field as desired. Field types shown on the dropdown menu include form fields: Text, Text Box, Checkbox, Dropdown, Radios, Data, and Data/Time.
Select “Import Now” and a summary of the import with show on the CSV Upload Page.
All imported field will now show on the Fields for database (DatabaseName) Page in the Fields Table.
How To: Import Fields from a PDF Field Import
This method of importing Fields from a PDF requires access to Adobe Acrobat Pro.
If a field has already been added to a database, you are no longer able to bulk import database field names from a PDF Field Import. You are now required to enter each field name individually.
How To: Add a Database Field
{{@321}}
To import field names in bulk from a CSV file, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Fields” opening the Fields for database (DatabaseName) Page.
Click the “PDF Field Import” button opening the PDF Field Import Modal.
To import fields using a PDF, use the “Prepare Form” tool in Adobe Acrobat Pro. Add the fields you wish to use for your form. Add a button on your document.
Use the URL link provided on the PDF Field Import Modal in KAStrack.
Confirm that the Export Format is “PDF The complete document”.
Open the PDF and submit the form to generate the fields here.
You do not need to fill in any of the fields, and you must not sign it.
Select “Allow” and the PDF will confirm that the fields were added to the database.
Go to the Fields Table in the database Monday, and a warning now states that a PDF is associated with the form and that adding/editing or deleting fields may result in the PDF no longer being compatible.
To import database entries from a CSV, go to the Home Page of the Database Module and click the three dot menu to the right of the database you wish to import entries into.
Select “Upload CSV” opening the Upload CSV for (DatabaseName) Modal.
You can also import entries by selecting “Manage Entries” from the context menu and selecting the “Import Entries” button underneath the Database Entries Page header, which opens the same Upload CSV Modal.
Click the “Download Template” link at the top of the modal and a CSV file will be downloaded to your personal device. See Notes on the Download Template before uploading your CSV file to ensure it is done correctly.
Notes Regarding the Downloadable Template for Uploading CSV Files
The first row of the CSV file is for each of the database fields. If you download a CSV Template from the Upload CSV Modal, two additional column headers will show that are not database fields: Entry ID and Modify Existing Entry.
If you are importing database entries and no entries have been added to the database yet, leave these columns blank in your upload.
If database entries already exist in the database, the Entry ID column will contain the unique system generated ID for each pre-existing database entry. Leave this column blank if the row is to be imported as a new entry. The second column, Modify Existing Entry, should have a “Y” input if the existing entry is being modified and an “N” input if it has not been modified. Leave it blank if the entry is new.
After creating your Database Fields CSV File, save it as a CSV UTF-8 for importing.
Click the “Choose File” button and open the relevant file from your personal device.
Confirm that the correct CSV file now shows in the Upload CSV Modal.
Select the “Upload” button.
The entries imported from the CSV file will now show on the Upload CSV for (DatabaseName) Page.
The system automatically indicates to ignore the first row. Click “Import Now” if there are no errors.
A summary of the import will now show on the CSV Upload Page.
Click the “Entries for (DatabaseName)” link to see all imported entries in the Manage Entry Table.
How To: Import Fields from a CSV File Into a Database
If a field has already been added to a database, you are no longer able to bulk import database field names from a CSV file. You are now required to enter each field name individually.
How To: Add a Database Field
To create a database field, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Fields” opening the Fields for database (DatabaseName) Page.
There are two ways to add a field to the Field Table. Click the “New Field” button above the Field Table or click the three dot (…) icon to the right of the page header opening the context menu and select “Add Entry”.
This opens the New Database Field Modal.
The creation of a new field will always require you to enter a field name. Include an input for the displayed label and select the field type from a dropdown menu. The inputs on the New Database Field Modal will vary based on the Field Type.
Possible field types in the database module include Form Fields, Formatting Fields, Utility Fields, or a Reference to Another Database.
A database field can only have one field type. If you need to utilize another (e.g., for formatting purposes), you can set the displayed label to be same, but the field label must be unique.
For an explanation of field types and the formatting choices associated with each one, reference the Understanding Fields Section of the Database Module in the User Manual.
Once you are finished inputting the information for the new field, select “Save” and the new database field will show in the Field Table.
Fields can also be imported in bulk into a Database from a CSV.
How To: Import Fields from a PDF Field Import
{{@340}}
To import database field names from a CSV file, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Upload CSV” opening the Upload CSV for (DatabaseName) Modal.
When creating your CSV file, the first row of the CSV file is used. Each individual cell in that row will be a database field used as columns for data entry. When importing bulk field names, the notes in the Upload CSV Modal on “Entry ID” and “Modify Entry ID” are not relevant.
After creating your Database Fields CSV File, save it as a CSV UTF-8 for importing.
Click the “Choose File” button and open the relevant file from your personal device.
Confirm that the correct CSV file now shows in the Upload CSV Modal.
Select the “Upload” button.
Configure each database field as desired. Field types shown on the dropdown menu include form fields: Text, Text Box, Checkbox, Dropdown, Radios, Data, and Data/Time.
Select “Import Now” and a summary of the import with show on the CSV Upload Page.
All imported field will now show on the Fields for database (DatabaseName) Page in the Fields Table.
How To: Import Fields from a PDF Field Import
This method of importing Fields from a PDF requires access to Adobe Acrobat Pro.
If a field has already been added to a database, you are no longer able to bulk import database field names from a PDF Field Import. You are now required to enter each field name individually.
How To: Add a Database Field
To create a database field, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Fields” opening the Fields for database (DatabaseName) Page.
There are two ways to add a field to the Field Table. Click the “New Field” button above the Field Table or click the three dot (…) icon to the right of the page header opening the context menu and select “Add Entry”.
This opens the New Database Field Modal.
The creation of a new field will always require you to enter a field name. Include an input for the displayed label and select the field type from a dropdown menu. The inputs on the New Database Field Modal will vary based on the Field Type.
Possible field types in the database module include Form Fields, Formatting Fields, Utility Fields, or a Reference to Another Database.
A database field can only have one field type. If you need to utilize another (e.g., for formatting purposes), you can set the displayed label to be same, but the field label must be unique.
For an explanation of field types and the formatting choices associated with each one, reference the Understanding Fields Section of the Database Module in the User Manual.
Once you are finished inputting the information for the new field, select “Save” and the new database field will show in the Field Table.
Fields can also be imported in bulk into a Database from a CSV.
How To: Import Fields from a PDF Field Import
{{@340}}
To import field names in bulk from a CSV file, go to the Home Page of the Database Module.
Click the three dot (…) icon to open the context menu of the database you wish to enter fields for.
Select “Fields” opening the Fields for database (DatabaseName) Page.
Click the “PDF Field Import” button opening the PDF Field Import Modal.
To import fields using a PDF, use the “Prepare Form” tool in Adobe Acrobat Pro. Add the fields you wish to use for your form. Add a button on your document.
Use the URL link provided on the PDF Field Import Modal in KAStrack.
Confirm that the Export Format is “PDF The complete document”.
Open the PDF and submit the form to generate the fields here.
You do not need to fill in any of the fields, and you must not sign it.
Select “Allow” and the PDF will confirm that the fields were added to the database.
Go to the Fields Table in the database Monday, and a warning now states that a PDF is associated with the form and that adding/editing or deleting fields may result in the PDF no longer being compatible.
How To: Place Databases into Groups
In order for databases to be placed into groups, groups have to be created first.
How To: Add a Database Group
To add a database group, go to the Groups Page of the Database Module.
Select the “New Group” button opening the New Group Modal.
Input the desired name of the new group and select the “Save” button.
The new group will now show in the Group Table.
When groups have been added to the Database Module, the Database Table on the Home Page is broken into different sections for each group.
To place databases into groups, drag the database group by the directional arrow icon to the left of the Group Name into the desired group table above.
No comments to display
No comments to display