Search Results for 'script'

[Brendan]

Hi Maxasara,

Tap Forms was not designed as a team oriented database app. I know that some people use it that way, but if you need the ability to control permissions and user access levels, then I would suggest AirTable which is a subscription service which might be helpful for your needs.

Thanks!

Brendan

[Brendan]

Hi Manuel,

Thanks for the feature request!

Right now the only conditional formatting available is on Number and Calculation fields which will display the result in red if the value in the field is negative.

But what exactly do you want to see coloured? You mention the Client should e coloured red or green or whatever. But what does that mean? The field label? The background colour for the record’s row in the list view? The Client’s first name and/or last name field?

I am working on adding the ability for customers to program scripts into Tap Forms to do various things. So far it’s just about calculating results or populating and updating the database, but I could see it being extended to allow for adjusting properties of the objects displayed themselves based on some logic and values from other fields in the record(s).

Thanks!

Brendan

[Tony Moss]

Many thanks for your incredibly rapid reply, Bendan. I confess that about 10 minutes after submitting my post I did manage to get the child form to work, and include the totals per Parish as required. However, I’ve no idea how I did it, and I’m still failing to repeat my success with other data totals from the parent form.

The parent does indeed have separate fields for Males and Females, populated with 1 or are blank as relevant. Both are plain Number fields in the parent form, and the Total Males/Females fields in the child are set as Calculation fields, but with no formula included. As I said, foe some reason when I added the Total fields to the child layout the link just worked! (Not since, though on another linked form – see below!)

These other data totals I’d like are intended to go on a second linked form (created with Parish Names and linked O.K.) and the data fields in the parent are set to 1 or blank as appropriate. Being a bear of very little brain, I’m not too sure from your explanation as to on which form these calculation fields you refer to should be created – could you help here? Also, you mention the “Count” function – I expected to see this in the function list, but couldn’t find it, otherwise I’d have given it a try first!

The inclusion of a scripting facility will be brilliant. I’m very familiar with FileMaker Pro’s built-in scripting – use it a great deal – but the thought of Javascript, about which I know nothing, fills me with trepidation. Be interesting to give it a try, though, and will enhance Tap Forms tremendously.

Thanks again for your help thus far – I’m so impressed with Tap Forms that I’ll certainly be purchasing a copy when the trial period expires, as a really useful back-up to FileMaker Pro.

Tony

[Brendan]

Hi Tony,

Thanks for giving Tap Forms a try for your friend!

What you could do is create a Calculation field which generates a total of the sub-field in the Link to Form field. I’m not sure if you have your Gender field separate or combined though. If it’s combined as a single field to contain all genders, then what you may need to do is create another 2 Calculation fields. One for Males and one for Females. Or perhaps 3, one for Other. Then you could return a 1 if the Gender field is Male and 0 if it’s not. Then for the Female, return 1 if the Gender is Female and 0 if not. The same for Other. Then on the parent form, add a Calculation field for each gender that totals the calculation field you added to the Link to Form field’s form. The net effect of that is to get a list with separate counts for Male, Female, and other.

Your formula for the Male count field on the parent form might look like this:

COUNT::Parent Forms::Male

That would effectively count up the number of 1 values for each of the Male sub-records.

I hope that makes a bit of sense at least :)

In an update I’m working on I’ve added the ability for you to write scripts either at the Field level or the Form level that would let you have much greater control over the resulting value. With the new Script function you would be able to just loop through all the child records, adding up each of the genders and returning a single result that contains the counts of each gender, perhaps like “Male: 20, Female 10, Other: 5”, and so on. Version 5.3 will have that function. You use JavaScript to write the scripts.

Thanks!

Brendan

[James Hayes]

The other benefit is JavaScript is a modern language where as LiveCode and HyperCard are specialized languages for which there is very little documentation and the chances of finding someone to help when you are stuck with code that does not work is zero.

[Brendan]

The benefit of using JavaScript was that it was built-in to macOS and iOS via Apple’s JavaScriptCore framework.

[Barry Levine]

Too bad it can’t be LiveCode’s scripting language (a superset of HyperCard’s HyperScript). Much easier to learn. :D

However, any scripting language is better than none at all, eh?

Thanks very much.

Barry

[Brendan]

Hi Barry,

