Clickable fields example, setting up data tables

Fri Aug 23, 2013 11:36 pm

I am creating a phonebook of sorts for each of our terminals and want to use the clickable fields example as a starting point
My problem is that I also need to be able to list the personal of each of the terminals with their contact information if I create a table for each person the data would be confusing and cluttured,
What I would like to do is be able to click the terminal and list a contacts page with the ability to make the phone numbers and emails live on the device that is to say on touch of a number it opens the phone dialer.
Can I use html code in my tables would the lister reconize the tags and would they parse through the get from the json service?
and is there any special code and or tag that needs to be used for the device to reconize a phone number and or email address?

Example
code
Name: Terminal 1
Address: 123 some street Austin, TX 12345 
Personal: Jane Doe , Owner John Doe, Terminal Manager 
/code

Fri Aug 23, 2013 11:42 pm

I'm not 100% sure I understand the question.. but you can use any HTML code. Your final app runs in the browser -- so you can use any HTML/JS/CSS code.

Fri Aug 23, 2013 11:51 pm

I will give it a try and let you know how it works, the other option would be to create a popup with html on each for each terminal but that makes it hard to update any changes and most likely would make it a bulky app to right?

Sat Aug 24, 2013 2:20 am

Yes it does work,
Any ideas on shortcuts to call the href on phone numbers that is a lot of tags and I would need to enter
Right now I am cheating by creating a panel entering the data and creating links then copying the tags back to the database

Sat Aug 24, 2013 3:17 am

Is there a cross platform method to href an address to open the native devices map program I know that androids is basicly
code
<a href="geo:lat,lon">My place</a>
and ios is
<a href="http://maps.apple.com/maps?daddr=lon,lat&saddr=lon,lat"></a>
/code
but is there a way to keep it working with any device?

Sat Aug 24, 2013 4:14 am

Hello Willie!

If I understand you correctly please check the reference https://getsatisfaction.com/apperyio/...
To work with different devices you can describe in CSS styles everything that should vary depending on the resolution.

Sat Aug 24, 2013 4:22 am

Please clarify the second sentences.
See this doc http://docs.appery.io/documentation/b... how to use database with all benefits.

Sat Aug 24, 2013 3:45 pm

Sorry That is not what I was asking, My issue is that for me to be able to tag phone numbers, fax numbers, and emails for each of the records without having to code each one manually.

But to answer my own question so that others who are faced with the situation may find an easier time of it.....

I use Microsoft Excell most spreadsheets have this function though it may not be the same name. in some cases you can use the and sign & to combine cells and text, just remember anything in quotes "my text" will be rendered, since html tags use quotes in them you need to use the CHAR(34) as a workaround
you can create your tables like normal, create an extra column for each column you need to add in html tags ( This only works if the format is the same with the exeption of the phone number) in the first empty cell enter
code
=CONCATENATE("<a href=",CHAR(34),"tel:",D3,CHAR(34),">Call</a>")
/code
The d3 is the cell with the phone number, ..... CHAR(34) is Quotes which is needed in the html tag but excell uses them to designate text this is a workaround to let you use quotes in the formula
The Result of above looks like this
a rel="nofollow"Call/a
I do not have an iphone but in android this will open the phone app with the number in it

It may take a few tries to get it right but if you have a lot of data you need to set up with tags it can be a great time saver

I will work on the ability to open the native map the same way and post it.....

Sat Aug 24, 2013 8:40 pm

I don't know if there is a cross-platform way to open maps. With some basic logic, you can show one or the other based on device type.

Tue Aug 27, 2013 6:08 am

Thank you for posting that!