Search Results for 'script'

[Sydney Sauber]

Hi Brendan,

Here are some pix of 4 records in TapForms and the same set of 4 in FileMaker Pro 13. The TF record set was exported in CSV.

I didn’t bother to map the fields since the point is showing that the multiple windows allow one to use the application more to work with the record details.

I can open as many windows as I want, they can be resized, they can be cascaded and anything can be in them.

My work around for TapForms has been to put data in a “Notes” field, that way I can open multiple ‘Notes” fields from different records. The drawback is…it’s a notes field, so things like concatenation or other calculations won’t work in it.

Learning how to program FM and learning how to make it look like I want takes sooo much time. I haven’t done it.

TF was recommended by a former FM programmer in his blog post (Tim Dietrich) about Leaving FileMaker. One thing he mentioned was alternatives he found promising and the fact that FileMaker seems to be moving toward becoming less end user programmable and more dependent on developers to serve end users. He said it was prohibitively expensive for small businesses or other people who work for themselves.This is what drove me into TapForms arms! He described me perfectly. All the things FM makes users learn how to do, TF has quietly done behind the scenes so we can do very complex things with databases we build ourselves. This is becoming more and more rare on a LICENSED product, which is not subscription — Rented and/or Online.

Here’s what I can see with FM. And if I could do it in TF, I would feel comfortable deleting FM 13. Right now, I would have to create a workflow of exporting data from TF to FM to see the data. It’s the opposite of what many of your customers are doing, they go from FM to TF. But they must not be looking at record details (like images, long text passages…) from multiple records simultaneously.

Here they are.

Thanks for thinking about it.

Attachments:

You must be logged in to view attached files.

[Brendan]

Hi JBB,

No, the COUNT method is not redundant because it excludes empty values. So you could have different results for different fields. If you insert a Number field, then you get other options such as TOTAL, MIN, MAX, and AVG.

I’m working on Tap Forms 5.3 which will have a new Script field which lets you write JavaScript code to fetch values from Link to Form fields — along with many other things. So you will be able to do what you want, but not until 5.3.

Thanks!

Brendan

[Manuel Drews]

Well, thats good to hear!

Yes exactly, i imagine something like a little rules builder with
boolean operators which can change the appearance of entries (colors)
depending on Values.

I’am very excited about your scripting engine and the prospect
that the feature may be coming after a few releases.

My compliments for your great work – Tapforms is by far
the best and reliable Database Builder on the Mac!

Many greetings from Germany,

Manuel

[Brendan]

Hi Manuel,

Thanks for the clarifications.

Your English is perfect. I didn’t even realize it wasn’t your native language :)

Much better than my French, which is the only other language I even know a few sentences in. :)

So you mean set the background colour of the record depending on some values in the database.

It may be possible to do that with my new scripting engine. But it might not make it into the first release of that. I’m focusing more right now on manipulating the data rather than affecting the look of the output.

Thanks!

Brendan

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