Dataview File.link Problem - first column


hello,

I hope someone can help me :slight_smile:

how can i set the first column as a hyperlink in the dataview code?
is that even possible…

it would be best if i had only the 1 column as in the picture and the 2 column hidden …

unfortunately i can’t do that

 
TABLE WITHOUT ID  dateformat(file.day, "cccc, dd MMMM yyyy") as "Tag", file.link AS "Datei"
from "Kalender"
WHERE file.cday > date(today) - dur(7 day) LIMIT 4

You could try to use link(path, [display]) :blush: :

TABLE WITHOUT ID 
  link(file.path, dateformat(file.day, "cccc, dd MMMM yyyy")) as "Tag", 
  file.link AS "Datei"
from "Kalender"
WHERE file.cday > date(today) - dur(7 day) LIMIT 4

…And I guess that you could remove the Datei field from the query.

1 Like

There’s a Dataview function called “link(url, display)” that you can use to do that. The below should work, although I haven’t tested it. This way you have just 1 column as requested.

TABLE WITHOUT ID link(file.path, dateformat(file.day, "cccc, dd MMMM yyyy")) as "Tag"
from "Kalender"
WHERE file.cday > date(today) - dur(7 day) LIMIT 4
1 Like

@Pch
@woofy31
thank you very much for the quick reply :slight_smile:

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.