Search Results for 'script'

[Daniel Leu]

That’s something I have been thinking about for a while. The issue is that Evernote contains unstructured data whereas with TFP, data is structured.

If you have just a description of your sewing patterns and a photo or two, then that would be much easier than my mix of tables, list, images, etc. A photo attachment field can contain more than one image. So one field is enough.

There are several online tools that convert enex files to CVS or Markdown. I haven’t looked at them so far.

For me, I’ll most likely use a Markdown format so I can continue the format I’m used to. The issue I have is the photo tag which doesn’t work directly inside TFP, but works using an external browser as a display. Maybe I’ll find a solution one day.

Good luck!

Cheers, Daniel

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

[Daniel Leu]

Database scripts don’t exist. You can have form or field scripts. A form script can be made accessible to other form views by classifying it as a document script.

For the API calls, I would try to tell ChatGPT that this is for Tap Forms Pro and not Tap Forms 5. Maybe it will then use the proper functions (eg, fetchXXX() instead of getXXX()). You can find the API documentation over at https://www.tapforms.com/help-mac/pro/en/topic/javascript-api.

Cheers, Daniel

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

[john bluma]

I was trying CHATgpt to generate a script to list the properties of the forms im my database.
The form below is the output of CHATgpt.

when I try rund the script the following error appears:

2/1/26, 11:47:40 AM / Property / listAllFormPropertaiesDB
listAllFormPropertaiesDB: TypeError: document.getForms is not a function. (In ‘document.getForms()’, ‘document.getForms’ is undefined),
line:(null)

CHATgpt says this script should be a DATABASE script, not a FORM script, but I can find no way to create a Database script or to move tghis
script to become a Database Script. Is there such a way?

function listAllFormPropertiesDB() {

var output = [];
var forms = document.getForms();

for (var f of forms) {

output.push(“==================================================”);
output.push(“FORM NAME : ” + f.getName());
output.push(“FORM ID : ” + f.getID());
output.push(“RECORDS : ” + f.getRecords().length);
output.push(“FIELDS : ” + f.getFields().length);
output.push(“”);

var fields = f.getFields();

for (var fld of fields) {

var line = [];
line.push(” Field Name : ” + fld.getName());
line.push(” Field ID : ” + fld.getID());
line.push(” Type : ” + fld.getType());

if (fld.isCalculationField())
line.push(” Calc : YES”);

if (fld.isScriptField())
line.push(” Script : YES”);

if (fld.isTableField())
line.push(” Table : YES”);

output.push(line.join(” | “));
}

output.push(“”);
}

return output.join(“\n”);
}

listAllFormPropertiesDB();

[Steve-Kai Vyska]

Hello everyone,

I think I’ve found an error in the grouping function of the records.

When you open the “Zimmer” form in my database and set the value to 1 under form details at Other / Single-column list view fields, and then choose no restriction for the fields to be displayed, the list shows the field to be sorted as the main heading — in my case, the name of the apartment — and below that the floor. After that, an empty line appears and then a dash indicating that a new entry follows.

So far, everything is fine.

However, if you then set Other / Single-column list view fields to 2 in the detail settings and reload the overview, the following is shown:
The main heading with the field to be sorted
The name of the apartment
The floor
<the empty line that previously separated everything together with the dash from the next record>
The room description
<the dash separating the next record>

Is this intended behavior? Especially in “dark mode”, the empty line above the dash is very helpful for visually separating the records from each other.

I wish you all a wonderful weekend.

Attachments:

You must be logged in to view attached files.

[jessica hardy]

Hi there,
I’ve used tap form LT since 2010 and today went to check some saved data only to find I can’t access the app. I tried all sorts and deleted app only to find I couldn’t reload as no longer in store. I restored my entire iPhone to get it back. I still can’t access the app and quote desperate to get at my data at this stage. How can I access all the data from LT and get into pro or 5? I have paid the subscription but I am unable to do anything and desperately need the data. Please please someone help.

Many thanks Jessica

[jessica hardy]

Hi there,
I’ve used tap form LT since 2010 and today went to check some saved data only to find I can’t access the app. I tried all sorts and deleted app only to find I couldn’t reload as no longer in store. I restored my entire iPhone to get it back. I still can’t access the app and quote desperate to get at my data at this stage. How can I access all the data from LT and get into pro or 5? I have paid the subscription but I am unable to do anything and desperately need the data. Please please someone help.

Many thanks Jessica

[karen james]

I’m finding myself feeling as Russell does. We’re 4 months away from the 1 year anniversary of the release of Tap Forms Pro and it seems that the only new things have been added to the Mac version, which I will not subscribe to. Most of the updates have been bug fixes. For me, there is no incentive to maintain my subscription.

• This reply was modified 4 days, 9 hours ago by karen james.

[Russell Martin]

