I have weekly meetings that are done in small groups.
I also have outlines, presentations, or lessons in pdf form.
I want to be able to select a google drive linked based on which one is selected.
based on the week I have an option of files to view using the following expression
column type: Enum
Base type: URL
VALID_IF:
SELECT(TBM Lessons[Lesson], WEEKNUM([Date/Week]) = WEEKNUM(TODAY())),1)
this returns a list of URLS, based on what is set for the week.
The user selects one.
in the behavior actions tab I made a rule for opening the link
[_THISROW].[Lesson]
Question: Is there a way to open a pdf based on the URL inputed into a column?
Found a solution.
I made the type a show, the category URL, and content my expression.
However, this does not give the user an option to choose which pdf to view.
I would still like to know if there is a better solution.
@CLS_Dispatch - were you able to find a better solution? If so, would you care to share? If not (a better solution), would you care to share a screenshot of where you put the expression?
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |