Search Results for 'script'

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

[Brendan]

Sure. Have a look at the Scripting instructions in the online user manual:

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

Look for the topic on that page called Fetch Movie Data From Web Service

That script will monitor the changes made to a barcode field. If that field changes, Tap Forms will make a web service call to fetch a JSON object related to the movie for the barcode entered. Then it will populate the fields in that record from the data fetched from the web service.

[Prashant M]

This is awesome ! Thanks. I know how to create my webhooks , can I get an example of something like this from scripting perspective?

[Brendan]

Records are saved after every value is changed. You could setup a Script Field which monitors the values of a specific field (or fields) and then execute some web service call whenever the value in that field (or fields) changes.

[Daniel Leu]

I’m using a script field that calculates if something is due. Then I can search on this field.

• This reply was modified 3 years, 1 month ago by Daniel Leu.
• This reply was modified 3 years, 1 month ago by Daniel Leu.

Cheers, Daniel

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

[Jake Gregory]

Hi Everyone,

First time posting here – very new user of Tap Forms.

I’ve got a price list going on the Mac version, I would like to know if there’s a way I can run a script to increase the number in a number field by a percentage.

I don’t even seem to be able to get of the ground so if someone could show a code example I would really appreciate it.

Thanks

[Chris Ju]

Hi,

i’m using the following java script code to replace characters:

var chars = {'ß':'ss','&':'und','.':'','ö':'oe','ä':'ae','ü':'ue','é':'e','è':'e','Ö':'Oe','Ä':'Ae','Ü':'Ue','É':'E','È':'E'};
var nachname = (record.getFieldValue('fld-eef248f9679f47eb98598b22133da6ea').toString().replace(/[ß&.öÖäÄüÜéÉèÈ]/g, m => chars[m])).toString().replace(/\s/g, '%20');

Nothing is replaced with this code.

Adding for example UTF-16 code for character ‘ü’ -> ‘\\u00fc’ to the second variable string:

var chars = {'ß':'ss','&':'und','.':'','ö':'oe','ä':'ae','ü':'ue','é':'e','è':'e','Ö':'Oe','Ä':'Ae','Ü':'Ue','É':'E','È':'E'};
var nachname = (record.getFieldValue('fld-eef248f9679f47eb98598b22133da6ea').toString().replace(/[ß&.öÖäÄüÜéÉèÈ\\u00fc]/g, m => chars[m])).toString().replace(/\s/g, '%20');

leads for for example with the text “Stümper” to

‘Stundefinedmper’

Even if i add the UTF-16 code to the first variable, results to the same undefined issue.

Does anyone have an short idea to solve that?

Thanks
Chris

[dan carter]

Here are the 2 involved forms. Clients and Leg Curl. A client will eventually have many Leg Curl records with varying Target amounts. I would like getMax… and getMin… functions to display least and most Target amount, as well as, percent Change. The Duplicate Exercise script is where I attempt, unsuccessfully, to do this.

This DB is being developed on and for an iPad.

Thank you for having a look, Dan

• This reply was modified 3 years, 1 month ago by dan carter.

Attachments:

You must be logged in to view attached files.

[dan carter]

Thank you for the idea Daniel. This application will be used only on an iPad. Unfortunately when I use field scripts they prevent my form scripts from working.

My console.log returns “0” for min and max target.

I will upload my form template as per Brandon. I’m sure I’m missing something simple.