There is for the Calculation field type right now which provides a variety of conditional expressions. And I’m just adding a new Script field to let you do more advanced scripting in Tap Forms using JavaScript code.

[Brendan]

Hi Rebecca,

So the issue is that a Join Link Type is treated like an automated many-to-many relationship. That means that the parent and child records are both displayed as tables because there can be more than one parent for each child and each parent can have more than one child.

At the moment it would seem the only solution would be to put the address also on the Customer Order form. I know that defeats the purpose of what you’re trying to do.

What you would need is some way of picking out a particular parent linked record from the child record in order to display that. In my next update of Tap Forms I’m adding a new Scripting function which will let you write some JavaScript to extract data from records and return that to the Script field. It’s just like a Calculation field, but much more powerful. So that might work for you actually. Because with that you would be able to pick out just one parent record and then return a concatenated string of the address values to display.

[Denny Tuckerman]

Version 5.1.2(689) on an iPad 2 iOS 9.3.5 (13G36)
I don’t seem to have that option?
If I change the field type from file attachment to anything else the field description is then left justified. Change it back and it justifies right again!

Attachments:

You must be logged in to view attached files.

Leave the Planet (tlalticpac) in a better shape than when you first found it
I’m Undead, I’m not Unreasonable (Dracula)

[Denny Tuckerman]

For some reason when I now design a new database and create a File Attachment field, the field description always is Right Justified. Change the field to any other type and it becomes Left Justified.
Anyone know why it’s doing this please?

Leave the Planet (tlalticpac) in a better shape than when you first found it
I’m Undead, I’m not Unreasonable (Dracula)

[Laurent]

Hi Brendan,

It seems the last version 5.2.10 has not solved the DB size issue I have after having deleting some fields from my different forms. I ran the “compact database maintenance script” but the DB file size has not been reduced, still stuck at about 450 MB.

Would you please help ?

Thanks a lot,
Laurent

[Michael Tucker]

**FIRST SECTION**
Logic of Using Bitnami

The choice of using bitnami (bitnami.com) can simplify searching for server combinations that are Couchdb compatible, yet also has compelling features…

…It’s free to the user (from what I experienced) and can install Couchdb on several options of cloud servers.

…It has a lot of resources on-line to help you if needed.

…When you use their installer (their launchpad) — it does a pretty good job of stepping you thru what you need to do and transferring you to your cloud server when needed.

…Bitnami can install other applications (like wordpress) as well — but not our topic.

…It’s not complicated, and does not take much time, if you know what to do or have a good roadmap.

…It says it will keep your Couchdb version up to date for you.

…If you find one cloud server doesn’t fit your needs or costs too much, you can try another.

…You could actually install to more than one cloud service to test several at a time if you wanted.

**NEW SECTION**
Choose A Cloud Server & Set It Up First

You probably should choose a cloud server first (if you don’t have a destination cloud service, bitnami can’t install your Couchdb). Go to https://bitnami.com/partners to see all the options bitnami can install to..

…Cost options for the cloud servers are not always so easy to pin down..
I spent a few moments looking, and only could find 2 servers that had costs expectations easy to find. Many servers offer free trials and credits, but it is a lot of work to set up and then need to move your files back and forth, I’d really rather know before I jump, so to speak..

AWS…the lowest tier shows an estimate of $5.18 US a month.

1&1…if you use the bitnami console and choose from their selection, it offered a $50 credit. I could not see what the monthly charges were without actually signing up.
However, if you visit their website — it appears their starting cloud server plan (Cloud Server M) is $9.99 US a month. The interesting thing is that if you open an account from their website — the credit appears to be $100 US. I think if I were going to use them, I’d try to open the account from their website first to get the $100 US credit.
I have noticed that options and prices change at 1&1. Just a few weeks ago they offered a cloud server for $4.99 US a month (Cloud Server S) which is no longer shown.
So your mileage may vary from the offers available at the time you visit.

Azure… has price estimators but they did not make sense to me, only way I could determine would be to open a cloud and put my data into it and use it.

Google… has price estimators but they did not make sense to me, only way I could determine would be to open a cloud and put my data into it and use it. They state they are less expensive than AWS on their website.

Oracle… has price estimators but they did not make sense to me, only way I could determine would be to open a cloud and put my data into it and use it.

