Open multiple external links via a button, based on state/stage

[0xGoose]

Hey, newbie here who has tried his best to find a solution…!

I have table which contains:

1. Names of people (Name), pulled from a central list/database
2. Their LinkedIn profiles (LI), embedded in buttons (which executes fine individually via OpenWindow(thisRow.Name.[Linked in])
3. The ‘stage’ they are at in an interview process (Stage), pulled from a list in a separate page/table

I want to be able to bulk-open multiple LinkedIn profiles via a single Button, depending on their stage. For example:

Button Stage 1: Open all LI profile for people at Stage 1 (e.g. Jeff, Jenny and John)
Button Stage 2: Open all LI profile for people at Stage 2 (e.g. Colin, Carrie and Cassandra)
Etc…

I suppose the challenge comes when those people change stages - for example, when Jenny moves to stage 2, her profile should no longer open via the Stage 1 button, instead opening via Stage 2 button. Obviously I’m looking to avoid manually updating a formula each time somebody changes stage, as that will change often.

Is there a way to automatically assign?

Thanks in advance

[Pch]

Hi @0xGoose and Welcome to the Community !

I’m not entirely sure this is the kind of setup you actually have () … But, is this what you were trying to do ? (look at the buttons on the canvas )

The formula I used in the canvas button Stage 1 (for example) is :

[People & Stages].Filter(Stages = [Stage 1]).ForEach(
  OpenWindow(People.URL)
)

And what it does is :

1. [People & Stages].Filter(Stages = [Stage 1])

It takes the table named [People & Stages] and look for rows where Stages = [Stage 1].
This returns a list of rows from my [People & Stages] table and more specifically, a list of people (coming from a People table where I’ve stored their “name” and some URL coming from my opened tabs ).

2. [ ... ].ForEach( OpenWindow(People.URL) )

And now that we have the appropriate list of rows, this kind of says: ForEach() row in the list of rows returned by the Filter() (each individual row being represented as CurrentValue in the list, so People here is in fact CurrentValue.People ), open the url tied to that specific person

Another possibility, following a similar principle would be to have canvas buttons pushing the appropriate and individual OpenWindow() button you might already have in your table , using something like :

[People & Stages].Filter(Stages = [Stage 1]).ForEach(
  Button
)

(Button being in fact CurrentValue.Button)

See the sample just below

Without a sanitised/anonymised sample of your current setup (or even just a screenshot), it’s a bit hard to be more precise …
But I still hope this will help you a little !

Don’t hesitate if you have questions

[0xGoose]

So helpful thank you! I ended up with the following:

[Table].Filter(Stage=Stage 1).ForEach(LinkedIn)

One last thing - how would I go about excluding people from this if another condition was met? Specifically, I have an ‘Archive’ checkbox which, when checked, crosses out a people but leaves them in the list (for visibility, and sorted to the bottom) which retains the ‘Stage’ they reached before they were Archived. Obviously I wouldn’t want to open these LinkedIn profiles as they are no longer a consideration.

Tried a couple of things but didn’t work and don’t want to screw this up now Thank you in advance @Pch !

[Pch]

Glad to know this helped you to move forward !

As for your follow-up question, same principle as before : Get the appropriate list of rows from your table with Filter() and then, ForEach() row in the list push the button…

In other words, something like :

[Table].Filter(Stage = Stage 1 AND Archive = false).ForEach(LinkedIn)

… should do the work
(See the canvas button Stage 1 in the sample doc below )

The Filter() formula will return, in this case, a list of rows from your table where the value in your field Stage is Stage 1 AND also, where the value in your column Archive is false (so, not checked).

Both conditions needs to be true here for Filter() to keep a row in the list of rows it returns.
Then, ForEach() will do the rest .

Another way to write the same formula and get the same result would be :
(See the button Stage 2 in the sample doc below)

[Table].Filter(Stage=Stage 1 AND Archive.Not()).ForEach(LinkedIn)

The Filter() formula returns here a list of rows from your table where the value in your column Stage is once again Stage 1 AND where the value in your column Archive is Archive.Not() (I.e.: where the checkbox Archive is Not() true (not checked), so false ).

Once again, I hope this helps !

[0xGoose]

Thanks so much! All worked out well

[Pch]

No problem @0xGoose !

I’m really happy to know it worked !!!