Search Results for 'script'

[Daniel Leu]

Right now, I haven’t posted the MCP script yet. Busy with other work.

Cheers, Daniel

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

[PierreBn]

Hi Brendan,

Thanks for the detailed reply! I’m glad to hear about the additional flexibility coming in 1.5, and it’s interesting to hear what you’ve already tried with the chatbot.

I can see the difficulty with sending thousands of records to a model. An MCP connection could let the AI retrieve only the records and fields it needs (through an MCP-driven search into tapforms), using an AI subscription many of us already have: with a compatible client, this could work within the AI subscription limits (ChatGPT Pro, Claude…), without buying separate API credits on top of ChatGPT Plus/Pro or a similar subscription. The connection between the AI desktop app and Tap Forms through an MCP would run locally on the Mac, between the desktop AI app and TapForms.

To answer your question, I use Tap Forms for many things, including my model railway collection. I already use AI to research models from their manufacturer and catalogue number, gather their specifications, and format the results according to my database fields. Currently, I have it generate a CSV file which I then import into Tap Forms (an MCP would allow me to also upload or modify attachments directly).

Some prompts I would find useful are for example:
– “Research this model and prepare a new record using my existing fields and naming conventions. Check whether I already own it before adding it.”
– “Find models with missing technical details, research those details, and show me the proposed updates with sources.”
– “Find possible duplicate records, allowing for variations in catalogue-number formatting.”
– “Check for inconsistent manufacturer names or railway-era notation, and propose corrections for me to review.”
– “Summarise my collection by manufacturer and era, including purchase totals where available, omit models <100 euros.”
– “Compare these newly announced models with my collection and tell me which ones I already have.”

As I mentioned in my original post, the Joplin MCP integration has made this kind of interaction very useful for my notes. I’d love to have that same continuity with Tap Forms: research something in an AI conversation, consult my existing records, then save the results back after reviewing them.

I know you’re developing Tap Forms on your own, and I appreciate the large work involved. Hopefully these examples give you a clearer picture of what I had in mind! Maybe other users have other use cases.
In any case, I still love TapForms ;)

Thanks again,
Pierre

• This reply was modified 1 day, 23 hours ago by PierreBn.
• This reply was modified 1 day, 23 hours ago by PierreBn.

[PierreBn]

Hi,

This was already asked in April ( https://www.tapforms.com/forums/topic/tap-forms-5-and-maybe-next-version-too-and-mcp/ ), and Brendan you didn’t have any plans for this.

Just to check if this might have changed.
I am in any case very interested! ;)

My personal opinion on this:
As AI becomes more widespread, there is a good overlap between technical users who may use a personal database software like tapforms and those that use AI more and more. It is now perfectly possible for someone to develop a simple, personal, custom database just with a few prompts (albeit of course not as good and rich in functions as tapforms – but maybe enough for some).
Leveraging both AI and TapForms rich functions through an MCP connector would be the best of both worlds. An example of this: my note taking (with the open source Joplin) is now so much better thanks to their native MCP connector.
It’s not about doing everything with AI, it’s about selectively using is. Being able to read, update, analyze or sort my tapforms records through an AI would be amazing with a native MCP (the script workaround isn’t really as safe and/or powerful IMHO). I respectfully think AI integration is going to be key to long term success of software suites (while also respecting those who want nothing to do with AI); particularly for data oriented software solutions like tapforms.

Best,
Pierre

[Trish Meyer]

I tried that, but TapFormsPlus doesn’t show up as a Subscription (perhaps it’s because it’s a Lifetime purchase?)

But I figured it out! I was Sharing Purchases with hubby, but he also had to Share his purchases too on his account. Once I did that, the “Subscribe” button went away, and the Settings have the Sync button and all is syncing!

I found the answer on an Apple help page:

“In order to share in-app purchases from participating apps, make sure that Share My Purchases is turned on for the account that made the purchase, as well as the account they want to share the purchase with. ”

under Learn More at the end of this page.
https://support.apple.com/en-us/111114

Thanks for your patience, especially on a weekend.

• This reply was modified 1 week, 1 day ago by Trish Meyer.

[Brendan]

Yes. Go to the Manage Subscriptions screen on your Mac, then click on Tap Forms Pro on your list of subscriptions. You should see it say Family and there should be a switch that you can turn on or off to share the subscription.

[Trish Meyer]

Yes, he clicked “restore purchase” a few times, but it just says that he has never purchased it before. Dialog pops up with message:
“Your App Store account has no previous subscription to Tap Forms Pro. Ensure you are logged in with the correct App Store account or purchase a new subscription.”

Anything else we could check?

[Trish Meyer]

Thanks, that makes sense now. I’ve fixed my two Silicon Macs (I hope, using Local Documents folder as the default).

I’ve installed Tap Forms Pro on my husbands laptop. He is on my Family Sharing (I am the “organizer”). He went to the popup that says “Purchased by Trish” and downloaded TapForms Pro from that page.

But when he added the master database, it only shows 10 records and is asking him to pay for it.

We’ve double checked everything on Apple App Store. TapForms Pro does not show up under his Subscriptions. I’ve waited a couple of hours to see if it was an Apple Store delay, but still on trial version.

Is there something we’re missing? It said Lifetime included Family Sharing. Thanks.

[Melanie Schaaf]

Hey everyone,

I also have a few questions about conditional formatting and observed some strange / annoying refreshing behaviors.

Let’s talk about formatting rules first.

I have tested this first with a condition based on a text field (with a pick list to be precise); Make text red if text field equals “Red”.
This works perfectly in all three layout types (Default, Custom and Universal), the text color in the conditional field refreshes immediately when I change the value in the text field.

