Search Results for 'script'

[Steve-Kai Vyska]

summewenns is a Funktion from apple numbers Programm. that is why you can not find a translation, sorry for the confusion,

you mention the calculation field. I’m using it in several forms but how can I tell the filed to only add the values with an empty date field? via script I have found out but I thing using existing function would be easier, that is why I ask :)

Greetings

Steve

[Martin S]

Hi. I am new to Tap Forms 5, having just switched from Ninox. I am trying to recreate a cellar database, linking wines to bin locations, but getting confused with linking the two forms. The objective is to be able to identify and link unoccupied bin number(s) with a named wine when bottles are deposited and then to ‘release’ a bin number when a bottle is withdrawn. I have no experience of scripting with Java and am too old to start learning a new computer language now. I have already imported my database of wine details from Ninox, but have got stuck with how to link the Wines form and the Bins form. Any help would be very much appreciated.

[Brendan]

Hi Steve,

I don’t know what summewenns means and translation didn’t find it either. But if you need to add a number only when a Date field is empty, then you’ll need either a Calculation field or a Script field to return that value for you. Then you can have the grand total displayed for that field.

In a Calculation field, use the IFEMPTY() function to detect if your date field is empty or not.

[Daniel Leu]

The content of the field Mieter in the field Mietvertrag in the form Häuser Überblick is not listed because it links to another sub-form instead of being a simple value.

What you can do is create an additional field named Mieter Name(n) of the type script in the Mietvertrag form. Then use following script code:

function Mieter_Name_N() {

    const mieter__name_id = 'fld-ea8902723e1d4656b93115e3e9f3dd80';
    const mieter__vorname_id = 'fld-5eef0854c09746dd8ae8838d90ec2d6d';

    const mieterRecs = record.getFieldValue('fld-8b3ff793448e47e38ff077e3c1b2c932');

    // loop over all mieterRecs
    let mieters = [];
    for (mieterRec of mieterRecs) {
        let name = mieterRec.getFieldValue(mieter__name_id);
        let vorname = mieterRec.getFieldValue(mieter__vorname_id);

        mieters.push(vorname + " " + name);
    }

    return mieters.join(', ');

}

Mieter_Name_N();

It combines the first name and the name of each renter and then joins them as a coma separated list. Now all you have to do is update the Mietvertrag table view in the main form and add this newly created field. Now the renters are listed.

Hope this helps! Sonst kannst du mir auch in Deutsch schreiben. Viel Spass!

Attachments:

You must be logged in to view attached files.

Cheers, Daniel

---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks

[Steve-Kai Vyska]

Hello everyone

and sorry that I’m asking so many questions here in the forum. I think TapForms Pro is a good product, and although it is still in the early stages of development, it is already very good and, above all, very powerful—especially for the price being offered. So once again, many thanks to the team.

I do have one more question about reports, though. At the moment, the report is essentially predefined. I need a way to print more than one page with individual customization. My idea was to create a view in which the fields are filled via a script. However, this runs into limitations because it’s not possible to create dynamically sized fields for custom layouts, nor can you predefine more than one page. That led me to the idea of using reports. Reports do exactly what I’m looking for, but unfortunately you can’t design them yourself—at least I haven’t found a way to do so. By that I don’t mean selecting which fields are used, but actually positioning fields yourself and filling in custom text. Is there a plan to introduce a dynamically customizable report designer?

Thank you for all the ideas, and please let me know if I’ve overlooked anything.
Kind regards, and have a great week

Steve

[Steve-Kai Vyska]

Hello everyone,

I’m a little confused about how to use the total function I have a subform, where I need to add numbers. With the total function this is no problem, but I only need the Data to be added, when one Datefield is empty. I’m looking for something like the “summewenns” function in the Numbers-APP.

Is there something like this ready, or do I have to use a script to calculate everything on my own?

Thanks for any hint

Steve

[Brendan]

I really wish I knew. I’ve contacted them many times about this problem but they seem unable to fix it. I don’t even know exactly what triggers it as it works for many people, but not others. It’s definitely NOT a bug in my software because it happens even if I give a link that goes directly to the Mac App Store, completely bypassing Tap Forms. It always seems to work on iOS. It’s just a Mac App Store issue.