**NEW SECTION**
Logic of Using AWS

I chose for my first attempt using bitnami, for my cloud server, AWS (Amazon Web Services)…

…First, I’ve had some experience with AWS Customer Service to know you can get in touch with someone and have them actually respond back to you.

…Second, because the estimated cost looked attractive to me ($5.18 US a month).


…Third, the AWS platform is flexible to fit a range of needs and pocketbooks…
Upgrading from the lowest tier — 10GB @$1.00US (that I chose) — to 20GB is just $2 US — sounds good. And to upgrade the CPU up a notch is about $8 US versus the $4.18 US for the lowest capacity CPU (T2-Nano that I chose).

…Fourth, the AWS platform has what they call “elastic IP” numbers — what most of us would call a static IP — so that when you stop and re-start your server, the IP number you have used in the past remains the same. It did not seem to cost extra to activate the option.

==
==

For this TEK I’mm going to assume AWS is the chosen cloud service and that the account at AWS is already set up.

..Remember to store your AMAZON AWS login and password (like in 1password).

..Some parts of the TEK may still be helpful for whatever installation platform is chosen.

**NEW SECTION**
Get Going With Your Bitnami Account

Just go to bitnami.com

Press the sign in at top right, then at bottom of next screen “Don’t have a Bitnami account”
Press CREATE ONE.

Store your login and password (like in 1password).

You will have an email sent to you that you need to confirm to verify.

==
==

Log into your bitnami account.

You can press the green CONSOLE button at the top of the screen or go to “my account” and press CONSOLE ACCESS on the left side choices.

In this TEK we will be using AWS (Amazon Web Services) — which starts in the next section.

**NEW SECTION**
At Bitnami, use LaunchPad to Install Couchdb on AWS Cloud

You are in the CONSOLE at bitnami.

Click AWS Launchpad

There are a number of icons for various installations, you could scroll and look, but…
..To the left top of the icons there is a tab showing “All categories”.
..And to the right of that is “Search applications…”

Enter into that search “couchdb”

It should appear “instantly”.

Then hover on that icon and it will say “Launch”.
Click Launch.

A box will come up saying that a cloud account is required.
You will have to create a “vault” on bitnami.
Click to create.

When you have created your vault on bitnami..you will have a password for it..
..be sure to save your bitnami VAULT password (to like 1password).

==
==

Then you are asked to choose to either create a new AWS account from bitnami or log in and set your credentials.

We are logging in to get our credentials since we already created our AWS account.

To get your credentials, at AWS, go to Security, Identity and Compliance.
Select IAM

You will get a bitnami access key. (console.aws.amazon)

Be sure to save your bitnami AWS ACCESS KEY ID (to like 1password).

==
==

Back at the bitnami launchpad for AWS
At aws.bitnami.com
Log in, if needed.

At the top of the screen there should be “Virtual Machines”…”Library” .. “Support” .. “Account”

Press on VIRTUAL MACHINES

Then choose New Virtual Machine

Go back to Bitnami Launchpad for AWS Cloud
Find couchdb
Select it again…

..this time (now) it should give you your initial Couchdb account set up options…

Select the region (closest geographical match to you);
Select the disk size (10 GB is $1.00 US; 20 GB is $2.00 US);
Select the server (t2.nano is $4.18 US Mnt, .006/hr; t2.micro is $8.35 US Mnt, .012/hr).

Your estimated cost will show (mine was $5.18 US for the minimums offered above).

CONTINUE

This will install your cloud instance of Couchdb, which does not take very long.

==
==

(aws.bitnami.com)

After a moment of installation..

..you will see a panel with your Couchdb name, under that the CouchDB version, the username, and the password.

Be sure to save your bitnami-couchdb name, login in and password (to like 1 password).

On the right side — you will see an initial server (your IP) — write it down. This may change until you get a bit further along in the AWS process — but write it down so you have it (with room to strike over).

You will also see in yellow the option to download your KEY — if you were going to use a windows server you would download the .PPK version, we are going to download the .PEM version for our AWS cloud server.

Your KEY will not change even if you change your IP, so it is fine to go ahead and download it now.

Put in a place you can refer back to (probably not on your desktop) as you will need to reference it later, and possible weeks or months from now — so note where it is on your drive and keep that info as you will need it for access pretty soon and further off in the future.

