Displaying a database field as a hyperlink

  • Resolved joemcl602

    (@joemcl602)


    4 years, 8 months ago

    in the database which is the source of the data displayed on this page. In that database is a webaddress field. Is there a way to display these webaddress fields records as hyperlinks?

    Using WP Data Access plugin

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    4 years, 8 months ago

    Hi Joe,

    If you want to automatically convert URLs to hyperlinks:
    – Open the Data Explorer
    – Find your table
    – Click Manage > Column Settings
    – Select hyperlink as the column type
    – Save your column settings

    Since you have stored the full URL in this column:
    – Open the Data Explorer
    – Find your table
    – Click Manage > Table Settings
    – Select plain text for process hyperlink columns as
    – Save your table settings

    The second step is necessary to let the plugin handle the URL column values as plain text. You can also store URLs in JSON format to add additional attributes which won’t work in your case as the URLs are already stored as plain text.

    Hope this helps. Let me know if it does not work…

    Best regards,
    Peter

Viewing 1 replies (of 1 total)

The topic ‘Displaying a database field as a hyperlink’ is closed to new replies.