I understand, at least I think I do. Apple makes Numbers and makes it “free” because they can afford to provide a free (well, you have to have purchased one of their devices) office suite. That’s something that any indie developer has to take into account. That wasn’t my point. My point, which I failed to communicate effectively, is that Tap Forms has gone from being affordable to me to being too expensive for me.

I look at it this way. When I bought Tap Forms the first time, I think I paid something like $10 for the iOS version and $30 for the Mac version. It was the version before Tap Forms 5 so, I don’t actually remember but, I think it was around those price points. I got like 3 to 5 years of use before Tap Forms 5 was released so, effectively I was paying anywhere from $40/3 = $13.33 per year or $40/5 = $8.00 per year for the product.

Tap Forms 5 was released and I think I paid $10 for the iOS version and $40 for the Mac version, and again the total was $50 and I believe I got at least 8 years out of it so, effectively $6.25 per year. (Which is honestly too low and I know this so and that’s why I said I had hoped you would go to a subscription model- I don’t mind paying an affordable and fair price for products that I use and want to see maintained.)

Had you released TF6 and if it was going to cost me $15 for the iOS version and $50 for the Mac version and I was going to be able to use them both for at least 5 years, creating an effective annual cost of $13 per year, TF would have remained worth it to me for my uses.

But, it’s not. It’s not going from $6.25 or $8.00 per year to $13.00 to $15.00 per year now. It’s jumping to $50 per year for a single user and $60 per year for a family user. That’s quite the price hike.

And, again, I get it, I don’t know what you know. I have no idea if you have a good idea of how many subscribers you will retain at this new price point and if you’ve done the math on what you will need to charge based on that to make it worth your while or if this new pricing is an attempt to finally make some serious revenue from the product (which I wouldn’t necessarily begrudge you as TF is a great product).

My only reason for writing was to let you know that the effective price increase is just too much for a customer like me. I can’t help but wonder if, the subscription price was not so much more than the old “effective” annual cost if you would retain more subscribers and be more attractive to new users.

Also, as far as competing with free options, that’s something that every developer has to contend with in the modern world. From open source options to freemium options to loss leaders like the iWork suite, there’s just a ton of freely available software out there these days. So, you’ve always been competing with free and you probably always will be competing with free. The question will always be- are you providing enough added value at the right price point to make your software worth paying for. Right now, for me and the way I see the pricing history, that answer is “no”. Hopefully, for you, there’s enough users for whom the answer is “yes” to justify the new price hike.

Anyway, thank you for taking the time to respond when I couldn’t figure out where the Files Area was and thank you for taking the time to engage with my thoughts about the new pricing. I really do hope you have enough customers at the new price to stay in business just in case I need to come back some day but, I will still be hoping that there might, at some future date, be an annual subscription price more in line with what I’d be comfortable paying.

• This reply was modified 4 days, 16 hours ago by Russell Martin.

[Russell Martin]

Thank you! I could not figure out what the “Files Area” was about.

Just some food for thought for you on the new pricing scheme- I totally get that you need to move to a subscription model to have recurring revenue. I probably bought Tap Forms 5 about 8 or 9 years ago. I kind of wished that you would move to a subscription model so that Tap Forms would not go away.

All that being said, I just can’t get myself to commit to $50 yearly ($60 if I want to share any databases with my wife) for the amount that I use Tap Forms.

It’s not that you haven’t made a great product and I’m sure that there are some users for which that is a bargain. I’m just saying that for the simple lists that I’ve been keeping in the program, I can’t bring myself to spend that much annually.

That’s why I’ve been exporting my databases to CSV and experimenting with importing them in other apps.

And, honestly, importing them into Numbers where they will automatically sync if I keep them on my iCloud drive so they will be accessible on iPhone, iPad, Mac, and via the web at icloud.com (making them accessible on even Windows and Linux) and the fact that Numbers on iPhone and iPad has a Form view, I hate to say it but, I think I will be moving to Numbers and no longer using Tap Forms.

I’m sure you’ve done the math and have some idea of how many subscribers you will get at the price point that you’ve set but, for my casual use, I think I would have only been willing to go to about $19.99 (aka $20) annually for Tap Forms. Or, maybe not. Maybe I’d only be willing to commit to $15 per year. (I don’t know if you considered making a lower tier subscription with few features unlocked- like maybe no scripting at the lower price point.)

Again, I think you have a great product and I will miss it a little bit but, for my use Numbers is going to fit the bill and free vs $50 per year makes your new pricing seem even that much more expensive.

[Daniel Leu]

Unfortunately, you can’t. If you want to control formatting from scripts, use a Markdown field.

Cheers, Daniel

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

[Steve-Kai Vyska]

Hello everyone,

After I found out that note fields can be placed across multiple report pages, I am now trying to solve a problem using a note field. For this, I would need to fill it with content. My question is how I can change the formatting of the text via script — in other words, how I can make the font, alignment, etc. of the inserted text variable.
When you read from the field or enter something into it, you always only get plain text, at least as far as I have managed so far.
Thanks for all information and ideas.
Steve

[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