Is there a way to schedule an app on server to update its prompts?

[aweiner]

I have an app that has a prompt to select the year. I built it in 2024 using a sql call, so the most recent year in the sql at the time was 2024. Now that it is 2025, the app does not have 2025 in the prompt. The way that I normally fix that is to open the app on designer, run it, and save it, which will add the new year to the selection options. Is there a way to schedule an app to refresh its prompts? Thanks!

[abacon]

What is behind the year prompt? Are you using a dropdown to give the user the option to select and it needs the new year appended?

[CatheyH]

I get around a similar problem currently by having a mini-workflow running alongside/independently of the main workflow. The mini-workflow looks at the data and extracts the years from the result set and puts it in a .yxdb file. That file is then used to create the drop-down. Because it runs alongside the main workflow it is constantly updated. If the latest data isn't in the drop down I only have to run it again and the data has been updated.

If you wanted to include the upcoming year and not have to rerun:

You could also create max year+1, then combine with the data before putting it in the yxdb. (I'd put some conditions on the max year +1 based on the current date - compare it to the current date so that it is only offered when relevant and so that max year+1 is <= current year + 1)