I currently have a CD and LP database that uses a NOTES field to capture track listings along with each song’s running times. Ex: Trackname 1 (3:15), Trackname 2 (6:01), Trackname 3 (2:59), and so on. I then have secondary NUMBER field that displays the total running time for each CD or LP based on the sum of those times. Ex: Total Running Time 01:23:44 (hrs/min/sec). At this point, I am manually totaling those times and entering them into a separate number field.
Is there a way to set up a Time Calculation field that will reference a running times in a Notes field (they appear to be recognized, as they are highlighted in blue) in the same database, auto-sum the totals, and place the results in a different field? And if so, how do i do that?
Thanks,
Dean
Hi Dean,
You would need to create a Link to Form field or a Table field that contains each track and their running times separately. Then you can have Tap Forms display the total at the bottom of the list of child records. You can also then use a Calculation field to get the total of the running times from the Running Time field in the Link to Form or Table field.
But you can’t have Tap Forms total up values from within a Note field. Not unless you want to use the new Tap Forms 5.3 beta and write some JavaScript code to parse your Note field and extract out the data. But that seems like a lot of work.
Thanks,
Brendan
.
