Forum Discussion

ladyck3's avatar
ladyck3
Copper Contributor
Dec 28, 2022

Needing advice as to which app to use to create a data input resource.

I've never used this resource and I'm not sure I'm doing this right, it doesn't seem to be posting. Background: I used to be considered and expert in Excel by my co-workers.  I was not, but I knew ...
excel
ladyck3's avatar
ladyck3
Copper Contributor
Jan 03, 2023
Thank you for your response, I agree that after some more playing around, I too think that Excel is my best bet. What I mean by a "Cover Sheet" is more of a graphical worksheet or front page where data can be entered in fields "like a database interface". However I have played with Data Validation > Lists and am liking that. Addition of new records would simply appending to the master list.

Regarding sharing my Excel Workbook, I completely understand your desire, to see the data but I'm not comfortable with that, there is too much information I do not wish to share. But thank you!!! Truly. I think that my journey is on a good start after giving it weeks of thought... so I'm going to carry on, right now, on my own.
If I get into trouble, then maybe I'll truncate the data and consider uploading at a later date.

Sincerely and HAPPY NEW YEAR!
Laurie
mathetes's avatar
mathetes
Gold Contributor
Jan 03, 2023

ladyck3 

 

I completely understand your desire, to see the data but I'm not comfortable with that, there is too much information I do not wish to share.

 

Just to be clear, it's not the data that I wish to see; it's how the data are arrayed. How you've organized the database. So yes, if and when you do post it, an "anonomyzed" version would meet the need entirely.

 

I think that my journey is on a good start after giving it weeks of thought... so I'm going to carry on, right now, on my own.

 

And doing it on your own is the best way to learn (or, in your case, to re-learn) Excel. Best wishes in this new year.

  • ladyck3's avatar
    ladyck3
    Copper Contributor
    Jan 03, 2023

    mathetes 

     

    You Stated:
    Just to be clear, it's not the data that I wish to see; it's how the data are arrayed. How you've organized the database. So yes, if and when you do post it, an "anonomyzed" version would meet the need entirely.

     

    My Data (which is the format the report from my resource online is formatted upon receipt)
          I will share the data as best I am able to with generic info.... and I hope this
         Copy/Paste works properly. 🙂 Picture these of course, horizontally on a
         spreadsheet, currently 4,892 records and grows daily.

    ID: 1
    Type: There Are Several types
    Title: Pattern name
    Author: Jane Doe
    Publication date: 2022-12-20
    Receipt: Link to receipt 

               (I added this myself not on the report, I have to go back
               and find all of these links manually.  <sigh>)
    ISBN: Some have an ISBN
    Notes: Actually a MEMO as some are more than 255 characters
    Date added: 2022-12-25
    Resource link: URL to Actual Download Page in Resource Online Library

     

    I hope this suffices for the data you were requestion...its generic but its the structure I'm using.  

     

    Thanks for playing 🙂

    Laurie

     

Resources