Glide Big Table

Ask for Help
1

Hello,
It is possible to make a monthly report with Glide Big Table?
Something like
[Financial data - #4 by nathanaelb]

2

It’s possible, but can be a bit tricky. For example, the relation that @nathanaelb describes will not work with a Big Table, because relations that target computed columns are not supported.

So you need to adopt other methods. It depends exactly what you need. Charts work quite well with Big Tables, so if all you need is a chart I’d say just give it a go and then ask for help if/when you get stuck.

If you need something else, give us a clear description of what it is and we’ll do our best to help.

1 Like
3

Well,
I have a database where drivers enter their car journeys.
I want to make a report per month, more precisely how many registrations are made each month for all drivers. Then when you click on each month, the date and the races for each individual car will appear.

4

So in your current Big Table, you’re storing the journeys with a date that the user can enter, in a basic column?

1 Like
5

Yes, it is a date & time column.

6

@Darren_Murphy is the fix for computed columns Mark mentioned the other day live for Big Tables?

7

That one was just an enhancement to allow rollups of math columns in GBT.
I believe that Mark is actively working on removing GBT limitations, so we can probably expect to see these enhancements start to drop on a regular basis.

2 Likes
8

For your case, I think as the date is static, you can:

  • Add a math column to calculate the month numeric value (called “Month numeric”) of the journey record: YEAR(D)*10^2+MONTH(D) with D being the record’s date.

  • Add a basic number column named “Month basic”.

  • Use an on-submit action to set the value of “Month numeric” to “Month basic”.

  • Create a table of months, with a “Month numeric” column having the same formula as stated above.

image
image1618Ă—425 34.8 KB

  • Create a relation from this table to your journeys table, using the “Month Numeric” column in “Months” to relate to “Month basic” in journeys.

  • Create a rollup column to count the number of registrations and show a collection based on the relation in the details view of each month.

1 Like
9

Thank you!! It worked! :partying_face:

1 Like
10

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.