Have column in disconnected table populated by database query contain clickable URL

Ask the community
,
1

Hi there.

I have my database query and results table all working well however one of the columns contains a URL. The table is disconnected from the database.

I have searched for the past couple of hours and cannot find a way to make the link clickable.

It just displays as text.

Any ideas how I can make this happen?

import wixData from "wix-data";

export function CodeInput_input(event) {
    wixData.query("PAFKonly") 
 .eq("customerCode", $w("#CodeInput").value)
 .eq("category",("Pots"))
 //used to filter the results by price
.ascending("order")
  .find()  // Run the query
  .then(res => {   
 // Set the table data to be the results of the query     
    $w("#table1").rows = res.items; 
//Counting the number of records returned
wixData.query("PAFKonly")
.eq("customerCode", $w("#CodeInput").value)
.eq("category",("Pots"))
  .count()
  .then( (num) => {
 let numberOfItems = num;
    $w("#resnum").text = "" + num;
  });
   });

$w.onReady(function () {
 $w("#table1").columns = [{
 "id": "fkDescription",
 "dataPath": "fkDescription",
 "label": "Description",
 "type": "string",
 "width": 500,
 }, {
 "id": "fkArticleCode",
 "dataPath": "fkArticleCode",
 "label": "Article Code",
 "type": "string",
 "width": 100,
     }, {
 "id": "baseUnitQuantity",
 "dataPath": "baseUnitQuantity",
 "label": "Box QTY",
 "type": "number",
 "width": 50,
     }, {
 "id": "contractEachPrice",
 "dataPath": "contractEachPrice",
 "label": "Contract Each $",
 "type": "number",
 "width": 60,
   }, {
 "id": "contractBoxPrice",
 "dataPath": "contractBoxPrice",
 "label": "Contract Box $",
 "type": "number",
 "width": 60,
   }, {
 "id": "nonContractEachPrice",
 "dataPath": "nonContractEachPrice",
 "label": "Non-con Each $",
 "type": "number",
 "width": 60,
   }, {
 "id": "nonContractBoxPrice",
 "dataPath": "nonContractBoxPrice",
 "label": "Non-con Box $",
 "type": "number",
 "width": 60,
  }, {
 "id": "fkWebLink1",
 "dataPath": "fkWebLink1",
 "label": "Info",
 "type": "URL", <---------------------------Issue is with this column
 "width": 60,
 }];
});
2

  1. “URL” is not a valid type. The type should be “string”.

  2. Have a look at the linkPath here: https://www.wix.com/corvid/reference/$w/table/columns (Click the “show members” button the expand the details).

3

I currently have a problem with two dropdowns i have for my database that is connected to a repeater. They have the nonduplicate options but when i click on them the page goes blank. I have a feeling that it’s the function that i used to filter the data on the page. Do u have one that would be better since I don’t know how to code at all?

4

First, you should open a new thread, because it’s not related to the original topic.
Second, no one will be able to answer this question unless you add more details.