Short Data Export Task

Hi guys,

I need a solution to export a list of summarised data to CSV.

As it stands the data looks like this:

Name Shift Quantity
Ashley Allen Night Shift 1
Ashley Allen Day Shift 1
Ashley Allen Day Shift 1
Ashley Allen Night Shift 1
Ashley Allen Night Shift 1
David Jones Day Shift 1
Kimberly Roberts Day Shift 1

I need to summarise the data into this (each [Quantity] is summed and compressed onto one line for each listed [Name] for each type of [Shift]):

Name Shift Quantity
Ashley Allen Night Shift 3
Ashley Allen Day Shift 2
David Jones Day Shift 1
Kimberly Roberts Day Shift 1

The job:

  • Take the first example list, and summarise it into the second list, then export it to CSV.
  • I need to take the workflows and translate them into my application.
  • I do not need the solution to be pretty or have a polished UI, just efficient and completely reliable.

The rub:

  • The list is taken from a dynamic repeating group (not a static source).
  • The real lists will be hundreds of lines long.
  • This will likely need to be a backend solution.
  • I cannot allow you access to my application due to PII, so it will need to be in its own environment.

What I know:

I have attempted to solve this myself. You cannot pass groupings to a backend workflow, nor can you extract data from them in a useful way, so groupings are out. I can export the raw data to CSV without issue.

Budget:

This is a one-off job, and hopefully a relatively short task for someone who knows the solution. I am open to discuss cost, though if development time is more than a couple of hours it makes little sense to proceed when the raw export is probably ‘good enough’.

1 Like

You can create a text from RG and use Toolbox’s Javascript2Bubble to do the counting. You can ask AI to create the JS code.

1 Like

I’m using 1T CSV Creator, which can pretty much take a list as text and export a CSV, but I’ve never used Javascript2Bubble before. I’m still happy to pass this over to someone who knows exactly what they’re doing if it will save me time.

Hey @QIRO :wave:

I suggest using this plugin to create your csv file. I use it all the time to create a csv from JSON. 1T - CSV Creator Plugin | Bubble

It can be tricky to setup if you don’t understand JSON but it will work.

Do your list that you need, group by, formatted as text, then put in your calculations inside there.

Hope that helps, I can offer coaching if you need it. :blush:

1 Like

Wait, you can format a grouping as text? :dotted_line_face:

I had a full head of hair before I attempted this, now I can be used as a searchlight. Let me check this out but I may indeed take you up on the offer of coaching. PM me if you’d like to discuss.

1 Like

Yeah. ‘Format as text’ is the key here. Try it out first, if you need assistance, my live schedule is available here: NoCodeMinute

Hope that helps. :blush:

1 Like