Search Results for 'script'

[Steve Morris]

I use tap forms regularly. I have several applications but the main one is collecting data to help me manage my diabetes. As a basic data base it is working well, especially with the enhanced search. The one thing I wish I could do easier is share data outside of tap forms. For example sometimes I want to send some data to my doctor. Also I use the Pythonista app a lot. Pythonista is Python integrated with ios so i write a lot of scripts. I would like to write Python scripts to analyze my diabetes data. To do that I would like to send the data I just entered to a script which then looks through recent history and gives me advice. Python is heavily used in the science world for numerical analysis. Pythonista includes the core data processing and plotting libraries used for this (Numpy etc.) I would like to use this capability to analyze the data I collect in Tap Forms. The two apps seems like a perfect fit to me.The best iOS database app connected to the only usefull and fully functional scripting language that runs on iOS.

Tap Forms is close. I have saved a cvs file down in the files menu then shared it. (I can put my Pythinista scripts in the Apple Share menu.) However in Tap Forms this process is so tedious. I counted and the process of sharing csv data has seven steps and that doesn’t include managing the now useless files. So I did it once, plotted my blood sugar data and never did it again. It is worth doing once in a while but I want something I could do almost every time I enter data.

However I recently noticed that that when I select a record there is a share button. I was very excited. That is only two clicks away from the record. Today I decided it was time to get back to writing some scripts. I started with my demo share script at that just captures the data. The shared data was a large tfarc file presumably containing the entire dataset. It is big enough. What the heck am I supposed to do with a tfarc file when I asked to share a specific record? This makes no sense to me. If I understand what a tfarc does it should only be shared when you are in a global context, not when you are looking at a single record.

Major disappointment. Not what I was hoping. I still don’t have a convenient way to share data with my doctor and write scripts to help manage my diabetes. tfarc is only interesting to Tap Forms. My doctor doesn’t use Tap Forms (she can open .csv files) and I don’t know how to unpack a tfarc in in Python.

A request. The share functionality can share more than one file at a time. It is common to share data in multiple formats for use by different apps letting the app choose between the different kind of files. For example text files could be shared as raw text, markup and html. Could Tap Forms share both a tfarc and a csv file at these share menus? That should be backwards compatible.

Ideally there should be 3 ways to share a data set depending on were the user selects share.

1) At the record level the shared csv should contain that record.
2) In the search function the shared csv file should contain the selected records of the search.
3) At the top level the shared csv file should contain the entire data set.

Tap Forms is so close to what I need. I’m convinced that a close binding between Tap Forms and Pythonista scripting would get you a completely new source of customers. There is a whole world of scientists out there (and anyone else with large datasets to process) using Python to interact with databases.

[Steve Morris]

BTY: Thanks for the search update in version 5. It is spectacular. It is very powerful. I use it extensively. If only I could figure out how to delete a search I no longer need.

For the last two weeks I have been trying to figure out how to add a field to an existing form. I went through every screen and touched every button and couldn’t find anything. I use Tap Forms every day but mostly the same form. (I’m diabetic and log a bunch of stuff every day.) The result is I knw a lot about entering data to that form but noot much else. It has been a long time since I edited a form so I blamed my memory. I googled the question and eventually found that it was supposed to be under tools. It isn’t there.

Why isn’t it there? I searched some more and found a note about “hidden” forms (which I have never used because I can’t figure out why I would want to hide my stuff from myself) and a description about how to get to customize from a record detail->share. I didn’t think my form was hidden but who knows what I might have done by accident so I gave it a try. Sure enough I was finally able to add my field. While i was there I checked the hidden attribute. It is Off! Come to think of it it shows up in the regular forms menu so how could it be hidden?

So why no Customize in the tools menu?

Confused.

-steve

[mrbill]

Howdy- I now this doesn’t exist today and is probably hard to do, but I’m looking for a behavior that is similar to the availability of a Spreadsheet style field. Ok, let me explain:

I’ve created a project management database and on one of the layouts, it would be awesome to be able to create a sortable spreadsheet style list. I’m trying to create a bug tracker, but would like it within it’s own form (hard to explain). So, if I have a form that has some other fields in it, it would be great to have a field that lets me enter data spreadsheet style and then sort that data within the field.

So, I had the idea to create a separate bug tracker form (which I did) that just has priority, title, description, class, and notes (nothing fancy). I then created a link from/to form field and put that into my project management form. BUT, the problem is it shows ALL bugs from ALL the projects. Not really ideal.

Does anyone have a hack that will let me basically embed a sortable list as a field inside a form. I know, that’s complicated and a mouthful.

Thanks!!!

[Kimberley Hoffman]

You could try mine, I don’t know how well it will translate. It was the first time I tried putting in a background photo. The font I used on the layout “The Pattern” is Amberly, which I bought from MyFonts.com. You might have to replace it with a similar script.

Try it out. I’d like to know how well it works for you.

Attachments:

You must be logged in to view attached files.

[Ian Longley]

I’m an accountant. For a small business my current preference is QuickBooks Online. Here in Australia there are 4 different subscriptions available – Self-Employed, Simple Start, Essentials and Plus. However if your bookkeeping needs are very simple an app may be all you need. For a small sports club I use the iXpenseIt app from FYI Mobileware inc. on my iPhone. For the same club I use TapForms to maintain a membership database.

[scneophyte]

I searched for the old thread but couldn’t find it.

Currently, I import expenses and sales (separate forms) records which are related to the Projects form (parent form).

The Projects form has a link to the expenses / sales forms and the “Show Inverse Relationship” is checked. There is a similar link to the child records for Company and PO/Invoice forms.

Once the records are imported, I still must go through and link each record to its parent, three times on some records.

While importing does save time and reduces the incidence of transcription errors, it would be nice to not have to make this selection at all.

I just tested it in 5.4.1 and, while the import wizard screen successfully shows the field type as “Link From Form” and the CSV contains a valid entry, nothing is populated after import.

Any update on if / when support will be added for “Link from Form”?

[ArsAstronautica]

Quick question, I am about to set up some forms for a manuscript project and I am wondering what the limitations are on Note and Text Fields. The later are fixed to the box size, but the former are scrollable and seem to be able to take quite a bit of text. Is there a limit on the Note field?

I do not expect to have megabytes of text in a Note field, but I could have as much as 10-20k for some entries. Most entries would only be a few k.

[Paolo]

I’m not a great developer, I write only piece of codes and silly apps but I really comprehend how could be difficult to implement this request.
For now I use a self-made script that trasform the csv file exported from tap forms in iCal format and then automatically asks me to choose a calendar from the list where import the iCal file. My event form has two “date and time” fields, one for starting date and one for ending date. The script reads and takes data for each field and import the event in Calendar app. Obviously I use this script to export from Tap a large number of events.
Starting and ending date are fully supported by default Calendar and I really really hope that you can find the way to implement that.

Thanks for your time!

[Bob Bower]

Hi Brendon,
The new update was working and looked great with the Helvetica Condensed Medium font I need to use—-until I saved a backup! And then all the text in the fields reverted back to Helvetica Regular (True Type). The Text inspector, however, is working. The sudden switch back to Helvetica Regular when I made a backup, I can’t fathom why.
Yes, I can go back again and change everything to Helvetica Condensed Medium PostScript Type 1 font—-a big waste of time–but now I’m scared it will do the same again.

I’ve attached a form template showing how Helvetica Regular messes up my form—-how I now have to raise each field a couple points to match the underlying form and how the fat Helvetica is too long for some dollar amounts to display.

Funny thing is: Other layouts use Note fields and the Helv Cond Med is not affected at all, any time.

Question: If a future update causes problems, how does one go back to a previous version?

Is there a way to tell Tap Forms I want a default font different from Helvetica Regular.

Are True Type fonts more reliable and stable than PostScript Type 1 fonts? (There could be something weird about my Helvetica Condensed Medium. Perhaps I should try another condensed font and see what happens.)

