Dashboard

Hi darasabahi, it sounds like your datasource is missing the access_type : offline custom header. It will work without this, but then the refresh token fails. 

Please try reauthorizing the datasource and add the access_type : offline header under the custom auth headers section. 

I created a data source via a REST API connected to the Google Calendar API in Appsmith. As mentioned, however, the data source keeps asking me to reauthorize every few days. It is getting quite boring

Hi almirgarcia, here's a few more that are more advanced:

https://youtu.be/526p9kFhokI

https://youtu.be/GSs8Ds1h6Uw

there is any kind of advance videos for googlesheets?

Great summary on variable declarations in JavaScript! Understanding when to use var, let, and const is essential for writing clean and maintainable code. I found the explanation about block scope and hoisting particularly helpful. 

Thanks Oscar! Glad you liked it. Let me know if there are any other topics you'd like us to cover. 

This post is simply great, and I'm pretty sure it will be useful for anyone starting with Appsmith, and even those who are more advanced, I'll save it to keep it as a reference. Thanks, Joseph

Hi,

Helpful tutorial but...  I'm wondering if you've looked into a similar solution for office 365?  My firm uses that, and I cannot seem to get Appsmith to authenticate as I keep getting "Authentication failure", and can't find the equivalent of a generate an App Password for your Gmail account for Microsoft. 

Thanks!

Great article, but there's one small issue. The behavior of map and reduce is the same as forEach for sparse arrays. All 3 higher order functions skip over empty items.

The result won't be the same as the one shared in the example of map

let sparseArray = [1, , 3, , 5];


// map also skips over empty elements, so it would never call the function for empty item at index 1

// and item at index 3.
let filledArray = sparseArray.map((num, index) => num === undefined ? null : num);


// answer won't be this
console.log(filledArray); // [1, null, 3, null, 5]

// Rather answer would be
// console.log(filledArray); // [1, empty, 3, empty, 5]

Similarly for reduce, it also skips over empty items in an array. So the code shared in it's example can be  changed and it would give us the same result. Please refer the following:

let sparseArray = [1, , 3, , 5];


// function won't be called for empty items.
let sum = sparseArray.reduce((acc, num) => acc + (num || 0), 0);

// So the above function can be changed to this and it will still give same result(9)
// No need to check if num is present or not, as it won't even call the function for empty value.

let sum = sparseArray.reduce((acc, num) => acc + num, 0);

console.log(sum); // 9

I tried this on myself... Below is my results.

Sometimes for of is slower than forEach, Map is definitely slowest. I tested it in a few order for more accurate, but map is always a slowest and results is similar like below.
Tested on Mac Studio M1 Max.

First results:
map: 31.096923828125 ms
forEach: 14.196044921875 ms
forof: 16.885986328125 ms
 for: 6.1611328125 ms
forsepconst: 6.281982421875 ms

Second results:
map: 27.2080078125 ms
forEach: 17.361083984375 ms
forof: 14.570068359375 ms
for: 6.177001953125 ms
forsepconst: 6.3369140625 ms

Third results, with uncommented querySelectorAll:
map: 2184.64697265625 ms
forEach: 2154.363037109375 ms
forof: 2177.132080078125 ms
for: 2176.41015625 ms
forsepconst: 2166.047119140625 ms

{
    console.time('map');
    // eslint-disable-next-line no-unused-vars
    const results = largeArray.map((num) => {
      //document.querySelectorAll('.b-example');
      return (((num * 2 - 5 / 0.5 + 1) * 2) / 3) * num;
    });
    console.timeEnd('map');
  }
  {
    const results = [];

    console.time('forEach');
    largeArray.forEach((num) => {
      //document.querySelectorAll('.b-example');
      results.push((((num * 2 - 5 / 0.5 + 1) * 2) / 3) * num);
    });
    console.timeEnd('forEach');
  }
  {
    const results = [];

    console.time('forof');
    for (const num of largeArray) {
      //document.querySelectorAll('.b-example');
      results.push((((num * 2 - 5 / 0.5 + 1) * 2) / 3) * num);
    }
    console.timeEnd('forof');
  }
  {
    const results = [];

    console.time('for');
    for (let i = 0; i < largeArray.length; i++) {
      //document.querySelectorAll('.b-example');
      results.push((((largeArray[i] * 2 - 5 / 0.5 + 1) * 2) / 3) * largeArray[i]);
    }
    console.timeEnd('for');
  }
  {
    const results = [];

    console.time('forsepconst');
    for (let i = 0; i < largeArray.length; i++) {
      const num = largeArray[i];
      //document.querySelectorAll('.b-example');
      results.push((((num * 2 - 5 / 0.5 + 1) * 2) / 3) * num);
    }
    console.timeEnd('forsepconst');
  }

Does this work in self-hosted community edition?

I'm not seeing an easy way to connect Appwrite to an existing MySQL database.  I see it is discouraged in some of my Googling.  Is this the case?  Should I not use Appwrite as a way to connect to existing data?  

One of these days I gotta jump on to the JSPDF library.  I'm making most of my reports, and it's quite a few, in Custom Widgets.    Thanks, Joseph!

hi！what's the difference between auto-layout before？