topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday April 23, 2021, 3:14 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: flat file - with option to go to database - expense ledger  (Read 760 times)

Steven Avery

  • Supporting Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,027
    • View Profile
    • Donate to Member
Greetings.

RIght now I am creating an expense ledger, needs a few fields like project, account, amt, date, note, with the ability to total. Maybe it will expand to link to external 'files'.  This could be a Windows program like Listpro, GS-Base, Filemaker, etc.  Or online like Airtable.  Or bring your own server like MYSQL programs.

There are various levels where this can be done. 

Zoho Creator even has an expense ledger template, and you probably can go fairly far free. So far I enjoy it the most, as simplest to run and go.

Correction:  It is AIRTABLE that has a nice starting Expense Ledger.

Your thoughts?
« Last Edit: March 01, 2021, 02:35 PM by Steven Avery »

sphere

  • Participant
  • Joined in 2018
  • *
  • default avatar
  • Posts: 117
    • View Profile
    • Donate to Member
Re: flat file - with option to go to database - expense ledger
« Reply #1 on: March 02, 2021, 10:28 AM »
Sounds interesting.   When I think ledger I think spreadsheet.  Excel/Open office variants are vary powerful tools. I think this is one of the things airtable leverages.
This is not my area of expertise, but I am curious if you are familiar with Microsoft's Power BI, Power Query,  or Excels "get and transform data" features?  It might be nice inspiration, if you are not already familiar with it.  These are ways you can link, utilize and "transform" data from a  variety of sources.  It can be really helpful if you need to transform a flat cvs file.  Open source office applications have similar query features as well.

I believe Office 2013 has "get and transform" data as a addon (I think it is free)
Office 2016 and beyond have various flavors built in under the data tab.
Currently, Microsoft Power BI Desktop can be installed and used free locally.

There is a big move currently to be able to free and transform data from its silos. It is a good thing.

Steven Avery

  • Supporting Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,027
    • View Profile
    • Donate to Member
Re: flat file - with option to go to database - expense ledger
« Reply #2 on: March 10, 2021, 07:20 AM »
Thanks Sphere.

I used Airtable (Online) for the expense ledger, using their template, which I modified.  So far, fine.

And I used ToDoList (Windows) for a quick list of 11 Greek manuscripts (for the heavenly witnesses) and features.
One nice advantage to online spreadsheets, subfolders.

Now I am looking for one for a couple of hundred entries relating to Bible verse evidences.

Note this incredible review page for online bases.

Online Filemaker alternatives: Coda, Zoho, AppSheet, AppGyver, and more
Maria Korolov
https://www.mariakor...emaker-alternatives/

« Last Edit: March 10, 2021, 08:20 AM by Steven Avery »

sphere

  • Participant
  • Joined in 2018
  • *
  • default avatar
  • Posts: 117
    • View Profile
    • Donate to Member
Re: flat file - with option to go to database - expense ledger
« Reply #3 on: March 10, 2021, 04:53 PM »
Note this incredible review page for online bases.

Online Filemaker alternatives: Coda, Zoho, AppSheet, AppGyver, and more
Maria Korolov
https://www.mariakor...emaker-alternatives/

« Last Edit: Today at 08:20 AM by Steven Avery »

-Steven Avery (March 10, 2021, 07:20 AM)
That is an impressive list.   Verry impressive.

When I think of flat, I think of plain text or as close to it as possible.   I avoid hosted SAAS solutions but I get I get the appeal of of these.

An airtable alternative that is open source is baserow. https://baserow.io/
https://gitlab.com/bramw/baserow
I believe I have seen some similar products that use a git as the backend as well.

I have had my eye on anytype which has a similar look to notion.  After making a big splash there was some silence, but it seems to have picked up production.
https://www.youtube..../watch?v=hblHWfXA3XU

Good luck on your search.


Steven Avery

  • Supporting Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,027
    • View Profile
    • Donate to Member
Re: flat file - with option to go to database - expense ledger
« Reply #4 on: March 11, 2021, 10:59 AM »
Very nice, thanks.  Baserow especially might be like an online Listpro or GS-Base (Windows). AirTable simplified.

One question.  ToDoList allows easy-peasy folding up subfolder.  So if you have 10 whatevers underneath, they can fold up.  I don't see this in Airtable. And in general, I think it would be one of the primary questions for any tool, online or Windows. Your thoughts?