default filter value in ui builder

[Peter Xiang]

I have a filter that needs to filter the records of the goal table. Now I need to set the default condition of this filter and set the default value according to the current year. May I ask what value I need to return, because I tried to return the sys_id of fiscal year but it did not work.

[Community Alums]

Hi @Peter Xiang ,

Why are you hardcoding the sysID? you can simply select from the lookup.

[Peter Xiang]

Hi @Community Alums ,

I can choice FY23, but it is hardcoding, i want to set it dynamic, set default values based on the current year, but I don't know how to handle it.

[Dotychczas]

Did you find the solution? Proposing to hardcode it end asking for a like is odd to say the least.

[User5416]

You can use the format below to set up the Default value. Below is an example of a Default value with a data source as the User table:

function evaluateProperty({

    api,

    helpers

}) {

    return [{

        "available": true,

        "empty": false,

        "id": "62826bf03710200044e0bfc8bcbe5df1",

        "label": "Abel Tuter",

        "unknown": false

    }];

}

Note: The Filter type is Single Select.