Search Results for 'script'

[Brendan]

Hi David,

Ya, I’m not planning on providing PDF form filling out options. There’s an app called PDFPen which I believe can do that. It’s a different kind of app really.

I think you might be able to make an AppleScript to take the CSV file exported from Tap Forms and open it in another app, but I’m not an AppleScript expert, so I don’t really know.

Sorry I couldn’t be of more help.

Thanks,

Brendan

[davidcsie]

Hi Brendan – have/tried a lot of databases but your’s has really impressed. Major selling point is it’s cooperation with textexpander. Are you planning to enable their fill-in snippets?
And the other thing – As a surgeon I need to gather data and fill in paper forms (consent op sheets etc) Tipirneni have a product called filing cabinet which allows pdf forms to be filled in and the data stored. They have simplified form design brilliantly to the point that I would like to use tap forms for data collection and their filing cabinet for printing out the collected data. Is there some way to create a script to export a file as csv and be opened in their app.
Thanks for your help. I did go through the forum but saw a similar issue about using pdf as form background came up a long time ago and assume you’re not planning implementing it anytime soon.
David

[Janeen]

Update: I think I solved the problem…

I’m referring to the iPad version. I created a garden plant database form. One of the fields is called plant description which I created as a regular text field. When I used the tools palette at the top of the screen and tapped customize forms to change the plant description field to a note field, the change would not update unless I exited the form and open it back up again.

I later realized that the small boxed arrow on the actual form in the lower right corner allowed me to customize that field in real time. New to the app so still figuring out how it works.

One other thing… I’m trying to create a ‘date created’ field for when I enter my plant information and another field called ‘date modified’ for when I make my daily or weekly changes to the plant information. I’d like the ‘date modified’ to reflect the date and time the changes where made. Can you tell me how I might set up these fields correctly?

Thanks for your help!

[rjkantor]

I have found that SQLiteManager has a scripting capability and I have been able to write a report that pulls from Sqlite using the Lua scripting language. There is potential with this approach.

For more info: http://www.sqlabs.com/sqlitemanager.php

[Brendan]

Hi Matt,

Thanks for the feature suggestion. It’s something I’ve considered for a while now. I know that the 1Password guys do an amazing job of that sort of thing. It would certainly be doable to provide a quick popup list of field and values to pick from to insert into a login form. But auto-login is kind of out of scope for Tap Forms. There’s a lot of Javascript programming that needs to be done to get that right and I had never intended on Tap Forms to be JUST a password manager, so I didn’t spend a lot of time working on that area. But I do recognize how valuable that would be to a lot of users. So I’ll see what can be done for a future update.

Thanks,

Brendan

[murphy917]

I just purchased tapforms for mac, ipad and Iphone and have started to try to figure out a workflow for managing a newly created business that sells furniture and showroom samples.

Im looking for any suggestions from the tapformz community to help with creating a workflow to be able to create a process of creating a workflow from the point where we purchase new furniture and check it in the warehouse to input the info needed to then upload the form data to a webstore such as big commerce, 3dcart or any other sales cart (could be wordpress or hosted cart, I’m open to suggestions)

My question to the community is this…

Does tapforms seem like a good foundation for this purpose?
or is there a better solution that might work better?

I really like the tapforms software and will use it for a lot of personal forms so either way, thanks to the makers of this great product. Love it!

Thanks in advance for any suggestions to help with creating this workflow…. I cant quite figure out what would be a simple process to get my inventory with photos, descriptions, etc…. from warehouse to web in an efficient way without having to create each individual product and upload each photo. With about 300 pieces, this would take forever. However, it just may have to be that way….I hope you all have suggestions.

Thanks,
-Murph

[Lateral]

Hi Brendan

I thought that I would list these in a single post:

1. Provide ability to email total backup of Tapforms environment – Currently you can create a backup file of your total Tapforms environment including all forms and data but this requires you to be connected to itunes.

2. You currently have 4 seperate options under Database Maintenance..add a 5th option to do all 4 functions in a single operation.

3. Provide ability to auto switch screen orientation for forms into Landscape mode.

4. Add new field type called “Calendar Event” that adds a calender event directly to you Iphone Calender with a description/Note of your choosing.

5. Add new field type called “Note with Date” that adds the current date each time the Note field is opened or when the use enters a special character from within the text that they are entering.

Regards
Greg

[Doujon]

Hi. I have 2 very simple forms. The first is a list, it has 2 fields – stock code and description (although it could potentially hold a lot more information), the second form is used for counting stock. I scan a bar code and enter a qty.
Is it possible to scan a barcode into the second form (which is a stock code) and have the matching ‘description’ data from the first (list) form imported into the description field of the second form automatically?

Cheers

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