When I make a condition based on a checkmark, however, (e. g. Make text red if checkmark is false), I noticed that while in Default and Universal layout, the text color refreshes immediately like with the other condition described above, when I turn the checkmark off and on, but in my *Custom* layout it doesn’t refresh. I have to either leave the record and go back to it, to see the switch in the checkmark affect the text color, or I have to press the “Recalculate formulas and scripts for all records”-button for it to change the color. Simply pressing “Recalculate formulas” will *not* trigger the format switch either, which I suppose it should, if recalculate all works, why shouldn’t recalculate this one record work?

But apart from that I guess the formatting should update in my Custom layout right away, like it does in the other two layout types and with the other conditions… 




Let’s move on to visibility rules.

I have tried a condition that states: Show field when List field is equal to “Show”.
The field will always show, no matter what the value in my List Field is, in every layout type, whether it is Default, Custom or Universal.
I also tried a condition with a number field (Show when number field is greater than “5”), this also did not work. Neither did a checkmark with a similar condition with show.

So I have been wondering what kind of conditions would work with the “Show” option? I have not been able to find any in any layout.
I even tried the Hide Field in the field options (which by the way only hides the field in the Default Layout, it remains visible in Custom and Universal), thinking that maybe if the field was hidden by default, “Show” in Conditional Formatting might make it visible. This doesn’t work either.

So next I tried the opposite: Hide field when List field is equal to “Hide”.
This works in the Default layout, but only after I leave a record and re-enter it (both “Recalculate”-buttons won’t refresh it this time).
It doesn’t work in the Custom layout at all, neither with “Recalculate” nor by leaving and re-entering the record.
It works in the Universal layout immediately after I change the value.

I tried this with a Checkbox field and the Hide action and the behavior is exactly the same.

I also tried hiding an image field, which also showed the same results; worked immediately in the Universal Layout, kinda worked in the Default Layout, after leaving and re-entering record, recalculation does nothing, and it doesn’t work at all in Custom Layouts.

Apart from the refresh and recalculate issues, this brings me to the question: Is the Visibility Conditional Formatting simply not available in Custom Layouts? Is it planned for future releases?

And why is the refreshing behavior so inconsistent throughout different conditions and layouts?

Brendan, when you are reading this, I’d be happy to send you my test database via email, though I am pretty sure the behaviors I described above are universal. At least I was able to reproduce them in my other databases…

All this has been tested on MacOS.

Looking forward to your feedback!

Thanks!

Melanie

[Brendan]

Hi Karen,

Thanks for re-subscribing to Tap Forms Pro!

You can do all the same stuff (mostly) on the iPad scripting as you can on the Mac.

The UI is slightly different on iOS though for writing the scripts. But the editor itself is the same.

The API and examples are here:

https://www.tapforms.com/help-mac/pro/en/topic/scripts

The Mac manual’s scripting API is the same as for iOS.

Thanks,

Brendan

[Brendan]

Yes, Table fields will also migrate. Just use the Send to Tap Forms Pro function as in my demo video and that’ll do everything for you (aside from the attachment aliases issue above).

Yes, all data is stored locally on your devices. Not in the cloud unless you enable iCloud, Cloud+, or Dropbox sync.

Well, you still have to tell Tap Forms what fields you want. Or you can import from a library of pre-defined form templates you can install from the Template Library. Or you can use the new “Create Form with Fields” function which will use AI to generate a form for you based on the form title and optionally a description.

[karen james]

I’d like to start by saying:
I had started using Tap Forms when Bento became obsolete. I loved it! When Tap Forms Pro came out I subscribed, iPad only, even though I’m no fan of subscription based apps. I let the subscription lapse because I didn’t see the value. However, the new updates called me back, and I renewed my subscription. I’m still not a fan of subscriptions, but I feel this one is worth it. I still don’t use it on my iMac. I need the iPad version only, so I’m hoping more of the Mac functionality comes to the iPad. Leading to my question!
Does scripting work okay on the iPad? I don’t mean, do scripts work, I mean writing them. There’s so little iPad documentation, I’m not sure what I can do.

[Marcel Halbeisen]

So, I also try to use the data base now on my MacBook, but it totally failed. It’s absolutely not possible to sync the complete datas from the Cloud+ Sync to the MacBook. Only around 40% of the entries come to the MacBook.
I also tried to open the backup from the iPhone on the MacBook, which works, but It’s then not possible to use the Cloud+ Sync because the file has the same name and then it’s not possible to use it. And if I gave him another name, I have then two databases, and only the one with less datas get’s synchronized.
Completely unusable :-(

Finally I have to say, that it seems to be impossible to use Cloud+ Sync on a save way with Tap Forms. The alternative for me, which is not what I want, is to use Tap Forms only on my iPhone and iPad. But then, I have also to stop my MacOS+iOS subscriptian and use only the iOS subscription. But I need my datas also on the MacBook, so which alternative do I have???

[Tom Seputis]

Hi Brendan,

Thanks for the extremely quick response. The whole issue for this formula not working was the curly quotes. I was not aware of how subtle the difference is in the way that they look. Changed to straight quotes and now it all works fine.

I will have to learn more about scripting if I try anything more complicated than this.

Thanks Again,
Tom

[Brendan]

It also starts to get really complicated to diagnose when you have so much nesting going on within the expression. That’s when I switch to a Script field instead of a Calculation field.

[Brendan]

So you’re using the new Conditional Visibility rules to decide to show or hide a field? I don’t think I tested the condition where the value is changed from within a script. I’ll have to look into that. I had just been focused on when you change values using the user interface.

Also you should only need a single document.saveAllChangesAndRefresh() at the very end of your script, after you make any changes. So that record.refreshCalculations() should go before the save function call.