timelined | A customizable CSS-only vertical timeline | Style Language library

I'm trying to add rows based on a specific data received. For now, I've stored that sample data in a constant. My Timeline component is below. YSD is year start date, msD is month start date, dsD is day start date. The same thing for yEd where e is just so for yed, it is year end date. I tried mapping but I'm not getting the data in the correct format.

I'll have an angular service with a function getTimeLinePosts to get JSON from a server. In the timeline-page.ts component I'll subscribe to that function. When sending a request to the server I'll need to send the date of the previous cached response (using ionic cache) to check if there is new data. The problem is the const date returns a promise instead of a value. I'll can't use async getTimeLinePosts because of the subscribe in de timeline-page.ts. Suggestions how I'll can wait for the date before returning the loadFromDelayedObservable?

• timeline-service.ts

I intend to develop a timeline that loads all data / events from a datasource. I am using a dev extreme component to develop the timeline, however the events do not appear on the calendar. What could I be doing wrong?

Can someone help me?

Thank you

Library

DEMO

html

Is it possible to make a timeline like this one with google apps?

I have built an standard web app but there is a problem that there is too many data for whole timeline so it is hard to see some blocks.... I was thinking about zoom option but have no idea how I can do this.

Here you have my code so far:

array from timelineData function looks like that: [["00G080","NA14599","2021-01-08T21:25:00.000Z","2021-01-12T14:22:00.000Z"],["00G080","NA14599","2021-01-12T14:22:00.000Z","2021-01-12T15:19:00.000Z"]...]

gs:

I am using the resourceAreaHeaderContent callback to print some HTML to my resourceArea, including an icon which is supposed to start a function (by onclick) which does some operations on resource sorting, writes them to database and refetches them from the database in the end.

However, if this function is outside the document.addEventListener, I get calendar.fullCalendar is not a function and if the function is inside the document.addEventListener it can't be found, saying Example is not defined.

I think I am missing something about the scope here or the function call from resourceAreaHeaderContent is not correct. I have a codepen at https://codepen.io/craftydlx/pen/RwaqbvL and here is the code:

I have a simple code that, from a range in spreadsheet is taking only elements that ends in a month (I use those data to create timeline in apps-script)

I was able to do everything but at the last moment of the code when I want to push the result to the new final array it is getting weird...

so, Logger.log(newAr[i]) prints out all elements that I want in my new array [HCQ, NC32313, Tue Dec 22 08:25:00 GMT-05:00 2020, Tue Dec 22 08:26:00 GMT-05:00 2020]

then I have this final.push(i); which should insert all elements to new array and everything should be ok I guess..

but then Logger.log(final); gives me this output: [0.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0......] which is nothing like the element above....

Anyone knows why is this happening and how can I fixed it? Below my code:

I want to make a timeline chart based on values in google sheets and I am stuck.... I have no idea what can be wrong. The code seems to be fine but it's just me.

I guess the html side is not reading the array the way it should or it's not getting it at all. In the spreadsheet I have only data that are needed for the chart. timeLineData

I want to pass to the chart data in the same order as it is in sheet. Start and End should be passed as a full date and time (I guess in this format new 'Date(0,0,0,12,0,0)' )

In console I am getting this kind of error:

Uncaught at myFunction (Kod:18)

and this

Uncaught (in promise) Error: Argument given to addRows must be either a number or an array at gvjs_G.gvjs_.Pp (jsapi_compiled_default_module.js:231) at drawChart (userCodeAppPanel:23)

and this

Error An error occurred in the script, but there is no error code: Error: Cannot return an invalid date. at unknown function

The second error is probably because draChart function is not getting the data from the spreadsheet

code.gs

I am trying to make a timeline using google visualization. I found in documentation sample code and it seems like if I will only change the row values it should be fine.

My data looks like this TimeLineData So you can see that I have everything I need to do this.

My problem is how Can I change dates from column C and D

from this: [Thu Oct 29 09:05:00 GMT+09:00 2020] to this: new Date(2020,10,29,9,5,0),

It is needed to put into the row which should look like this: (from the example)

I want to make a TimeLine chart based on data in the "TimeLineData" sheet. Those data will change sometimes so I want to make it dynamic. I am not sure if you can achieve it using regular charts so I have tried with script that I found in google documentation and then got help from @WhiteHat.

In the data sheet Column D and E are not necessary for this project. Only the colored columns. As you can see on the picture I want to group orders by machines and to see time left to the end of production. Column F is showing how much time left in minutes. I also added extra cell for a start date H2 and I2. From the left should be orders with the closest "Out for Delivery" date

So my problem is:

1. how to move data to the left? As you can see on the picture above. I want to make the same start point for all first values in a row and then add next time value. I've tried 'promise()' but coudn't make it.

This is what I am getting now:

Any advice will be helpful! Let me know if something is unclear

The code provided by @WhiteHat: