Can I Reference Fields Within Fields?

[A Ibanez]

Heya. Sorry for the unclear title, I will explain below.

I’ve been using TapForms for years but I just realized how powerful it is with Calculations and Scripts. So I’m working on migrating an anime database to a new format.

Here’s my situation.

– I want to keep a numerical field called “MAL ID” that stores the ID of a series in myanimelist.net.
– I want to generate a URL called “MAL URL” whose format would be “CONCAT(“https://myanimelist.net/anime/”, [MAL ID]”, where “MAL ID” is the value of the MAL ID field. This would for example create this URL: “https://myanimelist.net/anime/31240”
– I’d like to store the value of the “MAL URL” field in a field of type “Web Site” called “Web Site” so I can click on it when I’m on my phone to visit it easier.

I can generate the URL based on the MAL ID field, but I cannot figure out a way to bring the value of the “MAL URL” website to make it clickable in the “Web Site” field.

To simplify my explanation, have a look at this screenshot:

The MAL ID field is the only field that the user edits manually. Tapforms then generates the link to MyAnimeList using a Calculation field in “MAL URL”. Now I want to bring the value of MAL URL into “Web Site” keeping the “Web Site” field type.

Is there any way to do this?

Attachments:

You must be logged in to view attached files.

[Brendan]

Hi Andy,

It’s actually easier than this.

If you create a Default Value for your Website Address field like this:

https://myanimelist.net/anime/[Mal ID]

Then Tap Forms will automatically inject the value of the Mail ID field into the URL when you click the little globe button next to the Website Address field.

Hope that’s an acceptable solution.

You can also of course use a Script field to do this too by having the Script field write a URL for you into your MAL URL field.

Thanks!

Brendan

[A Ibanez]

Hi Brendan.

That is definitely a better solution, but I can’t get it to work. I set the “Web Site” field to be of type “Web Site”, set the default value to be “https://myanimelist.net/anime/%5BMAL ID]”, and clicked on the globe, but it doesn’t seem to be populating it. Screenshot attached.

Am I missing a step? Sorry for making it a big screenshot that shows a lot of irrelevant info. I chose to do this so you can see that I’m editing the intended field.

Thanks for your response!

Attachments:

You must be logged in to view attached files.

[A Ibanez]

OK, think I got it. TapForms will not refresh the field to replace and visually show https://myanimelist.net/anime/44 when clicking the globe, but it will open the right website when clicking it. This works for my purposes. Thanks a bunch.

[Brendan]

That’s right. There’s no visible change to the Website Address field. The Mal ID field does not get injected into the URL until click time.

[Author]

Posts