Search Results for 'script'

[czuch]

Sorry, I should’ve been a bit more descriptive.

Allow me to go back to my previous example with 100 records, and let’s assume the following creation date distribution:

records 1-80: All created on the 1st of June 2014
records 80-100: Created in one day intervals starting 20 days ago

Now the problem is that then the date Table Index displayed on the right is laid out so that 80% of the space (20 days) is dedicated to the last 20 records, while the first 80 records are almost impossible to scroll through using the Table Index because they are all crammed into a tiny space.

Visually this would look like:

| June 2014 |
| October 2015 |
| October 2015 |
| October 2015 |
| October 2015 |
| November 2015 |
| November 2015 |
…

If, however one could use that “creation index” (by that I mean the ordinal by which is created, i.e. the “row number” on a spreadsheet) to map to the Table Index instead of the date, then I would get a linear Table Index based on the number of entries, but still sorted by their creation date. So then the 80 records created all on the 1st of June 2014 would take 80% of the Table Index height:

| 10 |
| 20 |
| 30 |
| 40 |
| 50 |
| 60 |
| 70 |
| 80 |
| 90 |
| 100 |

Let me know if you still have questions, and thanks for your interest in any case!

Thanks,

czuch

[Andrew Mead]

Hi Brendan

Thanks for the quick response. Are you able to confirm if the move to the new database engine will be a free update ? I realise that a major new version may require a new subscription but I am concerned that the product needs to be able to handle a few thousand records so would not want to have to pay for an upgrade for just that database engine migration or are the 2 things linked ?

Thanks again

Andrew

[Trey Childs]

So you could have several fabrics, of different types, colors, lengths, etc… For the most part, I’d guess that it’s fairly specific to the pattern. It sounds like that could be accommodated with a link to another form, one to many, and hidden from the usual display. Let’s call that form “Fabrics.” You could add as many or as few records for fabrics to a single pattern, for each pattern.

With a fabrics form, linked to your patterns, you could specify a description, length, cost per yard, number of yards, and a calculated cost for each fabric. The sum of the fabric costs could be shown on the main pattern form, with a “tokenize” function.

The fabrics would have to be entered manually, unless someone has a more clever idea to import records into the fabrics form and associate them to patters, one to many.

Does this help?

[Trey Childs]

Hi Judy,

If by barcodes you mean Universal Product Codes (UPCs), then you wouldn’t get much more than the product name. Still, you could search off of a product code to see if you have it in the database. It’s possible to get all of the UPC information available (outside of TapForms) for any codes you have and use it as an import file. This would help you identify if you already have the pattern. There is a UPC lookup website where you could enter a few codes and see if it is descriptive enough for your needs. If you decide that you need hundreds of codes processed that way, let me know.

Any fabric info would have to be entered in or associated for each item. I would only add that kind of detail as needed.

I’d like to know more about what you’ve tried so far and see if I can help. Have you contacted the person who posted the recommendation on the sewing blog? Perhaps you could get them to export a template for the structure they use.

[Yvette M]

It’s not working for me.

I imported my credit card statement. It’s very simple.
These are fields:
Name And Type
1. Date – Date
2. Card # – text
3. Description – Note
4. Debit – Number
5. Credit – Number

My form has a calculation set to the field debit

Both Debit and Credit has summary calculations set to total.

I saved a search where the field credit is set as not empty so the resulting list is that of all my credits.

I’d like to see a total of just those records. Instead the search result list still shows debit at the bottom with a total of $0.00

What aren’t I doing?

I know it should be simple!

Thanks
Yvette

[Brendan]

Hi Doug,

Which version of Tap Forms are you using? Mac or iOS?

On the Mac version you can access it with the following menu command:

Layout > Font > Baseline > Subscript/Superscript

It’s not available on iOS.

Thanks,

Brendan

[Doug Adler]

Is there a way to include subscript and superscript? For example the scientific forumla for dihydrogen monoxide (water) is H20. It would be great to have the 2 a subscript.

[Germaine Oliver]

Hi, I’m a new user… I don’t know if I’m doing something wrong, or changed something in a particular record somehow…

I have a form with several fields, one of which is a text field called “description” with no pick lists. I have a record that doesn’t return when I think it should… the description says “Spiderwebs”, and no portion of that word returns that record. Other descriptions seem to work as expected, but I only have 30 or so records, so it’s hard to test well…

Why would a particular record not return with a search?

[jarrod b]

Hello Tapformers,

Ok so I just downloaded Tapforms for IPad and need some help getting set up.

The main form I am using is an inventory with these fields

1. Photo
2. Description
3. Product category
4. Retail price
5. Purchase location
6. Purchase date
7. Sold Y/N
8. Cost price
9. Profit (retail price minus cost price)

I would like to use another form that refers to the inventory form to calculate things like

