Enhancement to Web Site Field Type

[prov0356]

Hi Brendan,
I would like to request an enhancement to the Web Site field type to have a Description sub-field similar to the Address sub-field of the Location field type. That way, I can give it descriptive text like I can on a Location field.
Thanks.

[Brendan]

Hi Prov,

Thanks for the feature request. It’s the first time I’ve had that one actually.

The reason it works for the Location field right now is because the way the location field data is stored is like this:

field_id = { "title" = "Big Ben, London, UK",
             "lat" = 51.510357,
             "lon" = -0.116773
}

But website address fields are stored more simply:

field_id = "https://www.apple.com"

So it would require me to convert the simple structure in the website field to a more complex structure like in the location field for all records. It would also break compatibility with older versions of Tap Forms that require the website field to be stored in the old format.

So for this one I’ll have to think about this one some more.

Oh and I just read your review on the App Store today. Thank you so very much for such a very kind review! I really appreciate you taking the time to write all that.

Thanks!

Brendan

[Allan Honey]

I have a related weblink request as well – a web site link as a calculation result type.

i.e Say I had a database of UPC (or ASIN) codes – I could generate a lookup to see if Amazon stock it by clicking (something) that opens a web browser to check amazon.com then another lookup to see if its also on amazon.co.uk OR amazon.ca OR amazon.com.au

Hope that makes sense!

– Allan
Amazon Worrier

[Brendan]

Hi Allan,

You can already do this directly with a Website Address field.

Just make your URL like this:

https://www.amazon.com/gp/search?field-isbn=[ISBN]

Now when you click on the globe button next to the website field, Tap Forms will substitute the value in the ISBN field into the website address and it will take you to that address.

E.g., if ISBN = 9781451648539, Tap Forms would take you to:

https://www.amazon.com/gp/search?field-isbn=9781451648539

[Allan Honey]

Oh! Excellent.

I’m experimenting using this in a Table
Table Field 1 [Amazon] – A full product URL (pasted in from browser)

i.e. https://www.amazon.co.uk/Bento-1-0-Family-Pack-Mac/dp/B0012PJCTW/

Table Field 2 [ASIN] – A calc field to isolate ASIN

(SUBSTR( [Amazon] ; ( POS( ; “/dp/” ) + 3 ) ;
((LENGTH( [Amazon] ) – 1 ) – ( POS( [Amazon];
“/dp/” ) + 3 ) )
)

Table Field 3 [US Amazon] – A Web Site field (to see if product is also on other Amazons)

https://www.amazon.com/dp/******

If I manually put “B0012PJCTW” in place of ****** – it works! (of course)

But how do I reference the Table:ASIN field???

[Brendan]

Well it seems that for Table fields I didn’t implement the substitution function.

But I’ve just rectified that.

So for now it will only work for fields on the main form, not on any Table field fields.

But the the next update will let you do that.

Thanks for bringing this to my attention.

Brendan

[Allan Honey]

Many many thanks Brendon

Hopefully the next release is a couple of days away!!!

And you didn’t throw your hands up in horror at my function to get the ASIN text.
I couldn’t workout a ‘cleaner’ solution.

I do miss the FileMaker Position function –

Position(text;searchString;start;occurrence)

(am I being to subtle????)

[Brendan]

Hi Allan,

Well, you could use the Tap Forms equivalent POS() function

POS(A; B)

Returns the position of B within the text A.

For example, POS("Tap Forms"; "Forms") returns the numeric value 5.

I just don’t have the occurrence parameter.

There’s also a variety of other text manipulation functions in the Calculation field formula editor, such as SUBSTR, LEFT, RIGHT, etc.

[Allan Honey]

Yes – It’s the occurrence parameter I was hinting you could add.

And I just noticed a error in my ‘cut & pasted” formula (just in case someone else is interested in improving it – missing [Amazon] after first POS()

(SUBSTR( [Amazon] ;
( POS( [Amazon] ; “/dp/” ) + 3 ) ;
((LENGTH( [Amazon] ) – 1 ) – ( POS( [Amazon]; “/dp/” ) + 3 ) )
)

[Brendan]

Sorry, I had missed that you already were using the POS function. Sorry about that.

[Author]

Posts