A table that is editable on pc also

Post your questions and help other users.

Moderator: Martin

Post Reply
angelatwork
Posts: 186
Joined: 12 Feb 2014 01:45

A table that is editable on pc also

Post by angelatwork » 09 Jun 2014 11:53

Hi, I can make a table that can add calendar events and phone logs and also add user input data. But I want to be able to edit and add data on my pc? And then continue to add etc on my phone. I am Swedish, so if using excel, excel uses ; as delimiter and utf 8 with boom (or is without?) is necessary to see ît on my computer. But then I cannot see it properly on my phone and if I edit it on my pc it is not in the proper format for Am to handle after that. Has anyone done anything like this? Could you use html or so? Mapping?
If you got a flow or a snippet of code or anything that could help me out I would be most grateful and very happy :-)
Best regards,
AngelAtwOrk

BoBo
Posts: 129
Joined: 05 May 2014 12:45

Re: A table that is editable on pc also

Post by BoBo » 12 Jun 2014 08:14

Well, you already use a comma separated file (csv). MS Excel uses a semicolon by default for that reason ...
... ; last name, first name ; ...
But as far as I remember you can configure it easily to accept it both/instead.
Check out these: alternatives

If you have to do a local conversion on your smartphone that should be possible with AM.

Action:Init variable text file
Action:Script > replace(file_text, ";", ","), replaceAll(file_text, ..)
Action:Write to file

■String replace(String s, String search, String replace)
Returns a modified string by replacing all occurrences of search with replace in string s.

■String replaceAll(String s, String regex, String replacement)
Returns a modified string by replacing all substrings matching regex with replacement in string s. (see Regular expressions.)


That's it. Noobish style. There might be other (more sophisticated) options available. :)

Post Reply