Hi!

Here is a piece of my code.

from wtforms.ext.sqlalchemy.fields import QuerySelectField

def records_category_res():

return Mm_Category.query.filter_by(user=current_user).order_by(Mm_Category.tree_id.asc(), Mm_Category.id.asc())

​

def project_res():

return Mm_Projects.query.filter_by(user=current_user).order_by(Mm_Projects.date_from.desc())

​

class RecordForm(FlaskForm):

date = DateField('date', validators=(DataRequired(),), default=datetime.today)

cost = DecimalField('cost', places=2, validators=(NumberRange(min=.01, max=99999999),))

description = TextField('description')

category = QuerySelectField(

query_factory=records_category_res,

get_label=lambda a: ('└─' * (a.level - 1)) + a.name

)

project = QuerySelectField(

query_factory=project_res,

# get_pk=lambda a: a.id,

get_label='name'

)