Important features for reporting and working with (relatively) big data

Idea
1

@emmanuel @georgeciobanu
we are working with several clients for creating their corporate reporting and automation tools. We are facing difficulties in running bulk operations. For example creating a list of things from an API call. Right now we need to set up a sort of a loop that would read the API call and create a thing one by one, which is not very convenient.
The other point is grouping and calculations - there is no easy way to for example calculate a sum of number fields in a given table based on a certain search, or do other calculations.

Are there any suggestions how to be with these, or maybe you can push some updates that would allow handling such operations?
Thanks,

3 Likes
2

Did you make any progress on creating a list of things from an API call?

3

not yet, still working on it, i will let you know if we succeed

4

Hey @levon

would appreciate your input here again, frankly i am at a loss with this

5

Hey @AliFarahat Bubble has added schedule an API workflow on a list, this is the only solution right now to create a list of things. Can this help you somehow?
Thanks,
Levon.

Founder at Bubblewits - Bubble Certified Partner

http://bubblestore.io – a place to buy Bubble templates for landing pages, e-commerce, workflows, APIs etc.
http://iambubble.com - one page Bubble demo
http://builtonbubble.com - Collection of apps built on Bubble

6

If you can pull back the API array into a bubble RG, then you can run workflows on this list.

Doing it without a repeating group solely in an API… I wonder if you could duplicate the API call, one for Action and One for Data.

So step 1 : Perform the Action on the API
Step 2 : Schedule API on a List. Data = the Data API, list = Step 1.

7

@levon @NigelG

Thanks for the feedback. I have used schedule an API on a list and it works as expected. My requirement revolves around the ability to aggregate data in a query type manner; which i can then later use to generate a graph.

Did you guys face a situation like this, any workaround or solutions?

8

can you bring an example?

9

Yep,

I have 1000 employees that have each have one of the below status (text field)

  • Joiner
  • Productive
  • Leave
  • Anything else

I want to be able to create a chart that shows a count of each reason. So for example

  • Joiner = 500
  • Productive 300
  • Leave = 200

I know i can do this using the existing workflows by counting one status after another; but the problem is that the status listed above are dynamically changing.

So i need the unique count of each status

10

Can you schedule a workflow on status list.

And then for each status update a field with a count ?

11

I am doing that. But i do i handle the count as the status can be set to anything?

Imagine you had a list of orders and you wanted to count the number of orders per product; relativly easy for a few. Now what if you had 1000 different products.

12

why don’t you simply use a dynamic expression to calculate each status in the graph for example, do a search for employees (with constraint status=joiner) ’ count and same way for other statuses.

13

so let me provide an example to explain in better.

The Orders lines below contain different products

Pasted image1004×436 16.9 KB

i need a way to know this

Pasted image776×294 6.54 KB

14

if you want to show it in a repeating group then it’s easy. Is that what you want to do?

15

No actually i want to store the results in a thing

16

any updates on workarounds guys?

17

regarding what exactly? A few things were discussed in this topic

Thanks,
Levon.

Founder at Bubblewits - Bubble Certified Partnera

http://bubblestore.io – a place to buy Bubble templates for landing pages, e-commerce, workflows, APIs etc.
http://iambubble.com - one page Bubble demoac
http://builtonbubble.com - Collection of apps built on Bubble

18

Hi @AliFarahat in your example - counting Product Name or things of a particular type to report on. Did you find a solution to the example you provided?

Many thanks!

19

Nope I did not

20

After posting my message had an idea and it worked for me, it may work for you.