How to Import Libraries in Retool's JavaScript Editor

1// Test in a JS Query — check which libraries are pre-bundled
2console.log('lodash:', typeof _);        // 'object' if available
3console.log('moment:', typeof moment);  // 'function' if available
4console.log('Papa:', typeof Papa);      // 'object' if available
5
6// Use lodash immediately if available
7const grouped = _.groupBy(query1.data, 'category');
8console.log(grouped);

1<!-- In App Settings → Scripts & Styles → Preloaded JavaScript -->
2
3<!-- Load date-fns for modern date manipulation -->
4<script src="https://cdn.jsdelivr.net/npm/date-fns@3.6.0/cdn.min.js"></script>
5
6<!-- Load Papa Parse for CSV processing -->
7<script src="https://cdn.jsdelivr.net/npm/papaparse@5.4.1/papaparse.min.js"></script>
8
9<!-- Load numeral.js for number formatting -->
10<script src="https://cdn.jsdelivr.net/npm/numeral@2.0.6/numeral.min.js"></script>
11
12<!-- Load a custom analytics helper from your own CDN -->
13<script src="https://cdn.yourcompany.com/retool-helpers/v1.2.0/helpers.min.js"></script>

1// Using date-fns (loaded from CDN as dateFns)
2const rawDates = query1.data.map(row => row.created_at);
3const formattedDates = rawDates.map(date =>
4  dateFns.format(new Date(date), 'MMM d, yyyy')
5);
6return query1.data.map((row, i) => ({
7  ...row,
8  created_at_formatted: formattedDates[i]
9}));
10
11// Using numeral for currency formatting
12const totalRevenue = query1.data.reduce((sum, row) => sum + row.amount, 0);
13const formatted = numeral(totalRevenue).format('$0,0.00');
14return { total: formatted };

1// Group orders by status
2const byStatus = _.groupBy(getOrders.data, 'status');
3// { pending: [...], completed: [...], cancelled: [...] }
4
5// Pick only certain columns (useful before sending to a mutation)
6const sanitized = _.map(getOrders.data, row =>
7  _.pick(row, ['id', 'customer_name', 'total'])
8);
9
10// Sort by multiple fields
11const sorted = _.orderBy(
12  getOrders.data,
13  ['status', 'created_at'],
14  ['asc', 'desc']
15);
16
17// Get unique values from a column
18const uniqueStatuses = _.uniq(_.map(getOrders.data, 'status'));
19
20// Flatten nested arrays from a join
21const flat = _.flatMap(getOrders.data, row => row.line_items || []);
22
23return sorted;

1// Format a date from query data for display
2const rows = getData.data;
3return rows.map(row => ({
4  ...row,
5  created_display: moment(row.created_at).format('MMM D, YYYY'),
6  relative_time: moment(row.created_at).fromNow(), // '3 days ago'
7  days_old: moment().diff(moment(row.created_at), 'days')
8}));
9
10// Check if a deadline has passed
11const isOverdue = moment(table1.selectedRow.data?.due_date).isBefore(moment());
12console.log('Is overdue:', isOverdue);
13
14// Add 30 days to today (for default expiry)
15const expiryDate = moment().add(30, 'days').format('YYYY-MM-DD');