Question

Layout for a large excel table

0

I need to develop an applicattion who is running in an Excel table actually. This table is big and works to demonstrate the financial closure data. She has many columns. What is the best way to build this table?

asked 2021-03-30

David Belizario Rodrigues

3 answers

Michiel Arts · Answer 1 · 2021-03-30

Hi David,

Your question is very generic, im am not sure what exactly you are looking for.

Did you check out the learning paths on the basics of Mendix? They are very good in giving an impression of what Mendix can do and how to approach creating an app.

For example: https://academy.mendix.com/link/path/83/Build-an-App-in-Mendix-Studio

In general, you can create an entity with attributes, which would be translated by Mendix into a database table containing a column for every attribute.

However: Mendix is not Excel, in so many ways.

I hope this helps.

Marie Trull · Answer 2 · 2021-03-30

What is the scope of the size of the table? Does everything HAVE to be presented in a table like way with all of the columns on one page?

Are using widgets to break up/make that data show in different ways out of the question?

Nuno Costa · Answer 3 · 2021-03-30

hi David,

you have 2 options:

- horizontal scroll (this is really not recommended from the UX)

- use datatables widgets and extend to hide / show columns according to your user choice, this will be a big efford.

those are the options you have.