Dashboard

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？

Thank you for this amazing post. I normally work with APIs as a data source, but is good to have this document as a reference whenever I will need to work with SQL databases.

Thanks, Joseph, I wanted to share the Custom widget in a way anyone can take it as it is and implement it quickly, that is why I took the time to build it like a "complete" solution. 

This is awesome! I like that you included the other widgets to build new events, instead of just publishing the custom widget by itself. That would have been enough, but this is even better! 

Do map and reduce have the same performance overhead relative to a basic for loop?

The difference in behavior for undefined elements in the array is a deal killer, however. 98% of the time, developers will fail to remember this issue, even if they read about it before.