# What's the best way to create a truly dynamic input template?

Always looking to improve our templates - we still have duplication of templates because we haven't found a great solution to truly dynamic rows (account codes that change based on Choose criteria) AND dynamic columns

##### Post Metadata
- Posted at: about 6 years ago
- Net upvotes: 1


## Comments
### Comment 1

You have to map the choose options as their own measures and in a separate block. They have to be able to return independently from the the dimensions their choices determine.

##### Comment Metadata
- Posted at: about 6 years ago
- Author title: Director of Financial Systems  at Campus Advantage
- Net upvotes: 1

#### Reply 1

I'm not sure what your second sentence means. Could you elaborate more or illustrate with an example? In our case, we want to have separate Department Choices infer different parent level account code hierarchies. For example choosing Dept 1 will have mapped accounts 1000-2000 in rows 1-10 in the template while choosing Dept 2 will have mapped accounts 2000-3000 in rows 1-10 in the template.

##### Reply Metadata
- Posted at: about 6 years ago



## Related Product
[Vena](https://www.g2.com/products/vena/reviews)

## Related Category
[FP&A (Financial Planning & Analysis)](https://www.g2.com/categories/fp-a-financial-planning-analysis)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4