However, Richard, if you email me, I can send you a link that you can try to use and see if it works for you and if not, try it on iOS to see if it works there. I think you could probably use a Mac only link on iOS just to redeem the subscription offer, and then activate it on macOS by clicking the “Restore Purchase” button on the Tap Forms Pro paywall screen.

[Richard Grossick]

I too have tried a number of times today to upgrade V5, I have installed Pro but can’t purchase the discounted subscription, I keep getting a message reading ‘purchase is unavailable’. For various reasons I only use the database on my iMac. Is it likely that the bug will be fixed or should I just expect to stick with V5 for some time until Apple fix the issue ?

[Brendan]

Hi Chris,

I’m very sorry for this issue. I know you emailed me about this issue and it was resolved with iOS, but I’m replying here just to complete your post.

There is some sort of bug in the Mac App Store that prevents for some customers the ability to purchase a Tap Forms Pro subscription. It will work on iOS though. I’ve contacted Apple about it, but they haven’t been able to fix the issue. It was quite a few months ago that I contacted them though. I should submit a problem ticket again for this issue.

Thanks,

Brendan

[Pyromixer]

WebDAV works perfectly on my iPhone. However, on my Mac, I get an error message and can’t sync the database with WebDAV.

My operating system on Mac is Tahoe 26.1 and on my iPhone it’s 26.1.

The error message reads:

Invalid WebDAV credentials
Synchronization service: Login to your WebDAV server failed. Check your server address URL, username, and password to make sure they are correct.

Error Domain=CDErrorDomain
Code=1001 “Error connecting to server: pyromixer.my.server.com” UserInfo={NSLocalizedDescription=Error connecting to server: pyromixer.my.server.com, NSLocalized-FailureReason=HTTP status code was 405}

My usual server address starts with https:

https://pyromixer.my.server.com (< this is an example server)

What could be causing the problem?
Thanks, Pyro

[Fred Katz]

Brendan, thanks for all the work you do.

I’m happy with Tap Forms 5 and don’t want to move to the subscription model of Tap Forms Pro. But I would like to upgrade my iPhone and iPad to iOS 26. Are there are any incompatibilities or loss of functionality with TF5 and iOS26? I’m more concerned with things that might break rather than GUI or display issues, although I want to know about those also.

[Brendan]

Hi Rob,

My sincere apologies for taking so long to respond.

Are you using the Join Link Type or the Many to Many Link Type?

With a Join Link Type you can’t link via multiple fields, but you can create a compound field using a Calculation field or a Script field to join two fields’ values together and then join on that field.

You may also want to turn on the Show Inverse Relationship option so you can see the relationship from both sides.

Thanks,

Brendan

[Shane]

Hi Brendan,

I tried this method but I keep getting the error “TypeError: Argument does not match Objective-C Class, line:(null)”.

My document’s form schema is essentially: CLIENTS -> PROJECTS -> TASKS (parent -> child -> child). Essentially I’m trying to copy a TASKS record I have currently selected, to another PROJECTS (parent) record. I’ve selected a record in the Tasks form, and executed the following script where the destination record is another project (parent) record, and the destination field is the PROJECTS -> TASKS Link To field:

`function Copy_Record() {
var destinationRecord = “rec-82855338485542a89c1946c3e2cff83e”;
var tasksField = “fld-c2f532ef6611450abf973d5e7297b475”;
record.addRecordToField(destinationRecord, tasksField);
document.saveAllChanges();
}

Copy_Record();’

Any obvious errors I have done? Thank you!

[Shane]

FYI, I was able to get it to work by removing the shortcuts, duplicate the scripts, and setting the shortcuts again on the duplicated scripts.

[Rob Young]

I am trying to model marital relationships in TFP. Here is my simplified schema: “People” form with “Name” field, “Marriages” form with “Person1” and “Person2” fields. This works great and People finds all the Marriages records tied to the first field (“Name” to “Person1”). However, Marriages records do not show up in the People form record for Name linked to Person2. Can the Marriages form be linked to the Persons form via two foreign keys (Persons.Person to Marriages.Person1 and Marriages.Person2)? If this relationship is possible, it seems likely a script will be needed to show all Marriage records related to a People record – that would be fine.