1. Total profit of sold items
2. Cost price of unsold inventory
3. Average profit percentage
4. Total unsold inventory

How do I go about setting up a form to calculate this information?

Perhaps in the advanced calculation field?

[Rob Tn]

Since I struggled with the similar sync problems I post my ‘solution’: I found out that on my Macbook (10.10.3) there is a difference between two folders that are being used by dropbox and tap forms. One folder is hidden in the Library (Bibliotheek), one is the regular DropBox folder. They seem not to be in sync on the local harddisk and therefore also not in sync online. So it might be that TapForms is using the wrong directory (and also missing the sync files of the other devices!) or DropBox is missing out the hidden folder. When manually (or with a script) merging these two folders everything is working fine.

Hope this helps

Attachments:

You must be logged in to view attached files.

[Brendan]

It would be great to be able to keep iCloud Drive and Dropbox as options, and who knows, maybe I can swing that, but iCloud Drive and Dropbox are fundamentally just folders on the Internet that contain files. They know nothing about the logic behind syncing. With Couchbase, there is a syncing protocol built-in to it which requires both end points to understand that protocol. It’s like two people needing to know the same language in order to communicate effectively.

99% of my email support requests are about people not being able to get Dropbox or iCloud communicating properly. Once it’s all working it’s generally fine, but there are also some things you have to be careful of when managing your syncing. That’s what I’m hoping to solve with the move to Couchbase. Since it’s a database engine that has built-in sync, it should effectively be a turn it on and forget it affair. I’ve done some experimenting with their sample apps and it’s great to be able to check a box on one device and see that box checked a few seconds later on the other device without me having to do anything more than that.

That’s my goal for Tap Forms.

I realize nobody wants to have to pay for anything more than the base cost of the app once and never again after that, but if a cloud based service ends up costing me money to operate, then I will have no choice but to pass that on to the customer. Imagine me having to pay more to keep the service running than what I earn from only new sales? I’d quickly go out of business and Tap Forms would cease to exist. I don’t want that and I know you don’t want that.

I may eventually be able to allow you to connect to your own instance of the Couchbase sync gateway that’s connected to your own Couchbase server. This would be great for small businesses that want to sync the devices to their own server. A paid subscription would only be required if someone either didn’t want to sync via WiFi and couldn’t run their own sync gateway/server.

Syncing via WiFi is great also because I know a bunch of customers use Tap Forms in the field (for example on archeological digs) and being able to sync over an ad-hoc WiFi network would be great for them. They don’t always have access to the Internet wherever they are. Couchbase is even flexible enough to allow some devices to sync via WiFi and some via WiFi and the cloud. So those devices syncing only on WiFi will eventually get the data in the cloud too when the device that’s syncing with both are updated. Now that’ll take a lot of time and testing to see if I can get that to work and probably wouldn’t be a feature right out of the gate. It’ll all take time.

And here’s another issue I’ve been faced with. The moment I released the update to support Dropbox sync, I got a notice from Dropbox that said they’re discontinuing support for the Dropbox Sync API. Of all the things… I worked for months to add Dropbox sync, only to discover that they no longer support it the moment I release it to production. It won’t cease to function they said, but they won’t be bringing out any further updates to it anymore. So I’m kind of forced to move on from that.

So that’s that for now :-)

Thanks,

Brendan

[Brendan]

I’m just working on the data migration code at the moment. Once I get that done, then I can see if I can get Tap Forms to read the data from the database and display it on screen. Converting all the Saved Searches to a new search mechanism is going to be a super hard challenge because Couchbase does searching totally different than SQLite. But the great thing about Couchbase Mobile is that the sync is just built-in, either via a cloud service or via peer-to-peer WiFi. I haven’t decided about the cloud service to use yet though. There are many options. But it won’t be Dropbox or iCloud. It’ll either be something like http://www.cloudant.com or me setting up a Couchbase Server service on Microsoft Azure or Amazon Web Services or something like that. And that’ll cost me money to run, so cloud sync may become a subscription service. Peer-to-peer WiFi sync would be free.

If you think about what iCloud Drive and Dropbox are, they are just file servers in the cloud. They simply store the files that Tap Forms writes. All syncing is done via the client. But with Couchbase, there must be an actual database server and sync gateway in the cloud that manages the syncing process from all the devices. But that’s the great thing about it, since the database in the cloud becomes the “source of truth”. It will also mean less storage space is consumed by Tap Forms on your devices.

It’s still in the development and proof of concept stages. I’ve got the code mostly written to migrate the database. Still a bit more work to do on that plus migrate all the saved searches. That’s the biggest challenge really.

But the fun never ends developing Tap Forms! :)

Thanks,

Brendan

[Brendan]

Thanks for the detailed description of your sync issues Thinking Cat.

