Issues regarding hyperlink virtual columns

I’m posting this as a “question” but it’s really more of a comment and a request for improvement.

@Steve has written a nice article on how to use a hyperlink expression to create an system-generated action that will take the user to an external URL:

Steve’s explanation is fine, but AppSheet needs to work on this feature in my view. Here are some issues:

  1. Text wrapping doesn’t work
    If you make a text virtual column and then manually make your own action to attach to it, all is well. If, however, you rely on the hypertext expression, no wrapping. I’ve written about this here:
    Make hyperlink text wrap properly
  2. “Launch external” is poorly integrated
    I’ve written about this problem here:
    URL to launch externally instead of the appview - #20 by Kirk_Masden
  3. The function fails to record the “Display inline” line automatically
    I haven’t written about this yet so here’s my explanation.
    Today I used the hyperlink expression to make the following link:

    The system automatically generated an action for me and correctly designated the “Prominence” as “Display inline” but failed to finish the job by naming the column to attach it to.

    Obviously, the default should be for the action to be attached to the column that holds the hyperlink that caused the action to be made in the first place – but that doesn’t happen.

Finally, I’d like to point out that when I have big tables and am concerned about the performance of my app, I don’t use this hypertext function. Instead, I make the linking action myself and then attach it to the appropriate text column. For some discussion, see the following:

2 Likes

Though I think most of my points in this post a valid, I’m no longer sure about this one. I tried it again with a different link and the inline action was attached correctly and automatically. I’ll look in to what might cause the experience I reported. It may be that if you do things correctly it works but if you make some sort of mistake along then way, it’s not recover and assign the column correctly after you’ve fixed your error.

1 Like

I was able to confirm that, if you do everything correctly and then save your work, the action is attached correctly. BUT, if you add another virtual column after that, the attachment is temporarily lost. This is disconcerting but if you ignore it and keep editing, in comes back. Curiouser and curiouser.

2 Likes

Sounds like a bug worth reporting to Support. It would probably be helpful to Development if you could provide with your report a simple example app and specific instruction how to reproduce the problem.

https://www.appsheet.com/Support/Contact

1 Like

Thanks! Will do!

1 Like

This should not be a perfect solutions likely, but the recently released new feature of rich text may help you to construct hyperlink with the long strings as you want.
Just use the standart tag to generate the links then it looks like,

Snag_275fe109

You just create the virtual column and make it long text with html and push expressions something like

Snag_275fee95

3 Likes

Wow! I was unaware of this. Thanks!

You can construct expression to dynamically change the URL to jump for. Make sure this only works in virtual column .

2 Likes

Thanks again! I’m reading the announcement now. Somehow, I had missed it.

1 Like

That is an ingenious use case of rich text feature @tsuji_koichi .

2 Likes

I got it to work in a real (physical) column. I’m about to write about that in the thread announcing the new feature.

1 Like