Search Results for 'script'

[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.

[Brendan]

Hello Steve,

This sounds like a job for the Link to Form field type. You would create two forms. Clients and Payments. The Clients form would contain all the client details plus a link to the Payments form. The Payments form would have a date and a payment amount and possibly a name and description and photo if you want. The Clients “payments” field would be a one-to-many link type. You wouldn’t want to share payments between clients, so that’s why you use the one-to-many link type.

Then, you would create all your client records, then for each client you’ll see the “payments” field all starting with 0 records. Tapping on that would take you to an empty list of payments. Tap the + button to create the payment for that user. The date could be filled in for you automatically if you set that as a default option for your date field.

Then, for the Payments form, set the form-level Calculation to compute the Total of the “payment amount” field. Then when you view a particular client and tap on the “payments” field, you’ll see a list of all their payments and the bottom of the record list will show you the total payments received from that specific client.

Then, on the top-level of the Payments form you’ll just see a whole bunch of payments from various clients, but you won’t really know which client the payments were from because there’s no back-link functionality (yet). However, at the bottom of the records list view of the Payments form, you’ll see the Total (Payment Amount) which will be your grand total of the payments received from every client.

I hope that makes a bit of sense anyway.

Thanks!

Brendan

[Brendan]

Hello Joe,

Pick Lists are just a way of typing in a value by picking the value from a list. No magic there. Linked forms are a way to connect one form to another. In your example, you might have a Customer form with their first name, last name, address, phone number, and a link to form field connecting to a Calls form. Your Calls form might have a call date, a notes field, and maybe a call duration field (or a end time field) and a calculation field which calculates the duration of the call [End time – Start Time].

The above example uses a “One to Many” link type. One contact has many calls. Makes sense, eh?

An example of a Many to Many link type would be if your Customer had a link to a Products form. The Products form could contain many products with their name, description, price, etc. The products field on the Customer form when tapped could show the list of products that specific customer typically buys. Instead of having to add a new product for each customer, you could tap the checkmark button at the top-right and select from any of the records you’ve already added to the Products form.

Hope those examples make it a bit more clear of the differences between linked forms and pick lists.

Thanks!

Brendan

[Brendan]

Interesting, it looks like Memto is very similar to Tap Forms. Although only from the description. They have 19 fields, I have 19 fields. Hmmm….

So a separate password per form? Would that be overkill? Imagine 10 forms and 10 different passwords to remember. You’d need a form in Tap Forms to keep track of all your form passwords!

Thanks!

Brendan

[Anonymous]

please help to implement form record filtering feature like “calculated filed” used in HANDbase.

use this feature for filtering form to generate a new form or change display list of a form.

---

reference of HANDbase “calculated filed” description

Calculated Fields – Lets you perform operations on other fields or constant numbers. The operation is as follows: [Value1] [Operation] [Value2] = Field in [Result Format] When selected, the following options appear:

Visible: Check if you want this field to be visible on the Edit Record Screen. Uncheck if you wish to hide it on the Edit Record Screen.

Export/Print: Check if you want this field to be exported to the memo pad or printed when any of these options are selected: Export Record or Records, Print Record or Records, from the Edit Record or the Main screen., respectively. Uncheck if you don’t wish to export or print this field.

Pixels Shown: Choose the number of pixels in width that will be shown on the Main Screen. There are a maximum of 160 pixels in width on the screen, so this is the maximum value this can be. Setting to 0 will hide this field on the Main screen.

Value 1: Choose the field to use as the first operand. If No field is selected, the constant value written to the right of the words No field is used as the operand. This constant must be either an Integer or Floating point value, although if a field is selected, nearly any field type can be used.

Prev Rec: Check if you want the value for this operand to be taken from the record previous to this record in the sorted order. This is useful for creating running totals, balances, etc. Keep this box unchecked if you wish to take the value from this very record. This option will only display if you have a field selected to the left (ie, the No field option does not apply) NOTE: New records are added to the end until they are saved.

Operation: Choose the operation you wish to perform on the two operands. The current choices are:

+: Add the values.

-: Subtract Value2 from Value1.

*: Multiply the value.

/: Divide Value1 by Value2

Min: Minimum (smallest value) of Value1 and Value2.

Max: Maximum (largest value) of Value1 and Value2.

Average: Average of Value1 and Value2.

Value 2: Choose the field to use as the second operand. If No field is selected, the constant value written to the right of the words “No field” is used as the operand. This constant must be either an Integer or Floating point value, although if a field is selected, nearly any field type can be used.

Prev Rec: Check if you want the value for this operand to be taken from the record previous to this record in the sorted order. This is useful for creating running totals, balances, etc. Keep this box unchecked if you wish to take the value from this very record. This option will only display if you have a field selected to the left (ie, the No field option does not apply) NOTE: New records are added to the end until they are saved.

Result Format: Choose the output format of the calculation result. The current choices are:

To 4 Decimal Places: The output is a floating point value, showing 4 decimal places.

Integer: The output is a numeral.

Time: The output is a time in the format HH:MM:SS. NOTE: The translation to time is the number of seconds into the day.

Date: The output is a time of the format MM/DD/YY. NOTE: The translation to date is the number of days since January 1st, 1904.

To 3 Decimal Places: The output is a floating point value, showing 3 decimal places.

To 2 Decimal Places: The output is a floating point value, showing 2 decimal places.

To 1 Decimal Place: The output is a floating point value, showing 1 decimal place.

[ndroste]

Hi,

I’ve made a form I’m using as a master for a questionnaire, which links to 3 ‘one to many’ linked forms.

If I select “delete all records” for these linked forms in the main form selector page, the ‘link to form’ fields in the master form are broken, and I have to re-select the linked form in the customise form section.

However, if I delete the records from within the form (ie: while entering data, though the master form) the records will be deleted but the link remains intact.

Apologies for the convoluted description. Just wondering if you were aware of this/ fixing it…

Cheers, Nic.

[Anonymous]

Hello Brendan,

My device is not jailbroken, and has nothing special about it.

I installed Tap Forms Lite 2.0.2 on a new iPad 2, Wifi only version and see the same behavior. Here is a more detailed reproduction description, this time done with the same steps on the iPad 2:

Forms page, tap +

Select A Form, tap New

New Form – tap Form Name

New Form Name – enter xyzzy on keyboard

New Form Name – tap Save

New Form – tap Add a Field

New Field – tap Field Title

New Title – enter f1 on keyboard

New Title – tap Save

Edit Field – tap New Form

New Form – tap Select A Form

Select A Form – scroll down to bottom and tap xyzzy

Edit Record – tap f1

Edit Value – enter abc

Edit Value – tap Save

Edit Record – tap Forms

Forms – tap xyzzy

xyzzy – tap the Actions icon

Actions menu popup – tap Export Records

An popup is seen which says Exporting Records, and dismisses itself

Export Complete popup reports “Your CSV file is now available …” – tap OK

Forms – tap the Actions icon

Actions menu popup – tap Import Records

Files – tap Exports folder

Exports – tap xyzzy.csv

Import File – reports 13 bytes, 1 rows – tap Import

Importing File popup 1 of 1 appears, and dismisses itself.

Screen dims and hangs.

I time out waiting for this after a minute, and press the home hardware button, which switches out the app. Re-entering the TapForms

Import Complete popup appears reporting that the file was imported successfully – tap OK

Forms (showing 2 records in form xyzzy) – tap xyzzy

xyzzy – shows two records

David

[GadgetLady]

Okay, hopefully this can be corrected. Nice effort, though. But for now, I can’t take advantage of it. I have 250 subscription customers. For each customer, I set up a reminder 1 week prior to their expiration date. This reminder was to prompt me to send an email, asking if the customer wants to renew their subscription. Besides the fact that setting up the alerts was very time consuming, if I have a problem with one customer’s alert continuing to fire when it’s no longer needed, then clearing the other 249 alerts to get rid of the offending one is not an option.