Search Results for 'script'

[td4d]

I’ve tried to find a way to use the tapformz://script/… function to open a form but with no success. Can you offer an example or suggest what I’m likely missing?

[Jean-Christophe RICAU]

Hello,

I have two linked forms, like Clients (CDL), one to many with reverse view to Invoices, and a script in Invoices to populate some fields.

When I create a new record in Invoices, either from Clients or Invoices, the fields are populated well but the app freezes during 30-40 sec on the Mac version and I get an error message on iOS.

Here’ my screen shots, did the noob miss something ?
Thanks for help !

Attachments:

You must be logged in to view attached files.

[td4d]

Thanks for the script insight – something for me to look into. The iOS app is aHomeIcon which I believe was free but now sells for $0.99 CAD.

[Daniel Leu]

What is the freeware utility you are using? Thanks!

Apart of records, there is a script option as well:

tapformz://script/[document ID]/[form ID]/[form script name]?key1=value1&key2=value2...

You find this documented in https://www.tapforms.com/help-mac/5.3/en/topic/javascript-api

• This reply was modified 3 years, 2 months ago by Daniel Leu.
• This reply was modified 3 years, 2 months ago by Daniel Leu.

Cheers, Daniel

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

[Gilles Cruypenynck]

Hello,

I’ll try to keep as clear and simple as I can…

I have 2 forms ‘Factures’ (invoices) and ‘Entreprises’ (clients), classic one Client to many Invoices.
– ‘Entreprises’ is linked to Factures with a one-to-many relation.
– Each one of the ‘Entreprises’ has a ‘Code’.
– In ‘Factures’ I want to concatenate “code_entreprise” with other fields from ‘Factures’.

I wrote a script which works except for one line where I’m trying to get the ‘Code’ value from ‘Entreprises’ with:
var code_entreprise = entreprises.getFieldValue(‘fld-e0835c6dcdd9468dbd5b4a65107b20d4’);
but get a ‘ReferenceError: Can’t find variable: entreprises, line:(null)’

See line 21 on the screenshot.

Any clue of what I’m doing wrong?

Gilles

• This topic was modified 3 years, 2 months ago by Gilles Cruypenynck.

Attachments:

You must be logged in to view attached files.

[Zippidty Doodah]

Hey Brandon,

Just clarification for my brain.

1. First, disable iCloud sync on ALL devices? (Mac, iPad 1, iPad 2)
2. Second, click on the Delete from iCloud button on ALL devices? (Mac, iPad 1, iPad 2)
3. Then switch to Nearby Sync? On ALL devices? (Mac, iPad 1, iPad 2)
4. Now, add the iPads to the Mac (from the iPad sync setting window)
5. Conversely, add the Mac to both iPads (via the Mac’s sync settings)

4 and 5 ensure 2-way sync.

At that point I should see the changes I mentioned above that are only on iPad 1 sync back to the Mac (?)

Side note: When looking for an alternative to Bento, I purchased FileMaker Pro. In all it’s glory, FMP was just too much. Finding TapForms saved me many hours of database creation. Because it just works. And as you have refined TapForms, I have been able to refine my databases. I’m still learning that TapForms contains many more refinements than I am currently using (scripts, etc) I so appreciate your continued support of a much needed app for the Mac and the ability to use iPads on location.

TIA for the additional clarification.

[Sam Moffatt]

Yah, this isn’t the greatest solution due to the hop over to TF and back but you can basically pull out what ever content you want out of TF and into the Shortcuts ecosystem this way. I’d definitely love a more polished way of executing scripts that takes input and provides output (e.g. scripts support taking a dictionary and provide a dictionary), maybe a feature for a future release. Hopefully this is enough to get you further along with what ever other help you’ve got available to you :)

[David Gold]

Thank you! The scripting is beyond my pay grade and would still love some kind of Shortcuts support in Tap Forms but what you’ve put together at least shows their is a “hacky” solution at the moment.

[David Gold]

OK thanks that would be great. I’ve been doing a little bit of this the past few years using Javascript but I don’t know Javascript and had to pay someone to put it together for me. I use Shortcuts a lot though and would be a lot easier for those of us who don’t know Javascript!

[dan carter]

Hello All,

I’m using the iOS version of TF on an iPad. I would like to write a script to open a form view (example “Order Detail”) from another area in the database (example “Customers”).

