How to make a link that shows the row in a specific table view?

1

I am trying to use the automation to send me Slack notifications with a link to the newly added ticket (row).

I have the “master” table, which I will call DB_Table, and a table view of the master table, which I will call “Customer Pending Action.” I tried using the formula below, with Step 1 result being the newly added ticket via form submission. However, when I click the output hyperlink in Slack, I am redirected to the row inside DB_Table and not to the one inside the table view “Customer Pending Action.”

image
image582×170 18.5 KB

I want the row to open in a modal form, and for it to highlight the row inside the table view, not the master table. Is that possible?

Thank you in advance!

2

hi @Larissa_Harada ,

you can append OpenRow() and reference the view in the first part, something like:

[Customer Pending Action].Filter(CurentValue.contains(Step 1 Result–)).First().OpenRow([Customer Pending Action])

I did not test it (don’t use slack or other integrations, they distract more than they deliver). I hope it helps, cheers, Christiaan

4

Hi @Christiaan_Huizer , thank you for the reply!

Unfortunately, using OpenRow creates an Action and not a hyperlink, which when translated to the Slack mesage for some reason it just returns a string of ui

Here is how it looks in the Content field of the automation:

image
image1141×825 65.3 KB

What showed up in Slack:

image
image574×304 12.8 KB

5

thanks for the clarification, it underlines my understanding and knowledge of how slack works together with our docs.

can you replace this with the the objectlink logic, not sure this works, but it will output the url of the object.

[Customer Pending Action].Filter(CurentValue.contains(Step 1 Result–)).First().ObjectLInk()

if this does not work, I hope slack users jump in to help you solving the issue, cheers, christiaan

7

This is an interesting problem that I’ve actually spent a lot of time getting to the bottom of!

I’ve created a formula generator here :slight_smile: Please consider buying me a coffee to support my work if I helped you out :folded_hands:

Recommended formula that opens in modal, without play mode, and also works outside the doc: (Copy paste into column formula)

"https://coda.io/d/d" + DocId(thisDocument.ObjectLink()) + "#\_tu" + thisTable.ObjectLink().Right(6) + "/r" + thisRow.RowId() + "&view=modal"

So for your use-case to open in a specific view, you can simply replace the thisTable part with that view (write the name of the view in formula editor)

8

Here’s an article I wrote detailing Coda URLs. This is a little dated, there is a change in the short id’s used from 3 characters to 6 characters and then of course it’s still using the coda.io domain. But the structure and breakdown all still applies.

9

Thank you so much, guys! It is working now!

I did not understand how Coda URLs work, so @Ben_Lee’s article was really helpful. Thank you!

I will write down here how the experiment went:

This formula created a URL, but unfortunately it still redirected to the master table. Thank you, @Christiaan_Huizer, for the follow-up on the issue anyway. Really appreciate it :grinning_face:

Thank you for the reply, @Rickard_Abraham. I trust your experiments, so I was puzzled at first when it didn’t work. When clicking on the generated URL, I would get an error saying “Table was deleted.”

Then I realized I had not shared the information that, in my specific table view, I have multiple tabbed views! It did not come to mind when first posting, but after reading your replies, I noticed it should be relevant. I did not test it, but I think Rickard’s formula will work perfectly if the table view has no tabbed views.

After manually copying the link to the card, in the table view, in the correct tabbed view, I noticed that they put the ID of the tabbed view after the table ID.

So I modified the formula to extract 16 characters instead of 6, and it worked!

"https://coda.io/d/d" + DocId(thisDocument.ObjectLink()) + "#\_tu" + [Customer Pending Actions ▸ All].ObjectLink().Right(16) + "/r" + thisRow.[Step 1 Result].RowId() + "&view=modal"

So I guess the URL pattern when there are tabbed views is like this, with the View ID after _vu:

https://coda.io/d/[docName]_d[docID]/[pageName]_su[ShortPageID]#[tableName]_tu[ShortTableID]/[viewName]_vu[ShortViewID]/r[rowID]

So my problem has been solved. Thank you all!