Populate table with data range

App Building
1

Hi,

I have 2 datapickers (only date) start and end.

How can I popupate a table with all date range from start to end

excuse me for my english.

image
image469×525 11.8 KB

2

Hey renatoR! Welcome to the community :-).

Can you please reword your question? I'm not sure I get what you're trying to achieve.

3

when the client clicks on the run button, I want the table to be updated with all the dates from start to end

4

Using this code Stackoverflow, something like this should work;

let fromDate = moment(dateSelectorFrom.value)
let toDate = moment(dateSelectorTo.value)
let diff = toDate.diff(fromDate, 'days')
let range = []
for (let i = 0; i < diff; i++) {
  range.push(moment(fromDate).add(i, 'days').format('YYYY-MM-DD'))
}
return range
5

Thank you @jonathanbredo ,

sorry, but why the table does not populate?

Capture
Capture1892×980 98.6 KB

6

Hi @renatoR,

It looks like the table is set up properly :thinking: Can you try running the JS query again? How is the JS query triggered in the app?

7

In this moment I run the query manually

9

If you wrap it into the column like this, a table populates;

let fromDate = moment(dateSelectorFrom.value)
let toDate = moment(dateSelectorTo.value)
let diff = toDate.diff(fromDate, 'days')
let range = []
for (let i = 0; i < diff; i++) {
  range.push(moment(fromDate).add(i, 'days').format('YYYY-MM-DD'))
}
return {date: range}

I recommend that you play around with Retool's table component and how it works with columns, as this will help you build really cool experiences in Retool :-).

2 Likes
10

Ah, right! Thanks @jonathanbredo :slightly_smiling_face: