Open davidjoshuaford opened 2 years ago
One more discovery - the "timestampValue" field in Notion needs to include the full time format, ie, instead of 2:51, it needs to be recorded as 00:02:51. Otherwise, when you have a show that logs over an hour, the column cannot be sorted in ascending order.
I would like to add a +1 to the interpretation of variables. This was the first thing i tried as we have a couple of recorders that send their timecode to companion. If we could send over that data to notion to create a specific timecode marked by the recorder that would be amazing.
Would love to see more dev on this. And to add to my previous comment from August, here's a screenshot of the timestampValue column that needs unified data format:
Just discovered this module it is a great solution for our studio as we just started using Notion for our note taking. Support for variables within the Database Field and Message field would be great. Any timeline on these developments?
Hello again! I find myself back here wanting to make the most of this great module but limited by interpreting custom variables. I found the Notion module to be much more reliable than the Google Sheets module, but also limited in functionality.
Here are some suggestions to make the default data sheet results easier/faster/more useful to work with:
• Move "timestampValue" to first column • Default assort by "ascending" • Unify the number of digits (00:00:00)
• Move "message" column to 2nd column • Enable interpreting Custom Variables within the spreadsheet title and the message fields
Making these changes will make it much faster to copy and paste the time and message fields into YouTube Comments to automate chapter markers.
With companion v3 imminent now we are on rc1, is it possible to get this module updated for v3?
@davidjoshuaford I saw your livestream a week or so ago talking about this module and your desires so I upgraded it to v3 and was able to add the ability to use variables for the database name and messages as well as added the leading zeros to the hour. The changes are in the latest beta. Could you test it out and let me know if it is working as you wanted it to?
Amazing, thanks @digitaldrummerj I'll take a look!
Hi @digitaldrummerj ,
Your changes are working well! The variables now read out from the marker's message field, and the session title. This makes the module much more powerful, so thank you!
Would love to see points 2 and 4 from the original post developed, and here is an additional idea for the default layout in relation to my point 3 about default layouts:
This would provide an alternate mode of timecode tracking for productions (kind of like Free Run timecode). If production cameras are using timecode based on time of day, then these notion fields can be traced back.
@davidjoshuaford I can attempt the rest of the request but I won't be able to look at it for a few weeks. It might take me a bit since I had never used this module before seeing your live stream but thought it sounded easy enough to implement and I wanted to give it a try as a way to say thank you for the wonderful Companion profiles that you have created.
@digitaldrummerj no problem, thanks for the excellent work implementing the variables!
Hi Darin,
Great work on this module - I see a lot of potential for it.
I have 4 suggestions for improvements:
(In Companion Actions) For the text fields for the Marker message and the Start Session text field, make the text interpret variables. For instance, "$(internal:time_hms)" in the companion text field would stamp "13:49:03" etc into Notion. Or it could read a button title text, or a Social media comment text. This would make a long list of markers useful and distinct.
(For YouTube Chapter Markers) Have an easy way in notion to update the "start" marker, that will calculate and cascade the subsequent timestamps. For instance, say you start a session during your "Preshow" set up time, and Notion begins at 00:00:00. When you press "Go Live" on YouTube, now YouTube is starting it's own duration clock from 00:00:00. After the live show, we need an easy way to calculate the difference between the Notion start time and the YouTube start time, that will cascade the subsequent markers. This would look like being able to subtract an amount of time from a marker and it casscade through.
I suggest the first column be the "timestampValue" column in ASCENDING sort order, and the second column be the message column, where new timestamps are placed on the bottom. This will make it easy to drag a marquee and copy and paste Chapter content to YouTube description.
(In Companion module Feedback) Incorporate feedback variables (to change background color, text, text color, PNG, font size etc) that show Session Active, Session Inactive, Session title, perhaps the last recorded timestamp/message content, and feedback for the number of rows/entries that have been made in an active session.
Thanks for your work!
David