Forms with dynamic list values

[jonocodes]

I have a form that I want to show different values throughout the use of the app. There is a list that is not static.

Here is example code as it is now:

def get_orgs():
    with pg_engine.connect() as conn:
        result = conn.execute(select(Organizations).order_by('name'))

    return [(o.uuid, o.name) for o in result]

class UsersAdmin(model=Users):
    ...

    form_args = dict(
        organization=dict(data=get_orgs()),
    )

The issue is when the app starts, it calls get_orgs() once. But I want it called every time the UsersAdmin edit/update form is shown. This way if I add an organization and then add a user, the user forms should list the new organization.

[jonocodes]

In case other people have a similar issue, this is my workaround:

class UsersAdmin(model=Users):
    ...

    form_args = dict(
        organization=dict(),
    )

    async def scaffold_form(self) -> Type[Form]:
        # dynamically populate select lists that come from the DB
        self.form_args['organization']['data'] = get_sorted_org_choices()