From Excel to Webapp directly ? (loom Excel project video)

FLOnocode · 2024-08-16T07:51:18.777+00:00

Good morning,Currently I am working on a budget excel file that looks like this with various relationships and formulas.I would like to have a webapp to view and interact with the Excel file.The idea that I would like to report the data on (column, row) directly in the webapp which will be a kind of big financial tracking dashboard.The main objective is:Facilitate access to data, enable dynamic visualization, improve real-time collaboration.→ Here is a little demo (I am not a native English speaker so excuse me in advance for my English)https://www.loom.com/share/87c59cd43f61435c9ee21eb83dd3f69aSo several questions that I would like to have answers to.1. Is there a direct connection between toddler and Excek for automatic data synchronization?2. How are real-time updates managed?3. How does Toddle manage the security and privacy of data from Excel?4. What are the potential limitations to be aware of when integrating with Excel?Thank you in advance for the feedback.Ps: I would certainly have other questions based on your feedback.A+

FLOnocode
1 year ago
Good morning,

Currently I am working on a budget excel file that looks like this with various relationships and formulas.

I would like to have a webapp to view and interact with the Excel file.

The idea that I would like to report the data on (column, row) directly in the webapp which will be a kind of big financial tracking dashboard.

The main objective is:

Facilitate access to data, enable dynamic visualization, improve real-time collaboration.

→ Here is a little demo (I am not a native English speaker so excuse me in advance for my English)

https://www.loom.com/share/87c59cd43f61435c9ee21eb83dd3f69a

So several questions that I would like to have answers to.

1. Is there a direct connection between toddler and Excek for automatic data synchronization?
2. How are real-time updates managed?
3. How does Toddle manage the security and privacy of data from Excel?
4. What are the potential limitations to be aware of when integrating with Excel?

Thank you in advance for the feedback.

Ps: I would certainly have other questions based on your feedback.

A+
Max
1 year ago
Hi! Here are my answers 🙂

1. No. You can do it, but you would have to call the Office365 API. Not a trivial task
2. You have to do that. No matter which backend you use, it is up to the developer (for now) to implement that yourself
3. It does not
4. Using Excel as a backend is not a good idea. For a proper web app, you need a proper backend (database, authentication, authorization, business logic etc...). Excel does not provide any of that. I recommend that you take a look at real backends like Xano or Supabase
👍1
Tom Ireland
1 year ago
Max answered that pretty succinctly. Might also be worth teaming up with folk interested in this area. I know @SpaceMan is looking at fintech app building regarding finances. The undefined channel is good for posting ideas on stuff you might want to team up on, share learning, etc.
👍1
@Tom Ireland
Max answered that pretty succinctly. Might also be worth teaming up with folk interested in this area. I know @SpaceMan is looking at fintech app building regarding finances. The undefined channel is good for posting ideas on stuff you might want to team up on, share learning, etc.
Max
1 year ago
More often than not I learn new English words from your messages 😅
😆1
@Max
Hi! Here are my answers 🙂

1. No. You can do it, but you would have to call the Office365 API. Not a trivial task
2. You have to do that. No matter which backend you use, it is up to the developer (for now) to implement that yourself
3. It does not
4. Using Excel as a backend is not a good idea. For a proper web app, you need a proper backend (database, authentication, authorization, business logic etc...). Excel does not provide any of that. I recommend that you take a look at real backends like Xano or Supabase
FLOnocode
1 year ago
All right. Thank you for returning to my various interrogations.

So the first step I should do is more of a bridge between my formulas and giving Excel to a backend?

I'm much more comfortable with the front end and the backend it's a pretty big mystery for me between what is achievable or not.

Should I keep this type of project for Excel or are there possible solutions for my nocode project with your vision and knowledge of the backend.

Thanks for the feedback
@Tom Ireland
Max answered that pretty succinctly. Might also be worth teaming up with folk interested in this area. I know @SpaceMan is looking at fintech app building regarding finances. The undefined channel is good for posting ideas on stuff you might want to team up on, share learning, etc.
FLOnocode
1 year ago
Thank you for taking part in the conversation and providing information from people who are in finance-related projects.

Afterwards I wouldn't go as far as fintech but I have quite a few projects starting in excel tracking finances, budgeting etc.

I'm hoping to find a project that will make me go very in-depth into webapp tools
@FLOnocode
All right. Thank you for returning to my various interrogations.

So the first step I should do is more of a bridge between my formulas and giving Excel to a backend?

I'm much more comfortable with the front end and the backend it's a pretty big mystery for me between what is achievable or not.

Should I keep this type of project for Excel or are there possible solutions for my nocode project with your vision and knowledge of the backend.

Thanks for the feedback
Tom Ireland
1 year ago
You can think of a database as being similar to excel with tables, columns and rows. If you're not familiar with backends, maybe have a poke around in the undefined channel for recommendations. Most (if not all) have an API that can easily be leveraged from the front end in toddle.
FLOnocode
1 year ago
Thanks you @Tom Ireland for your return, its really helpful
🙏1
Tod
1 year ago
Great energy @FLOnocode! Your continuous contribution to the toddle Community just made you advance to Community Level 1!
Tom Ireland
1 year ago
To add (as I saw your message in the 💬・general channel), you would use the database store most of your raw values and then use toddle (front end) to do the data manipulation, which would make it more powerful than using Excel.
@Tom Ireland
Max answered that pretty succinctly. Might also be worth teaming up with folk interested in this area. I know @SpaceMan is looking at fintech app building regarding finances. The undefined channel is good for posting ideas on stuff you might want to team up on, share learning, etc.
SpaceMan
1 year ago
Thanks for the mention @Tom Ireland and mentioning about the ⁠lfg channel. I just posted my project idea there and looking forward for some interesting collabs.
https://discord.com/channels/972416966683926538/1274082031009271808
🙌1
Tod
1 year ago
Great energy @SpaceMan! Your continuous contribution to the toddle Community just made you advance to Community Level 2!

From Excel to Webapp directly ? (loom Excel project video)

FLOnocode

Max

Tom Ireland

Max

FLOnocode

FLOnocode

Tom Ireland

FLOnocode

Tod

Tom Ireland

SpaceMan

Tod