Search Results for 'script'

[Brendan]

Hi Paul,

I’m sorry, but I don’t have any experience with scripting with Number or any other program. Hopefully someone else on the forum can help you.

Thanks,

Brendan

[paulwebb]

anybody ant ideas. I keep thinking some sort of script. Happy to use windows excel if that helps any one.

[Case1001]

Hello

I am wondering why the bar code scanner search function works fine on Iphone version (global database search not Search in database) ? but not on ipad version I am able to search by description but not scan a bar code?

[paulwebb]

Hi love the app. I want to get my data out into spreadsheet, easy. I have table relationships, less easy.
I would like to do this monthly so that I can compare data. Same process every time. Is there a way on the mac with numbers to automate imports and layout like a scripting language. Anybody else tried this? If so happy to hear advice.
Thanks

[baizyeh]

Hi Brendan,

I was going to ask if you have a plan for PC version but since it’s not going to happen so, do you have plan for web version of Tap Forms? I mean something that you host on the web so that users can add entries. Not sure if Apple’s API supports this kind of collaboration (especially on iCloud) but, if it’s only adding entries this might be easier for you to build compared to building a PC version.

I have a Mac so I can grab the Mac version, but I boot to Windows (which is what I work on mostly) so it’d be really appreciated if there’s a cross platform solution. I think you can make it subscription or quota based sort of service, people won’t care, as long as they will be able to enter information on OSes other than Mac.