One thing to note is that if you have 3 devices, each with a full copy of the database file already, when you reset sync (or set sync up the first time), Tap Forms generates a sync file that contains all of your data. That’s the TFSyncDoc…[0].tfx file you would see. That file would get synced to your other devices and you would then see the notice in the status bar showing you the countdown. That happens only the one time. Other times the syncing would be much quicker because it has already done the big one at the beginning.

Now, if you have 3 devices, each with a full copy of the database, Tap Forms will do that for each device you press the upload to cloud button on. That’s because Tap Forms must merge the data from all 3 copies of the database. It doesn’t know that it’s all the same, but it still needs to process it to find out. So when you’re standing in line at the store, yes, you might see that message, but that’s only the first time. Subsequent syncs should be much smaller and quicker, unless you’ve added a lot of data in between syncs.

Since you have 4500 records, each with possibly a photo or two, it could take Tap Forms a long while to sync those records up to Dropbox. Syncing happens only while Tap Forms is actually running. If you put it in the background, the process stops.

And with so many photos and/or other files in Tap Forms, those files may be getting uploaded to Dropbox before any of your TFSyncDevice or TFSyncDoc files. That may be why they’re coming in considerably later than expected.

As for the 0 bytes thing on the Mac version, that’s just what Dropbox does. I’ve seen a 0 byte file sitting there for a while before and then finally Dropbox finishes syncing the file and then the file size gets updated. Tap Forms would then proceed to process that file once it has finished downloading from Dropbox.

I hope that clears things up a little bit. I know this all isn’t ideal. Believe me, I wish that I had a much better sync system. I’m currently investigating various services to see which one would allow me to write a better sync system that used a central database rather than the TFSyncDoc and TFSyncFile syncing like I’m doing now. I chose that way because I can write all the code on the client side and not have to write any server side code. Plus Dropbox and iCloud are free for most users (depending on their storage size). Other services would charge money for syncing. I’ve been investigating Microsoft’s Azure product which seems pretty good. But there’s a fee for using it and I’d have to pass that cost on to the customer. Not only that, but I have to write a bunch of server side code to manage syncing and that could take a long time. I contacted the guys at DayOne to see how they’re doing their new DayOne sync service and they said they’re using Amazon AWS and it took them 7 months with 3 senior developers working on it full time. Here at Tap Zapp Software, it’s only me. I am Tap Zapp, and so if I were to attempt to replicate what they have, I can imagine it might take me more than a year.

But nevertheless, I’m still investigating to see if there’s a better solution to all this. Believe me, I want a better sync system too. 99.9% of my support requests these days are that people are having trouble syncing. Eventually we usually manage to get it going. Although I wonder if ANY one is able to sync. It works every time for me, so I don’t know what I’m doing differently or how my Mac and iOS devices are setup differently than other people. It’s a very challenging problem to solve. I have had some people say Dropbox sync or iCloud sync is working perfectly for them, so I do know it can happen. It seems that everyone’s got their own unique situation with different database sizes, different numbers of external files (photos, file attachments, etc.) and different networking environments.

I worked with one guy from Australia for a couple of weeks trying very hard to get Dropbox to work for his Macs in the office. It would never work with their main user accounts. But it did work with test user accounts he setup on the same Macs. So is that a Tap Forms problem or a Dropbox problem? It’s hard to say really.

Anyway, I’ve gone on long enough now.

Sorry for the rather lengthy, and probably not very helpful response.

Brendan

[Brendan]

Not much to go on with your description. Do you mean that after you pressed the upload to iCloud button, that it stopped midway during an upload? Or syncs don’t come down from iCloud anymore to your other devices?

Can you try the following command in the Terminal application on your Mac:

brctl log -w

Check to see if there’s any TFSyncDoc or TFSyncDevice file names being written to the log output.

Try rebooting all your devices.

Does iWork still sync on your devices? E.g. Pages, Numbers, or Keynote?

Thanks,

Brendan

[M H]

Hi Brendan,

I understand the difficulty with implementing that kind of share option when the data isn’t in a format that can be easily shared. I appreciate that you have it on your big to-do list. There are only so many hours in the day, right?

For my uses, sharing a PDF of the data wouldn’t be very helpful. I’m trying to use the app as an easy way to enter customer data when they call. Ideally, I’d be able to export the data straight to a spreadsheet or csv file so that I can use it elsewhere for creating invoices and store it for future reference/search ability.

That’s why I’d also love to see the formatting layouts from the Mac version be usable/printable from the iOS app; after completing work for a customer, their info would already be in the app and I’d just add to that to complete their invoice and print a copy on site.

With that setup, all the data would be in my hands instead of having to rely on some proprietary, subscription-based cloud invoicing software.

There are probably a ton of higher priority features that would be easier to implement and more useful to the majority Tap Forms users, but I thought I’d throw my two cents in. Can’t a guy dream? :)

Thanks again for all you do!