Good thing to reveal the “show SSH command” and copy that to your notes and keep it as well.

It will show similar to ssh -i [your-private-key].pem bitnami@xx.xx.xx.xxx

The format is important. An added or omitted space (etc.) and it will not work.
It is ssh(space)-i(space)[your-private-key](dot)pem(space)bitnami@xx.xx.xx.xxx
You will replace everything between the i(space) and the (dot) with the disk location of your PEM key. You will replace the above xx.xx.xx.xxx with the actual shown IP under Server Info.

If you get lost — go back to aws.bitnami.com, and log in if necessary, then go to virtual machines, then enter your Bitnami Vault password if necessary.
That will reveal your bitnami-couchdb, click on it to get back to the info screen with your password, the IP address, access to your PEM key, and to show your SSH command.

Remember — for now, if you were to stop the server and re-start it the IP will change. The “show SSH command” is correct (for now). If you would need stop and restart the server you’d need to come back to this screen and get an IP update.

That will be unnecessary in about two steps when we get to AWS and get an elastic IP.
And if you follow this guide, you will not need to go and look for an IP change — because we will get our elastic IP so it stays the same — before we need to stop the server.

==
==

**NEW SECTION**
Open Firewall Ports on Cloud Server at AWS

Before you can actually use your Couchdb (running on the AWS cloud) we have make sure ports are open or open ports needed so you can access it.

Couchdb uses port 5984
SSH uses port 22
http uses port 80
https uses port 443

==
==

At amazon.com/aws

Choose “SIGN IN TO THE CONSOLE” at the top right.

It should know you and show your email..
..Then enter your PASSWORD

In “Recently Visited Services” you should see EC2..
..Click on EC2

At top “Resources” you should see “Running Instances”
..Click on Running Instances

You should see “BitnamiCouchdb…”..
..Click on that and in the window, toward the bottom some panes will reveal.

You should see in the “Description” pane..
..In “Security groups”..
..”BitnamiCouchdb..
..Click on it and another pane reveals..

Click on the “Inbound” tab.. And the rules reveal.

==
==
Button above the table EDIT (press)

You need to add if not there:

SSH 22 0.0.0.0 (anywhere) SSH
HTTP 80 0.0.0.0 (anywhere) HTTP
Custom TCP Rule, 443 0.0.0.0 (anywhere) HTTPS
Custom TCP Rule, 5984 0.0.0.0 (anywhere) open for couchdb

Basically..type (Custom TCP Rule), protocol (TCP), Port Range (80 then 22 then 5984 then 443), source (anywhere), description (most fill in, the 5984 you can put “open for couchdb”).

Save — it will create several lines in addition to those you entered.
Just look again to confirm you have 22, 80, 443, 5984 as 0.0.0.0

**NEW SECTION**
Configure a “Static IP” at AWS

If you are just finishing opening your firewire ports at AWS from the last instruction, you can just continue on…

On the left side there should be a list of panels..
..under Network & Security..
..click on ELASTIC IPs.

==
==

If you are not logged in…

At amazon.com/aws

Choose “SIGN IN TO THE CONSOLE” at the top right.

It should know you and show your email..
..Then enter your PASSWORD

In “Recently Visited Services” you should see EC2..
..Click on EC2

At top “Resources” you should see “Running Instances”
..Click on Running Instances

You should see your “BitnamiCouchdb…”..
..Click on it and in the window at bottom panes will reveal.

This time we are not concerned about the bottom panes…
..On the left side there should be a list of panels..
under Network & Security..
click on ELASTIC IPs.

==
==

Now at ELASTIC IPs.

At the top press the blue “Allocate new address”
Close
At the top press the gray “Actions” tab and pull down to ASSOCIATE

Choose the Instance “BitnamiCouchdb…”..
Click ASSOCIATE

You can see your current permanent IP known as the “Elastic IP”— write it down, if it varies from the prior IP you wrote down (if you have stopped and restarted your cloud server), strike over the prior IP.
This will be your IP (your server IP) from now on unless you decide to remove this association and make another one (remap it).

You can create more elastic IPs, but if you do and do not put them into service, you will run up charges for keeping them reserved but not used.

==
==

