HELP ASAP PLEASE!!! linking table row to new page

Ask the community
,
1

I am having the hardest time trying to connect a table row to a dynamic page.

I want to double click on a row and have that open to a new page with that rows information. I know I need a double click event, to get the row data then redirect this infection onto the new page?
HELP!! It’s been so long since I have coded and I have been up all night trying to helping with someones phd submission. Its not a really complicated site. Any basic code that can help do this would be soooo helpful.

Sorry for grammar, typos, and spellings mistakes…….its been a long day

2

Ok, lets see what we have here. :grin:

You have a table and you want to navigate to a dynamic page by clicking or doubleClicking on a table-row. Is that right?

For this, i think you have also already a ready database, where you have all the needed data with the needed link-references, right?

3

Yeah I just cant work out the code. I have a database and the dynamic page all set up.

im guessing its somthing like event click then like get cellData. take that info and get it to input on my dynamic page and redirect the page or a new tab or a pop up whatever is easiest useing to(). I just dont know wix code and its been a long time

4

Also thank you co much for trying to help. i really really appreciate it

5

this is what my site looks like. I want to click on one row in the table

2216×1396 277 KB

and have that table row displayed on to this page

2234×1430 230 KB

dose this make sense? im just really lost

6

Allright, then i will give you an example-code for this.
You will have to modify this code, to get it to work…

Here it comes…:grin:

export function table1_rowSelect(event) {
    setTimeout (()=>{
        $w('#dataset1').onReady( () => {
 let currentRowIndex = event.rowIndex
            console.log(currentRowIndex)    
 let URL = $w('#dataset1').getCurrentItem().url
            console.log(URL)
            console.log($w('#dataset1').getCurrentItem().title)
            console.log($w('#dataset1').getCurrentItem().tutorial)
            console.log($w('#dataset1').getCurrentItem().index)
 let myURL = $w('#dataset1').getCurrentItem()["link-tutorials-title"]
 let contentLink1 = $w('#dataset1').getCurrentItem()["link-tutorials-title"]

            console.log(myURL)
            $w('#BTNgo').link = myURL
        } );
    },5)
}

If all the console-logs making you crazy, just delete them first, to have a better overview of the code.

export function table1_rowSelect(event) {
    setTimeout (()=>{
        $w('#dataset1').onReady( () => {
 let currentRowIndex = event.rowIndex  
 let URL = $w('#dataset1').getCurrentItem().url
 let myURL = $w('#dataset1').getCurrentItem()["link-tutorials-title"]
 let contentLink1 = $w('#dataset1').getCurrentItem()["link-tutorials-title"]

            $w('#BTNgo').link = myURL
        } );
    },5)
}

All starts here… (with a click on the table)

exportfunction table1_rowSelect(event) { }

Why setTimeout is needed you can test it by deleting it later when your code is running (not recommended :grin:)

Here you figure out the current selectec ROW-INDEX…

let currentRowIndex = event.rowIndex

Here you get/set you URL from your database (Reference-ID in this case = “url”)

let URL = $w('#dataset1').getCurrentItem().url

And with this example here, you can get/set a dynamic URL from database, in my case in this example -----> “[“link-tutorials-title”]”

let myURL = $w('#dataset1').getCurrentItem()["link-tutorials-title"]

Here you give a button a link…

$w('#BTNgo').link = myURL

How all this works in live, you can see here…
https://russian-dima.wixsite.com/meinewebsite
You will surely find the “GO”-button and the table with all the functions, which were described here in my post :grin::wink: GOOD-LUCK!

7

Thank you so much. I will try this asap. hopefully my brian will work. thank you so much

8

Just take your time. Study every code-line (line by line).
You have luck, you already have a live-example in front of you, where you can look at for better imagination.

The most difficult part (for me) was to figure out how to define/get the dynamic-url.