How to find the current page name using formula

[Tanuj_Verma]

I am using a button to duplicate the page. I setup one template with filter. New page is having a name of the filter I am using. Now to make every thigh dynamic I need to pass the page name as a filter. But I am unable to find any way to pass the page name in filter Dynamically. So, Is there any work around to find the page name or pass the filter value on click?

[Connor_McCormick]

How to pass information to a duplicated page

With the new duplicate page action, it’s quite nice to be able to create a template of a page and duplicate it. However, there is an issue with this approach. Sometimes you will want to pass information to the new page. For example: In a customer wiki that contains information about your customer, you’ll want to pass the customer name In a meeting doc, you’ll want to pass the current date (if you have a new page for each meeting) This doc offers a (dirty hacky) solution to that problem. Ove…

[Tanuj_Verma]

Thank you so much for sharing this. I made a table to explain

Please find the document below

I made the 2 tables

One is for projects and other is for task.

Now I want to make inner pages for task and I am looking for solution to show task in duplicate page related to that project.

[Tanuj_Verma]

@How to pass information to a duplicated page

thisPage.ToText().Split("/").Last().Split("_").First().ToDate()

Can you please explain how following formula is working

thisPage.ToText().Split("/").Last().Split("_").First().ToDate()

[Connor_McCormick]

@Connor_McCormick

3. Get thisMeetingDate

Now, create another formula called thisMeetingDate . It looks like this:

thisPage.ToText().Split("/").Last().Split("_").First().ToDate()

This formula extracts the date part of the url.
If the url is: https://coda.io/d/_dV-vk_8iWzc/Meeting-Template_su55M

1. Convert it to text
2. Split it along forward slashes “/”
3. Grab the last bit Meeting-Template_su55M
4. Grab the first part
5. Convert it to a date

Did this part not answer your question?

[Tanuj_Verma]

Thanks for explanation. But its not working for me. I am unable to use the current page with ToText()

[Paul_Danyliuk]

Here’s my solution from my yesterday’s secret Patreon stream (by the way feel free to check it out https://www.patreon.com/codatricks)

Building for Patrons

at 3:12:30 roughly I’m implementing a setup where I’m duplicating pages and applying different filter settings to each page automatically through canvas controls (SetControlValue)

The idea is:

1. Have a control (text, lookup etc) on your page that’s getting duplicated
2. First set a value on that control
3. Then duplicate the page. You get copies of all controls populated with those values, and everything in the page that referenced the original controls now references those copied controls.

But to answer your question, there’s no way to get thisPage or anything about current page in Coda at the moment. This here is a workaround.

[Connor_McCormick]

Nice work! I’ve been waiting for this functionality.

What do you think about offering this as a mega trick? It’s super useful to be able to create a pattern that duplicates a page and sets it up with custom data specific for that page. I do something similar for my weekly meeting docs

[Tanuj_Verma]

Nice work! I will try to use this workaround. Also, can we make a single page on button click instead of making all the pages in One go?