I’m using AirTable as a database and Line or Bar graph components from the marketplace to display client results over time, however, no matter what - the graph doesn’t recognise the logical sequence on the X-axis, e.g.:
• If I use a numeric sequence (1,2,3,4,5) for X Axis - the graph shows values in the order of 3-4-1-2-5
• If I use Date (no matter if direct Date field from AIrTable or a Date text string) for X Axis - the graph shows values in the order of Sept 20 - Sept 27 - Sept 6 - Sept 13 - Oct 4
Solutions I tried but didn’t help:
• Adding sorting filters as per this article [In fact sorting completely breaks the graph)
• Changing date formats on AirTable (US, ISO, European, Friendly etc.)
• Switching between Date Field and a Text String (to pull date values), as well as adding logical sequence (1-2-3-4-5)
Could anyone help me please?
p.s. App name is “Coach (Coaching Template)” & screen is “Student GOAL Results”… if anyone from Adalo could look into it.
Yes these can be a bit tricky for sure, especially when using query formulas. You might could try sorting it in an Airtable view first, then specifying the view with a query param instead of trying to sort here in Adalo.
(1) Could you please help with how to write the query parameter to specify the view?
(Tried many different expressions but nothing works so I may just miss some detail and couldn’t find anything online.)
(2) If the above doesn’t help, would a potential solution be to use Zapier to send AirTable records (necessary for a graph) to Adalo database and then use internal collection for the graph?
I guess this could be a solution (very painful though) whenever Adalo faces limitations due to arrays…
Actually there is nothing special to it. You just put view as a query parameter name, then put the View’s name or ID as the value. I usually prefer the ID instead so even if I accidentally change the View name it’s not a big deal. You can find the view ID in the URL bar when you have the view selected in Airtable. It’s this highlighted portion:
