How-to questions
Hi! Don’t forget to take a look in the Knowledge Base for answers to common questions :)
-
Count working hours
I need to count working hours in the range defined by "Start" and "End" fields. Both fields are Date and Time format. The working day lasts from 7 AM till 3:30 PM. I need to count time only from this range. Overtime and weekends should not be included. I can start and end work any day at any time.
weekdays() function counts only days, datedif() function includes all 24 hours and weekends.
Any ideas?3 votes -
Inventory App
The legacy Trackvia had an example of an Inventory App. I would like to build a similar one where my employees can keep track of inventory of products in their area so that on a single dashboard, in real time, the supply manager knows when levels of certain products go below par levels. Any ideas?
1 vote -
sum a specific column when the child record is in a specific location
I have a table where users can select a parent record in more than one location. For example, a child table, "work order" contains both "Service 1", and "Service 2" links to the "services" table. Each linked service has an associated quantity column in the "work order" table. I have tried using the sum function in the "services" table to sum the total services entered but when I sum the "service 1 quantity" all of the values in that column are added regardless of whether the service was a parent record in the "service 1" link or in the "service…
1 vote -
Export (and import) forms configuration
In our compagny, we are certified ISO 9001 so we have to handle change management.
We already have a functionnal systems to manage changes. If we were able to export the configurations of the forms in trackvia, we woud complie with the norm.So any format for the export would be nice as long as we can :
* import it on an existing form or a new one
* export it from an existing formThe best would be to have it in a human readable format like XML or JSON
3 votes -
invoice
Create an invoice (pdf) directly from TrackVia
9 votes -
Sort by name in Calculated field?
Is there any way to alphabetize text in Calculated field? I have Calculated field with formula: childconcatenate({Projects}.{Lead}.{Project Experience}, "\n"). How can I sort those "Project Experience" fields from Projects table?
1 vote -
Copy the linked field to text
I have a contracts table and in it, users will select a child company from the linked child company table.
I am trying to create a client contacts form that will automatically populate the selected child company(ies) in contracts in the associated client contact field
Can you tell me how? Or is there a way to create a second column that will do something like linked record = linked record text
1 vote -
Create links within Manufacturing Work Instructions that automatically populate the correct TrackVia picture entry
I work for 3D systems. We manufacture 3D printers and use TrackVia in multiple ways, but on of them is to take pictures throughout the assembly process using Android Tablets for accountability and quality purposes. Currently, assembly line workers read paper work instructions, and only use the tablets for TrackVia. We want workers to be able to use the tablets to follow work instructions. Within the instructions, we would like for workers to be able to click a link that would take them to the appropriate TrackVia picture entry form. I'm not sure if this can be done being that…
1 vote -
How do I set up an email alert in the future?
Can I set an email reminder for 1 week from today? Or, an email reminder on the designated date of a future task (record)?
Thanks.4 votes -
return the previous month's record
I'm uploading invoices into our table. Each entry in the table will list the date run, the company name, qty and subtotal. I also want to add a column that populates what the previous month's qty was, so i can add an additional column that calculates the variance.
Can someone help me with what the formula would be to return the previous month's qty?
Thanks in advance
1 vote -
See ALL active notifications in ONE place.
I would find it extremely helpful to have the ability to see ALL active notifications in one place.
I imagine a notifications tab/page categorized by tables, that shows all underlying views with active notifications -each view having the ability to expand and show all associated notifications, and each notification having the ability to expand and show all users receiving that notification.7 votes -
Sending/sharing/emailing a record or scheduled report as an attachment
Hello,
I work for a healthcare organization. One of our departments uses TrackVia on a near daily basis. We have very recently upgraded from the classic version to the Enterprise+ version.
Is there any way that we can use the "Share Record" feature, but instead of TrackVia printing out the data in the body of the email (the users have told me this can't be done for HIPAA reasons), the data can be sent as an attachment? Either a Word document or .csv or Excel spreadsheet is fine; it's just for our purposes, we cannot have the data printed out…
7 votes -
Saving a new record - default form fails to load
I have created a form for users to enter new records into a table. The form contains the specific fields they need to work with. I do not wish to grant the user access to the "default form" as there are fields in there I do not wish to grant them access. When a user enters a record and they hit save they are presented with a "permission denied" alert. The record does save.
Best I can tell, trackvia always loads the "default form" after a new record is saved. Is this accurate? Is there any way to change this?
…
1 vote -
How can I share a dashboard?
I have several tables and views saved within one rolled up dashboard. I would like to share this dashboard via email weekly with our team. Is there a way to share dashboards? Or does anyone have a creative idea for sharing more than one view?
10 votes -
How do I export a view to a PDF?
I would like to export a record to a PDF in a specific form. I would like the PDF to be editable.
8 votes -
Needs an array field that accepts any concatenated data
Needs an array field that accepts any concatenated data, for use with zapier to export child records
6 votes -
Calculating Task Completion Time
I am looking for a way to capture how long it takes a user to create a record.
Does TrackVia stamp when a Form is opened? If so, then I can use this value in a datedif formula against the record Create Date/Time to see how long it took to open the form, key in the information, and click Save.4 votes -
export document field
Is there a way to download all of the documents for a table? An export gives me an excel file and one of the columns in that is the name of the document in that field but I need a way to get all of the actual files. Is that possible or do I have to go through one by one and download them?
6 votes -
Font sizes in Forms
The knowledge base says "Next, if you wish to further customize your form, click the pencil icon in the upper right corner of any field or section. From here, you can edit the title, and the font and background colors. " But far as I can tell, there are not font style or size controls. Does this mean that I cannot change the size of the fonts in form fields? Seems like a really basic feature.
3 votes -
Section Headers on Dashboards
I would like to be able to add a Section Header on dashboards. For Example: a current dashboard may contain data for 3 different pieces of data that belongs to one site. I want to be able to TITLE the sections - Section 1, Section 2, Section 3, so that when paging down the dashboard there is a specific division between the data.
The issue is that if I create a dashboard for each site with each piece of data I will have 18 different dashboards and that's just unwieldy to manage. Also, only 4 + 1 tab shows across…
3 votes
- Don't see your idea?