In your password utility — you might want to update your bitnami-couchdb… notes…

ssh to clouddb with terminal

ssh -i [your-private-key].pem bitnami@[your IP you just got from AWS allocate elastic IP]

which is:
ssh -i [your local disk access].pem bitnami@[your IP you just got from AWS allocate elastic IP]
Ssh(space)-i(space)[your local disk access].pem(space)bitnami@[your IP you just got from AWS allocate elastic IP]

web access (Couchdb control panel): http://[your IP you just got from AWS allocate elastic IP]

tapforms:
server http://[your IP you just got from AWS allocate elastic IP]:5984

**NEW SECTION**
Find your PEM file on your Drive and Change its Permissions

Find your PEM (.pem) file you downloaded to your computer’s drive.

We did this back at the instruction “At Bitnami, use LaunchPad to Install Couchdb on AWS cloud”

If you lost your note, find the file you stored on your drive.
If you did not store the file to your drive…

Go back to the instruction “At Bitnami, use LaunchPad to Install Couchdb on AWS cloud”.

==
==

When you have found your PEM file on your local drive, and you know the location of your PEM file [like mydrive/users/littleoldme/downloads/filename.pem], we need to change its permissions.

On mac, open the TERMINAL app.
Once you get a cursor…

chmod 600 [location of your PEM file]
That is chmod(space)600(space)[location of your PEM file]

Once this is done properly you will get a cursor back.
If you don’t have the location correct, you will get an error, keep trying until you have the permissions set to 600 for that file.

**NEW SECTION**
Editing Your Couchdb “config file”

Before you can actually use your Couchdb we have to make adjustments to a Couchdb config file stored on your cloud server.

==
==

We are going to be using the Mac Terminal app to log into our AWS cloud and access the config file in the Couchdb installation.

You will need either from accessing a note application, or from your password utility — the correct ssh(space)-i(space)[location of your PEM file on your drive](space)bitnami@[your static IP]

Once you have that ready and on your screen to copy to the terminal, that will save a lot of frustration and time (rather than type it from the keyboard).

With the Mac Terminal app..
Log in with the above ssh(space)i(space)[location of your PEM file on your drive](space)bitnami@[your static IP].

You will get a $ icon if you are successful.
If not, check formatting, check that the reference to the location on the disk is correct, check that the IP is correct, check that the PEM file has it’s permissions set to 600.

==
==

Once you have the $ login prompt..these are the steps to take, in order..

(1) Stop services
sudo /opt/bitnami/ctlscript.sh stop
That is sudo(space)/opt/bitnami/ctlscript.sh(space)stop

The stop of the server should be confirmed and then you’ll have a new prompt.

