Adding days by row

i use a custom action to add a row , and clear previous entry text… yes I did see error in my math, so I fixed

1 Like

This is very interesting.
Thanks for sharing. I’ll give it a try and report back soon.

let me know if you need template for that

Thanks, Uzo, I have succeeded.

If allowed I would like to ask is it possible to add these rows to be inserted per phase group?
In my case, it only consisted of two phases, where each new task had to be arranged sequentially in its group in order to produce a continuous timeline bar. What I know is that each addition of a new row is only possible at the end of the table and by using categories for sorting within the application. However, this will create a messy layout in the spreadsheet and cause another problem which is to create the timeline bar again if possible in glide. It will be very useful if there is an insertion of additional rows. Any other suggestions?

I’m also waiting for another solution from @Darren_Murphy . Thank you for your contribution.

You can’t automaticaly add columns in glide, only in gs using scripts, but why you doing this? You can calculate day of the week for those days and put them in just one column, what is the use of doing it this way?

There may be a misunderstanding here. I don’t want to add columns but insert rows. While in the right column it already contains formulas from the spreadsheet (I forgot to remove the red mark).
Sometimes the user can add a row of task items to the first or second phase zone (see the light blue highlight heading). Obviously adding rows is only possible for the second zone (phase 2). I’m imagining how it’s possible to insert the last row of the blue zone above (phase 1). Or should I create in two sheets and combine them into one sheet in G Sheet or something else?
The short is about inserting rows as G Sheet has.

t looks like you are trying to have 2 tables on one sheet, which will complicate any calculations… can you use an additional column just to mark which data belong to which group instead of highlighting rows?

I’d probably write a simple script to reorder the range first by Phase, and then by Start Date.

1 Like

Both phases have continuous dates. While the task item sometimes increases or decreases the number of rows depending on who fills it. While the right area is the timeline bar chart (the phase 2 image is cut off, so it doesn’t appear). Phases are just the division of different stages of tasks. This can be seen as a table or two but continues.

I do not get it. Is this a clue or what are you going to do?

No, it’s not what I’m going to do. It was a suggestion for a simple solution to your row ordering challenge.

I think the fundamental problem here is that you’re trying to keep your Google Spreadsheet as a presentation layer. I wouldn’t do that. I would keep the Spreadsheet as a flat data structure (and keep my users out of the spreadsheet), and build some sort of view of the data in Glide. Admittedly, a gantt chart would be quite a challenge, but still doable.

1 Like

it is very confusing what is your goal in this app, I have a feeling that you have a very wrong approach to this problem… all data should be entered continuously, with timestamps and group indicators… then you can filter them any way you like.

Really hope you can give an example of how to build a Gantt Chart in Glide. Indeed Gantt Chart has complexity and is quite complicated because of its many formulas. I’ve been building this for quite some time and have hooked it into various relationships with tabs in my app. It can be said that apart from the user, the Gantt Chart is the core of my application.
I would like to delegate all of these settings/inputs to a party that is unlikely to touch the spreadsheet. Thank you if you are willing to make some kind of tutorial in the future.

The appearance of the Gantt Chart in my environment is still a lot of people who use it, especially those who are lazy to touch the buttons in the application. Instead of doing double work, so I use it as a schedule base for other purposes. Simply making one change in the Gantt Chart affects other functions in the application. I only adjust to user habits.

you can use progress bar components to create Gantt Chart… and use day conversion for data… so there is no need for multiple columns… or some CSS bars with width and position as variables

Hmmm … interesting to try :thinking:

So far what I’ve been doing is embedding a Gantt Chart with a webview component and a printable/downloadable version with a button. There has been no need so far to create a bar chart in Glide.
In the application, the Gantt Chart version of the spreadsheet, I only took the 4 columns on the left and 1 hidden description column to use as calendar type inline list data. Users are only allowed to edit their contents, not to add or reduce task items.

@Darren_Murphy’s words may be true, I’ll try to think back. Thank you both.

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.