Regarding the previous $0.00 Text Field quirk, it doesn’t happen any longer with the new update. Not sure what the problem was but I got it to repeat the funny behavior several times under the 5.1.2. Now, creating a new text field is fine.

Thanks,

Bob

Attachments:

You must be logged in to view attached files.

[Bob Bower]

Hi Brendan, Thanks for jumping on to this. I’m using Mac’s internal Font Book. I see that Helvetica Regular is True Type. The font I use and specified for the fields is Helvetica Medium Condensed, a Postscript Type 1 font. Not sure if that makes a difference. Maybe a TrueType font would work better. (Although, Helvetica Med Condensed was working prior to the update.)

Yes, fixing the inspector’s ability would be great.

One little thing for the future regarding the type inspector bar that has the align icons… Gosh, if we could have the icons with ability to distribute spacing between fields vertically and horizontally, that would be a godsend. It would save so much time getting fields positions perfectly.

Carry on the great work and support, you geniuses!

Bob

[Mike Schwartz]

Hmmm, I think Jimmy is looking for something a little different, which might require a scripting capability or a new twist on an IF statement. In Jimmy’s actual case, each address might comprise several fields such as street/city/province/postal_code, but that’s irrelevant for this discussion. It’s essentially this:

1) You have two text fields: Property_Address and Billing_Address. BOTH fields are editable by the user.
2) You have a checkmark field: “Billing_Same_as_Property”.

==> If the user checks the checkmark field, then the contents of the Property Address field will be copied to Billing Address field, and replace any content that might already be in the Billing Address field. If the checkmark field is unchecked, then the user can enter anything he wants into the Billing_Address field.

I could envision an “IFEDITABLE” function that works like this:
IFEDITABLE (test_condition, [field is editable by user], [calculated value])

So in Jimmy’s case, his Billing_Address field would have this formula:
IFEDITABLE(Billing_Same_as_Property=0, [field is editable], [Property_Address])

Something to add to the wish list?

Thanks,
Mike

[Brendan]

Hi Luka,

Thanks for the feature request.

I don’t have an automated way of exporting the data. I would like to add AppleScript support at some point for tasks like that. Just haven’t had time to do that yet. For now you would have to manually initiate the export to a CSV file.

Thanks,

Brendan

[Tim Flick]

I have a expense tracker form that includes date, payee, sales tax, amount of purchase, gallons of gas, description, copy of receipt. I know what my available income per month and annually are. What I want to do is to be able to calculate is total spent each each minus available income to show savings each month and also to calculate the total spent for the year less available income per year

Thanks

T Flick

[Mike Schwartz]

Just got Tap Forms 5 for iPhone and began the process of sending my document file from my Mac to my phone. Tap Forms was running on both devices, my document was closed on the Mac, and I initiated sharing. My iPhone showed up in the device list, I selected it and got started. The iPhone prompted me to accept the file transfer, and things got underway compressing and sending. The file itself is approx 230 MB. A little more than half-way through the transfer it stalled with this error message:

Error Domain=MCSession Code=5 “Resource transfer cancelled” UserInfo={NSLocalizedDescription=Resource transfer cancelled}. I didn’t touch anything during the transfer — Honest!

I tried to restart the transfer, but it wouldn’t start and the Mac app showed a “Waiting” button on the “Select Device” sheet. Clicking the Waiting button resulted in the “Accept Document” prompt reappearing on the iPhone, but after tapping OK, nothing happened.

Then I restarted both the Mac and iPhone apps and tried again with the much smaller Sample Documents file. This one copied over successfully, so I then retried my 230 MB database document. First try, I didn’t get past the “Waiting” button, but the second try it compressed the file and began sending it, and the transfer completed.

So, mission accomplished but not without a struggle. I’m using OS X 10.11.6 on a mid-2009 MacBook Pro, and iOS 10.2.1 on an iPhone 5. Any thought on how this could have gone more smoothly?

Thanks,
Mike

[Brendan]

Hi Philip,

No I’m sorry but there’s no scripting function in Tap Forms.

Thanks,

Brendan