[[If you are having problems, see https://docs.bitnami.com/aws/faq/operating-servers-instances/control_services/ ]]

(2) We will change directories
cd /opt/bitnami/couchdb/etc
That is cd(space)/opt/bitnami/couchdb/etc

If you did it right there should be no error message and you should show a new prompt: etc

(3) We want to see what is in this directory
ls
Should show directory — and we are looking to make sure we see “local.ini”

If you see it, all is good, if not; go back and trace your steps — we need to get into the correct directory in order that we can see the file “local.ini”

(4) We want to make a copy of the file we will be altering (just in case we make a mistake)
sudo cp local.ini local.ini.backup
That is sudo(space)cp(space)local.ini(space)local.ini.backup
[If you have to do this again in another session, change the name of the next backup to local.ini.backup2, etc.]

(5) We want to confirm the backup file is there
ls
Should show directory — and we are looking to make sure we see “local.ini.backup”

(6) We are going to edit the config file
sudo nano local.ini
That is sudo(space)nano(space)local.ini

This opens the contents of the file “local.ini”, and if you press keys you will edit, so don’t press keys you did not intend to — use your arrow keys (under the shift key) to move to position so you can edit what needs to be edited.

(move with arrow keys)
First
— look in the section [chttpd]
Change (move with arrow keys and backspace/delete to write over existing text)
127.0.0.1
to
0.0.0.0

(move with arrow keys)
Second
— look in the section [httpd]
We want to see in this section “bind address =0.0.0.0”
It’s probably not there.. And if not, go to the top of this [httpd] section and insert a blank line if you need it to write to (you may need to press return to have a line at the top)
bind address =0.0.0.0
That is bind(space)address=0.0.0.0

If a statement like that exists but does not show 0.0.0.0, change it to 0.0.0.0

(move with arrow keys)
Third
— look in the section [daemons]
We want to see in this section “httpsd = {couch_http, start_link, [https]}”
It’s probably not there.. And if not, go to the top of this [daemons] section and insert a blank line if you need it to write to (you may need to press return to have a line at the top)
httpsd = {couch_http, start_link, [https]}
That is httpsd(space)=(space){couch_http,(space)start_link,(space)[https]}

(move with arrow keys)
Fourth
— look in the section [ssl]
We want to see in this section that these 3 lines are uncommented (nothing in front of them); and if one of these lines is not there, insert it (create it) similar to like how you did above:
port=6984
cert_file = /opt/bitnami/couchbd/conf/server.crt
Key_file = /opt/bitnami/couchdb/conf/server.key

(8) All done with the edits.
We are going to close and save the file

(move with arrow keys)
Move your cursor down to the very end of the space on this page, past text (there is probably a lot of empty space, so go as far down as you can — go past all the text)

Press ControlX (at the same time);
It then will ask if you want to overwrite and save (assuming you did it as above, press Y)
If you made errors, just say N and you will exit and you can start over again without needing to do another file backup.

You should see a cursor prompt

(9) Check your work.
Log in again using the Mac Terminal, but this time do not stop services (they are already stopped), and you do not need to make another backup file just to verify your work.

Just run the text editor (step (6)) and just move and look that your changes were made properly.
Then when you have verified, move all the way to the bottom of the page, and press ControlX and then Y to exit.

You should see a cursor prompt

(10) Everything you need to edit is over and done and you confirmed it..

Start back up services
sudo /opt/bitnami/ctlscript.sh restart
That is sudo(space)/opt/bitnami/ctlscript.sh(space)restart

Restarting should be confirmed and then you have a new prompt

(11) Finished — Log Out of the Session

If you are totally done, you can gracefully exit the logged in session by typing…
exit

You should see a $ prompt
You can close the terminal window and quit the terminal app.

Otherwise just close the terminal window and you can quit the terminal app.

**NEW SECTION**
Your Web Access for Couchdb

You have a control panel to access your Couchdb, very helpful to confirm that the documents (databases) you thought you connected are actually there (compare their IDs from tapforms to the IDs in the control panel). You can see the size of your documents, read documentation, and so on.

The permanent IP you got, just insert that into your web browser with the port number appended and then /_utils/ appended…

If your IP is 55.123.45.678..

Type http://55.123.45.678:5984/_utils/

I do not go into adding users, you can read the documentation in the control panel to pursue that.

You do need to have admin access as a user to initialize a document to be synced from your device to the Couchdb cloud.
Once a document exists — then non-admin users can access it is my understanding, but read the documentation for how to implement multi-user (and non admin user) set-up.

**NEW SECTION**
Your TapForms Access for Couchdb

In TapForms, you will sync with the Apache CouchDB pane.

The (“elastic”) permanent IP you got in an earlier instruction, just insert that into your server address with the port number appended.
If your IP is 55.123.45.678..

Type http://55.123.45.678:5984

Your username and password is from way back when we first set up couchdb under the section “At Bitnami, use LaunchPad to Install Couchdb on AWS Cloud”

The access given initially is just one and it’s an administrator’s access. If you are going to have other users, look at the documentation in the control panel for Couchdb for how to set those up — as it is unlikely you’d want everyone to use the one login initially provided.

**NEW SECTION**
How Much Is This Really Costing Me? What is the Quality of Service?

Go to aws.bitnami.com

Choose VIRTUAL MACHINES at the right top

You should see your virtual machine listed similar to “bitnami-couchdb-cf…”
Click on that yellow listing to open.

You will see a panel with your Couchdb name, under that the CouchDB version, the username, and the password.

Click on the top yellow box that says “Manage in the AWS Cloud Console”.

Click on SERVICES at the very top.

On the left click on BILLING

Keep tabs on that to see if it matches what you expected.

The first day I set up couchdb my bill was $.36 US I think it was.
Next day when I checked it, my bill was $.47 US. [47-36=11]
Next day when I checked it, my bill was $.65 US. [65-47=18]

Most of the bill is based on server time.
For all the data I have only been billed $.01
And there is tax of $.02

The Elastic IP looks like it is free when put into use, and for 100 remaps.
I have only mapped it once to the bitnami-couchdb instance.
There is discussion that if you reserve an elastic IP and do not actually use it, you will get billed $.01/hr while it is held out of the public pool but not in service.

So if it is going to typically run $.11/day that would be $3.30 for 30 days;
If it is going to typically run $.18/day that would be $5.40 for 30 days.

I suppose as I figure my average over more days I’ll decide if it seems too costly; Google cloud claims they are less expensive and bitnami can install to Google — I might try it if this service exceeds my budget expectations?

QUALITY OF SERVICE:

AWS cloud Couchdb is much more responsive (less lag time), that was the demo (free version) of the BlueMix Cloudant; BlueMix Cloudant stipulated it would have issues with larger sized document (database) files and larger attachments like photos or documents.

So far after three days no noticeable complaints…
— it has handled all my documents (databases) with large photos or several photos within a field with no errors;
— and it has been very quick to update changes in data from one device to another.

[Brendan]

Hi Gary,

Thanks for your comments about Tap Forms syncing. One of my goals with Tap Forms was never ever to have access to your data. So setting up my own server to host your data that I had full access to was never anything I wanted to be able to do. Even for a subscription fee.

Currently there are 4 different sync services to choose from. The simplest to get going is iCloud sync. Everybody has iCloud and it’s a one button click to enable. But there are of course limitations with it. For you and your wife, you would need to share the same Apple ID for that to work. But I realize it’s not practical to do that for different users. That’s why there’s 3 other services to choose from.

I agree that it’s far too technical a process to get an account setup now with IBM Cloud. It used to be fairly easy with just a username and password that you provide. Now you have to get a username and password from the Service Credentials that IBM gives to you. But I do have step-by-step instructions in the online user manual on how to do that.

I had at one time thought about offering a subscription sync service, but in general people don’t want to have to pay for that. I would also be on the hook for paying thousands of dollars per month to provide a service that I might not be able to recover from. And then I would also have access to all my customer’s data, which is something I never wanted.

I’m also a one-person company. I initially built Tap Forms as an organization app for all the junk I had in my wallet. It has grown exponentially since then based on customer requests and miscellaneous things that I’ve wanted to add to it over the years. So I don’t have the resources or person power to manage a dedicated sync service for customers. That’s why I preferred to allow customers to setup their own accounts with the service that was compatible with the Couchbase Lite database engine that I wrote Tap Forms on top of.

It’s real shitty what IBM did by switching from the relatively simple IBM Cloudant to the more complicate IBM Cloud service. But they’re IBM and I am nobody to them so I had no control over what they did.

Perhaps I’ll work on adding additional ways to sync in future versions.

Thanks,

Brendan

[Gary Ownsby]

Good Morning All,

As many of us near the end of the Cloudant Sync Service, while my wife and I still love Tap Forms, we’re both disappointed that a more simplified approach to replacing Cloudant isn’t available by now. While I can appreciate that the best minds and experts in Tap Form usage have no doubt examined many options, the ability to sync between devices is widely used now and I’ve never had to go this level of effort to have my data available to me on various devices. IMHO there must be a better approach that requires less of a technical approach to sharing/syncing data

I never cared too much for using the Cloudant-type approach anyway as it made those that simply needed to organize their data to become technicians more than users. While I understand that Tap Forms isn’t an “appliance” mode app today, perhaps it should focus on user simplicity for acquiring/managing data and leave the “heavier lifting” to those with the technical skills (and desire) to do things like data backup/sync? Or to make those functions super simple.

I’m not sure what the long-term business model is for Tap Forms but perhaps it’s time to consider offering users the option for data sync that would be managed by Tap Forms via a subscription process. Others with the technical skills or desire to do it themselves could continue on as done now.

Please don’t get me wrong, my wife & I are avid users of Tap Forms but the sync process is a bit of a weak link in the product for wishing a more simplified, less technical approach to doing a function which is very mainstream in today’s technical world. Yeah, I’m one of those that flip the wall switch and the lights come one. I don’t care about the how so much as long as it happens and is affordable.

Thank you.

Gary