Many Thanks, Dan

[Brendan]

There’s also a good JavaScript reference here:

https://en.wikipedia.org/wiki/JavaScript_syntax

[Melanie Schaaf]

Hi everyone,

I’m new to the forums, but I can’t seem to find a solution to this problem I have been having with my Tap Forms database during the last couple of days, so I hope someone here will be able to help…

I have a fairly large and complex database document in which I organize my sewing projects.
It consists of several forms each with hundreds of records, different custom layouts, scripts, calculations and multiple relationships. The database size currently is 3,75 GB. I have been working on it for over 10 months now and never encountered any problems like the ones I have been having recently.

As far as I can tell, the problem only occurs in one of the forms, which is the one in which I store all my fabrics.

Here’s what’s happening:
Entering new records seems to work fine. The problem occurs, when I edit existing records. I can make changes alright, add images, information and dates, etc. And at first everything seems to be fine. I can edit several records in this manner, still everything looks fine. I can leave the form, go to a different one, make changes there, return to the fabric form and all changes are still there and everything still looks fine. Then – mostly in order to re-sort the records – I hit the “Refresh Records List”-button. And then the changes I have made disappear. The record basically reverts to its original state, images I have added disappear, dates I have entered disappear, texts that I have edited revert to their original state. This even happens to records that I have created via the +-button. They become blank records again – however as far as I can tell, I have not lost a complete record in this manner, it’s always just the data in the record, that disappears, never an entire record.
And here’s what’s puzzling me the most: This happens only to some records! Some records work fine. Some don’t. Some keep their data and edits even after I have used the “Refresh Records List” button, some don’t. However, records that have once had this issue of edits and data disappearing will always have the problem, which basically means, they become uneditable, because all changes I make to them, will be gone once I use “Refresh Records List”. But as far as I can tell as I edit more and more of my already existing records, more and more seem to be having this problem. It’s like at first I can edit them fine, and the changes are saved properly and remain even after I use “Refresh Records List”, but then all of a sudden, the next time I add or edit data to them, they won’t save anymore and once I use Refresh Records, the last changes I made are gone.

At first I thought, this might be a syncing issue. I have been syncing this database via iCloud between two MacBooks. But after turning off syncing on both MacBooks, deleting the iCould database and keeping syncing turned off, the problem still occurs on both MacBooks independently.

To me it seems like an internal saving issue.
So next I tried using the “Show Save/Edit buttons” feature, thinking that if I use the save button every time I change a record, the data would be saved properly, so using refresh after that won’t undo the edits I made. It didn’t work, the data still disappears once I refresh even if I saved it via the button.

The problem of losing data and edits I entered occurs on both records I just created and also on records that I created months ago. Some I can edit, some I can’t; i.e. some maintain the changes I have made after I push “Refresh Records List”, some don’t. I can not find any regularity in any of it.

Again, the problem only occurs, when I use the “Refresh Records List” button. Until I use that button, all data remains as it should be.

Another thing that I found out is this:
If I close the database document and Tap Forms altogether, reopen it, I still see the data I have just entered/edited. If I then use “Refresh Records List”, no data disappears (as far as I can tell). It seems like closing the database properly saves the edits all records.

Please help, because this is driving me nuts!

[Brendan]

Hi Greg,

I think the Table solution should work for you. The benefit of the Table solution is that once you’ve selected the ingredients to copy to the Table field and entered the quantities, the prices for the ingredients is solidified into the Table field. This is historical data. The price on Monday when you made the recipe could be different than the price of the ingredients on Friday when you made it again. So you wouldn’t want to have the prices for the ingredients change for every recipe you used those ingredients before.

So I guess I’m not sure why you want to update all the prices in the already entered records of the Table field.

You can pretty much do anything you want with scripts. So you could write a script that if you changed the price of an ingredient, you could loop through all the records and Table field records and update the price for the already used ingredients. It would be a bit of a complex script though.

[Daniel Leu]

Have a look at “Scripting in Tap Forms” on https://www.tapforms.com/support/. Sam Moffatt and T.L. Ford provide additional resources on using scripting with TapForms.

Cheers, Daniel

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

[Mike Guilbault]

Can someone recommend any books, videos, etc. to learn JavaScript, particularly in relation to Tap Forms 5 rather than web use?