@CarlaK this one is tough, I’ve done this same setup below with the following approach; it’s a little clunky and tedious based on how many boards you have, but it does work well
you can use a switch module to switch the output of the boards column ID you need to updated. ‘patients’ in your case so put the board ID mappable variable as the input to the switch module. Then for each of the boards you will be using
Put the actual hard coded board ID as the ‘value to match.
And put the the output as the Id of patient column. (patient, patient_2, etc) repeat this for however many boards you need to get patient info for in Monday
I eventually realized I was overthinking things. Now, for each row, I iterate through the array of columns, and filter for the column titled “PATIENTS”, no ID required.
But now I’m stuck again. I’m trying to add the value of PATIENTS to an array, mainly so I can see it’s doing it right, before I sum them together. I feel like I’m missing something very simple or obvious because I can’t make it work.
I create an empty array variable before listing all the rows, then after filtering columns for PATIENTS I am trying to use add() to insert the new value. The documentation tells me about the function, but not where and how to use it, and I must be doing it wrong.
Awesome, yes your way of iterating through columns and filtering to title based on patient makes sense.
re the variable/adding to an array. You should not set your variable name as a mapped value. The Variable name should be static. In addition to that couple of follow up questions.
Why do you need an array of patients? you are just trying to get the sum of all patients across multiple boards right? in that case I use a running total where I first set a variable to 0 and then incrementally add the number to itself for subsequent bundles.
If you’d like a free 30m consult I’d be happy to talk and you can schedule here: Calendly - Tim Little
probably would be easier to get it over a zoom call.
I have 9 boards with 1, 2, or 3 groups each. I’m trying to make a board that lists the group name and the group’s totals for 3 separate columns (patients and 2 others). I was trying to use the array because the example I found has sum(map( etc.
Either using an array or your suggestion of setting a variable and adding to it, I hit the same problem. I’m sure I must be missing something obvious lol… I can’t get it to save to itself…
Thanks again for your help, unfortunately I’m asleep when you’re available for a call, and probably vice versa. I’ve watched a million videos and am pretty comfortable with most things, it’s just this one thing that has me stuck!
@CarlaK yes if you have an array of the values then you can just use the ‘sum([array])’ and it will do all the hard work for you.
but in the case where they are in bundles etc… you have to set the variable and then get it again. This is inefficient but effective.
see below screenshots, hopefully that gets you over the edge.
