0

import duration values from Google Sheets

Hi

New to Ninox but not databases. I have a sheet in GS with titles & durations of musical scores. The format are 00:00:00 (hours,minutes,seconds) how can I import those values to Ninox?

Any help much appreciated! ;-)

8 replies

null
    • Mel_Charles
    • 6 mths ago
    • Reported - view

    Ninox has the following Date Field,  Date & Time Field and Time Field.

    So you want the latter! plus the Ninox import routine

    • Mel_Charles
    • 6 mths ago
    • Reported - view

    sample record imported

    and here it is on the table

    • Mel_Charles
    • 6 mths ago
    • Reported - view

    Make sure you set the field format before you do the import tho... :-)

      • fuchsia_balloon
      • 6 mths ago
      • Reported - view

       Hi
      Thanks a lot for your answer! Can I ask another question?
      My purpose is to build a database over all my choir arrangements - I'm a musical director - and then create a plan for the choir I conduct to make assure that we will rehearse the selected songs in good time before the Christmas concert. So something like this: "Date: 23rd of October: "Jesus Bleibet Meine Freude", "White Christmas" , "Hallelujah".
      Date 30 of October: "Jesus Bleibet Meine Freude", "Merry Christmas", "Rockin' Around The Christmas Tree". So basically a song in the base will appear on several dates in the Choir Calendar.
      I hope you understand.
      Any help much appreciated!
      Regards Stig Christensen MUSICMIND 

      • Mel_Charles
      • 6 mths ago
      • Reported - view

      sc What - like something like this? I've only a very done a rough sample DB

      Your diary dates will appear in the calendar. I guess you could enchance it quite nicely

      Ensure you sing some Handel tunes (my favourite composer - especially his Concerti Grossi and Organ Concertos!)

      Kind regards

      Mel

      • fuchsia_balloon
      • 6 mths ago
      • Reported - view

       That's fabulous! And the Harold Darke arrangement sounds good.
      Thanks a lot!

      • Mel_Charles
      • 6 mths ago
      • Reported - view

      sc You are welcome Stig - Anytime 🙂

      Yes the HD arrangement is both beautiful & moving. 

      https://www.youtube.com/watch?v=yb9tHjuy9Hw (Organ Accomp)

      https://www.youtube.com/watch?v=AfqHoX5ycTc (Strings Accomp)

      If you need further help just shout - There are some very dedicated and much more talented people that be willing to help you.!

      • fuchsia_balloon
      • 6 mths ago
      • Reported - view

      Thanks a lot!

Content aside

  • 6 mths agoLast active
  • 8Replies
  • 63Views
  • 2 Following