P.S.: I really love Tap Forms. When I bought my first iPad last week I immediately bought the HD version, took me time to setup iCloud but working like a charm now. (-; Please keep the good work!

Baiz

[Roo]

I need to export linked forms and their records to other devices that are not on the same iCloud account. I had trouble doing this and had to get exact instructions from Brendan to get it to work so I thought it would be helpful to share my experience on the forum in order to assist others.

1. Export Settings

Before starting any transfer of linked forms you MUST ensure the export settings are correct. Open the Tools menu and select Import & Export Settings. Ensure that both Export Record ID and Export Linked Data are turned ON. Turn on Export Media too if your forms have media in them that you want to transfer.

2. Export Parent Forms

First you need to install the forms on the destination device. This is easiest by email. Open the Tools menu on the first device and select Customize Forms. Scroll to the parent form that has the links in it and select it. Use the Action button to then select Email Form to send the form to the other device(s).

I made the mistake of also sending the linked child forms this way but this is not necessary as Tap Forms automatically includes a copy of the each of the linked forms when you export the parent form.

3. Import and install Parent Forms on second device

Next you can open the form in the destination device by tapping and holding on the .tff icon in the email on that device. This brings up the dialogue where you select the option to Open in Tap Forms HD. On selecting this, Tap Forms will open and you should get the dialogue “Form Import Complete” which you OK. Note that in order to see the forms appear in your list of active forms you will then need to import some records. You can check that the forms are there by either clicking the + button in the main form menu or going to Tools; Customize Forms where you can see all imported forms.

4. Transfer Linked Form Records

To transfer the records for the forms you must also export records separately. Open the parent form in the first device so you see the list of records. Select Email Records from the Action button to send them to the other device(s). This will send a .zip file which contains a .csv file of both the parent records AND the linked child records. It will not send any additional records in the child database that are not linked.

5. Transfer Additional Records

If you want to send extra child records that were not linked, you can also send them by opening each of the child forms and emailing their records in the same way as described above. This will send an unzipped .csv file for each form containing all of the records in that database. Only do this if you have additional records that you want to transfer in addition to the linked ones.

6. Import Linked Records

To import the linked records tap and pause on the .zip icon in the email on the destination device and choose Open in Tap Forms. This will open the Imports screen in Tap Forms with a copy of the .zip file in the list. Tap Forms offers you the option to unzip the file and Import it on this screen but this produces an unformatted copy of each list of records in the main directory. Because these have no template attached to them the links will not be present. It is a mistake to do this as I found that I HAD TO delete these automatic forms and records before I could successfully import the records into the previously loaded templates.

The correct way to import the records is to dismiss the Import dialogue and instead open the Parent form by tapping the + button in the main form directory (which will create an extra blank record when it opens) and then select Import Records from the Action button. This will re-open the Imports screen where you can see the imported .zip file. Tap on this and then choose Unzip File. This will open the parent and child .csv files in a folder with the same name as the original zip file. Then you can select the records for the parent form and import them. You may not see them appear immediately in the form records list but if you go back to the main Forms directory you should see the form listed with the correct number of records (plus the extra blank record) in grey. Once the parent form has been successfully imported, you can then import the child records in the same way by opening each of the forms and importing them. It is important that you import the parent records first though. Lastly you may want to delete the extra blank record from each list to keep track of how many records you have in each.

7. Import Additional Records

If you also exported the full child .csv files of records and want to add the missing records to the already loaded forms you can now do this. However, like with the first import, I found it was necessary to make sure that they are imported directly into the correct form rather than using the Import function in the Imports screen. Follow the procedure described above to do this and then you should see the extra records have been added to the already imported records. Doing this will not break the links of the previously imported linked records.

This rather full description of the process makes it all sound complicated but it is actually pretty straightforward provided you follow the steps in the correct order. If you find that imported records don’t show up after going through the Import process, it is probably because there was a pre-existing form with the same structure already present which needs to be deleted beforehand.

[Arash]

Thanks very much for the lucid and clear description of the problem, Brendan. I learned quite a bit from it, and will eagerly await Apple’s approval of the update.

[Ben]

Hi Brendan,

Sorry for my slowness in replying!

Perhaps the rules are stricter for .webarchive files because of their ability to execute scripts and load Java applets, but it still seems odd when a web archive ‘owned’ by Safari has the same characteristics. Still, it appears to be a part of the Gate Keeper system, so perhaps there’s an attack vector whereby a signed and trusted application could generate malicious web archives. I don’t know. Whatever way I think about it, it doesn’t make a tremendous amount of sense, but I’m not a security expert and nor am I a programmer, so unless it is a bug there must be a reason behind it!

Thanks again for your attention in this matter!

Ben

[jolinwarren]

First of all, thanks for the new ‘Export Linked Records’ and ‘Export Media’ features. Excellent! However, I have a couple of questions:

(1) When exporting linked records, it seems that, if ‘Export Record ID’ is also switched on, the linked records contain the Form ID, Field ID, and Record ID(s) of their parent(s). However the exported parent records do not contain the Record ID(s) of their child(ren). The linked records column in the exported parent form is blank (except for the header row). It would be useful to have each parent record contain the Record ID(s) of their child(ren). To my mind, this is more logical as well and would probably work better if trying to programmatically work with the csv data (using AppleScript for example).

(2) More importantly for me, it does not seem possible to re-import a form with its linked records. If I export a form with linked records, I get the zip file that contains a csv file for each of the parent and child forms, listing al their records. If a record is linked to multiple parents, the child csv has duplicate records that contain different parent IDs (because of (1) above). But if I then re-import the parent and child csv files to Tap Forms, I get two new, unlinked forms. So I can’t use this feature to export my data from a form and then re-create it, links and all, on the same or another device.

I don’t know if I’ve explained this very well, so let me know if clarification is needed. These aren’t urgent issues for me, but it can be useful to be able to move data between forms or devices without sharing/syncing everything.

Thanks,
Jolin

[tanseycg]

I just stumbled across Tap Forms and all I can say is WOW! I have been “developing” various database solutions for the last couple years and the simplicity of Tap Forms is wonderful. This is a great personal database solution that will become my goto app for quite some time.
Probably my favorite part is that I can create a form on my iOS device and not be stuck behind a computer screen making sure all my fields line up. Here are some of my other favorite features:

iCloud sync…enough said! No need for crazy scripts or expensive/slow servers.

Dropbox integration – WOW! I can import any file from my dropbox directly into my form while on an iOS device…The only thing I could “attach” in the past was a photo, signature or other database file.

One-size-fits-all – I can create the form on any device (iPhone, iPad, Mac), and I don’t have to develop any special sauce to make it look good on a different device.

Linked forms – In the Db world, these are called “relationships” and are more difficult to maintain than a failing marriage! Using the simple, one-to-many and many-to-many concept is quite ingenious and refreshing.

One small caveat…my comments are directed toward personal or small group use. I would love to see a way to use dropbox sync for the form so other users can work from a shared folder. I am not sure if this is possible due to potential “conflicts”, but it sure would be a nice addition.
I can’t wait to learn more about the app and it’s capabilities as I dig a little deeper into it (I’ve only been using it for a couple hours). Thanks for all the hard work and I can’t wait to see how Tap Forms evolves and improves over time!!!

[sigamy]

Sorry if this is an FAQ. The search here doesn’t seem to be working for me.

I’d like to create a DVD Collection database complete with cover art, actors, descriptions, etc. Is there a way to automate the data pulls from the web after scanning the bar code similar to how Delicious Library or Booxter do?

How are folks getting large DVD collections into Tap Forms? Manual entry?

[DreamingMD]

Hello,

As you may know, we Md’s produce usually a report for each patient visit, sometimes several per patient visit.

Tha’ts what transcriptionists and secretaries are paid for.

Many of us can’t afford a secretary or need to produce real-time reports.

So we devote a lot of time to typing.

As a specialist , my reports follow a consistent pattern

There are changes in values or refferal names or findings, with a custom conclusion. Full Dictation is not yet mature on IOs

What I really need is a way to tap a form…. And get a letter ready to print and archive.

The geeky way would be to tap, export to csv, FTP to desktop, trigger automatic mail merge to a template in ms word or OO Writer.

I am sure you can do better : tap, generate letter, edit letter, AirPrint .

Please team up with a word processor maker on iOS or devise one.

You may change the lives of millions of professionals, who would pay for this.

It only needs to be a basic letter formatting, with fields from Tap.

Sorry for the long post.

[Brendan]

Hello Will,

You’ll need to use the Notes field type to view more than just a short string of text from your field. The Note field shows you the entire contents of the field in a scrollable view. You can freely switch between Note and Text field types even after you’ve imported your data.

I’m not sure why nothing got imported into that field though. It’s possible that you don’t have all your quotes in order. If you have any carriage returns and/or newlines in your description field, you’ll need to make sure the field is properly quoted. The same goes for any field that has your column delimiter.

For example:

Movie Title, Description

The Terminator, “The Terminator is

a movie with Arnold

Schwarzennegar”

“Hunger Games, The”, “The Hunger Games is a fantastic book and will

now be a movie coming out on March 23, 2012″

Notice how the first movie title doesn’t need to be quoted, but the second title does because the comma delimiter is within the content of the field. And also notice that the description spans more than one line, so the entire description needs to be quoted.

Check your file to make sure it follows this kind of structure for every single row, including the header row that’s used to match up with field names in your form.

Thanks!

Brendan

[willcook]

I was in fact using a PC, because I don’t currently have access to my IMac.

Here is another problem: one of the fields has a brief description of the tree species, but after importing, what is displayed in the field is only the first five lines. When I tap the right arrow, all I see are the last few words. I tried using the Note template but nothing got imported into it. Having the full description is very important.

Thanks!

[Raymond]

Hi Brendan,

I have a similair issue as Simba. I want to build an inventory for my Scouting group. This inventory will include all kinds of data (description, quantity, quality, measurements, etc etc.) It will also include photos of the material.

So far for taking pictures within the app, things are swell.

But for some items pictures are already available outside the app in the Real World. I would like to import these into the app. I have figured out csv’s import and export. No problem there. Edits can be made on the pc and within the app. But for the photo-part, things look different.

The way you link to photos and where they are stored in your app seems quite straight-forward (I am no expert on ipad and on the way you program these things, but I do know a bit about data structures and file organisation). Within iTunes I can download the pictures already taken in the app to my PC by means of “downloading” the photos-dir, but going the other way (uploading files into this photos-dir) is not possible. You suggest in this topic to transfer the photos Simba has from his PC to the ipad-app and place them in the Photos directory. There things get messy.

– In iTunes I see the dir, but cannot put files in it

– Through webdav and the webbrowser I can only access the Share-folder (and the import and export below it)

– Through FTP I can only access the same folders (Share and all below). I have used Filezilla and just to be sure I also used Cyberduck as you suggest here (although the issue of accessing the dir would be on the FTP-server side, regardless of the used client).

_ I have this in both versions of Tapforms I have tested.

This is my environment

– Ipad2 Ios 4.3 or 4.2, whatever. Jailbreaked because of some principal view on try-before-you buy.

– Windows 7 PC

– Vanilla Wireless LAN

– Tapforms HD

– Tapforms LT (max 15 records version to see if the other version was mutilated in some way)

Thanks in advance for your help.