I have a table that tracks costs incurred at different dates and I’m trying to make a report with the script block that lets the user select a week number witch will then show only show the costs incurred in that week.

I have formular field on my view that converts the date to a week number.

I tried to filter a RecordQueryResult

let weekSelector=r]

        

        for (let record of costQuery.records){

            let week = record.getCellValueAsString(costWeekField)

            

            let personId = record.getCellValue(costStaffField)d0].id



            if(!weekSelector.some(obj => {obj.getCellValueAsString(costWeekField) === week})){

                weekSelector.push(record)

            }

        }





        let weekSelect = await input.recordAsync('Choose a week', weekSelector)

However that does not work, as the primary field does not show my costWeekField.

I tried to make just an array of week numbers, and put into.recordAsync, but as it’s not a record it does not work either.

Is there a way to make a list based off a field in my table. Fx all unique week names from a certain field and let the user select from one those?