v1.3
Core Concepts
Datasource Reference
Framework Reference
Widget Reference
Cheat Sheet
This document contains a list of handy JS snippets that are used across applications. The snippets are not meant to be plug and play but indicative of the way code can be written to achieve the desired outcome
Table Data
Access an inner array object
1
{{ fetch_users.data.users }}
Copied!
Transform an array of data to a cleaner format
1
{{
2
fetch_users.data.map((user) => {
3
return {
4
name: user.name,
5
age: user.age,
6
status: user.status === 1 ? "Approved" : "Rejected"
7
}
8
}, 0)
9
}}
Copied!
Chart Data
Transforming aggregate data
1
{{
2
fetch_user_stats.data.map((stat) => {
3
return {
4
x: stat.name,
5
y: stat.count
6
}
7
})
8
}}
Copied!
Aggregating data where the x values are fixed
1
[{
2
"x": "Approved Users",
3
"y": fetch_users.data.reduce((acc, user) => {
4
return user.status === 1 ? acc + 1 : acc
5
})
6
},
7
{
8
"x": "Rejected Users",
9
"y": fetch_users.data.reduce((acc, user) => {
10
return user.status === = ? acc + 1 : acc
11
}, 0)
12
}]
Copied!
Default Date
Setting the default date to yesterday
1
{{ moment().add(-1, "days") }}
Copied!
Filepicker
The below code converts a CSV file uploaded to an array of objects
1
{{
2
function() {
3
const csvRows = FilePicker1.files[0].data.split("\\n");
4
const objArr = [];
5
const headers = csvRows[0].split(',');
6
for(let i = 1; i < csvRows.length; i++) {
7
const rowObj = {};
8
objArr.push(rowObj);
9
const rowArr = csvRows[i].split(',');
10
rowArr.forEach((val, index) => {
11
rowObj[headers[index]] = val;
12
});
13
}
14
return objArr;
15
}()
16
}}
Copied!
Navigation
Sending data via query params
1
{{ navigateTo("Page1", { id: Table1.selectedRow.id }) }}
Copied!
Opening External Web Pages
1
{{ navigateTo("https://appsmith.com") }}
Copied!
Chaining Actions
Running Queries on success and showing errors on failure
1
{{
2
Query1.run(() => {
3
Query2.run();
4
}, () => {
5
showAlert("Query Failed")
6
})
7
}}
Copied!
Running APIs/Queries in a loop
Fetching all the details of every user in the table and storing it
1
{{
2
function() {
3
for(let i = 0; i < userTable.tableData.length; i++) {
4
fetch_user_details.run((response, params) => {
5
storeValue(params.userId, response);
6
}, () => {
7
}, { userId: userTable.tableData[i].id })
8
}
9
}()
10
}}
Copied!
Last modified 2mo ago
Copy link
Edit on GitHub