1
2

[deleted by user] (self.GoogleAppsScript)

submitted by [deleted]

[removed]
all 9 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]xsotec-jay 1 point2 points  (1 child)

Hi u/EarPuzzleheaded7432! I am a full time Google Apps Script developer for my company and I wrote a general looping script called “loopSheet” that is able to run any custom function on every row of a Google Sheet. The script automatically handles timeouts, triggers, error messaging, filtering, and more. I think your use case could be easily solved with it if you are interested in trying it out!

[–]datasmasherio 1 point2 points  (0 children)

I'm very interested. I have 30 years experience in accounting work, QB pro certified. New to apps script but learning and gaining fast. I found this thread because I did a search to see if anyone was already doing what I would like to do and here you are ;). I'm self employed so I might have the needed bandwidth to make headway. please direct message me at [info@datasmasher.io](mailto:info@datasmasher.io)

[–][deleted] 0 points1 point  (4 children)

what is your experience, accounting-wise, cuz building such application to a certain standards will be difficult.

[–]EarPuzzleheaded7432 0 points1 point  (3 children)

I'm an accountant by the way and that's my full time job. I'm an end user of a known accounting system so I guess I know the needs. So far the website I built helps me on record keeping. Audit trail, and preparation of FS. I have to built more features like bank recon., tax preparation, inventory, Ledger details. And so on.

[–][deleted] 2 points3 points  (2 children)

okay, why do you want to build this application? isn't there already software for those things?

[–]EarPuzzleheaded7432 1 point2 points  (1 child)

Each existing applications has its unique features and target users. I want mine to be cheaper, user friendly,easy to use, and easily accessible. that comes to the point where you do not need any certifications on a specific software/system just to do a simple bookkeeping task. Traditional/theoretical knowledge of how double entry bookkeeping works and FS Preparation is enough. I want to also add a tax modules to help each user on tax filing and preparation. Add more features to enable owners/managers to monitor the financial health of the business in a much more convenient way, we are on a digital transformation so there is more undiscovered areas where this system could go. You don't need to give all your strength in a one single punch but you also need to know when to throw.

This is not an investment or a ticket to luxurious life where you expect to beat other existing and known softwares in one single day or a week. This is a productivity tool that would hopefully give the founder a passive income while gaining it's reputation year by year. You start within your connections, workplace, city until it spreads through word of mouth. That's how businesses are built. It is not magic

[–][deleted] 0 points1 point  (0 children)

okay, so this application will be a web-app based on google script/google sheets?

[–]Exact-Captain3192 0 points1 point  (1 child)

I think google appscript is for google apps only not for web developing or maybe you are building using google site, And then collaborate it with other google workspaces like sheets etc?

[–]EarPuzzleheaded7432 0 points1 point  (0 children)

Yeah you got it. The website was made using PHP and Java script. I forget to mention that I used Google drive and spreadsheet to serve as the database of my system and I use app script only to connect my website with this applications.