DataTable column to be a hyperlink only if the text "complete for current month" is at the column

(0) Share

Report

Posted on by kouliscon

247

Hello,

i have a DataTable and i would like to know if i can have one column which is now set as hyperlink by having the "is hyperlink" active and then i have set the "onSelect" to the formula "Launch(("appwhichiwanttoopen?ID=") & DataTableITReminders.Selected.ID) but i would like to be a hyperlink only if the column has the text "Complete for current month".

i believe maybe i need to set something at visible or something?

thank you

Categories:

Using Apps Using Formulas

General Questions

All responses (1)

Answers (0)

GarethPrisk 2,826 on at

Like (0)

Report
Re: DataTable column to be a hyperlink only if the text "complete for current month" is at the column

Not sure how you'll be able to dynamic hyperlinking (the entire column is, or isn't), but you can control the selected row pretty easily. Effectively, what you have, but with a check to ensure the selected field is what you expect.

If( Parent.Selected.NAMEOFFIELD = "Complete for current month", Launch(("appwhichiwanttoopen?ID=") & Parent.Selected.ID) )