Search Results for 'script'

[D J Leason]

@John cesta

Because x is the variable where the result 12 will be stored.Also I can change the arguments there. That’s what I got from it anyway. I’m new to JS and I copy and pasted it exactly as it was in the tutorial where it worked fine.

When JavaScript reaches a return statement, the function will stop executing.
If the function was invoked from a statement, JavaScript will “return” to execute the code after the invoking statement.
Functions often compute a return value. The return value is “returned” back to the “caller”:
Example
Calculate the product of two numbers, and return the result:

var x = myFunction(4, 3);   // Function is called, return value will end up in x

function myFunction(a, b) {
  return a * b;             // Function returns the product of a and b
}
The result in x will be:
12

[Daniel Leu]

You have to define your function outside of Script():

function myFunction(a,b){
   return a * b;
}

function Script(){
   var x = myFunction(4, 3);
   return x;
}

Script();

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

[D J Leason]

Trying to learn some Javascript so I can use the script field. I replaced the Hello World code with code from a W3Schools tutorial but it doesn’t work. What am I doing wrong?

Attachments:

You must be logged in to view attached files.

[john cesta]

Best way to display fields side by side….

DOB Age

When I use concat it gets messed up because one is a date and one is a number.

Is there a better way to write a record script to simple display fields side by side for viewing?

I’m sure there is.

Thanks,

[Sam Moffatt]

You would have a script field that is connected to the check box and then any time the checkbox state was toggled, it’d run the script and it could change the colour accordingly.

For John’s original today() == meetingDate example, I think you would have to tell Tap Forms to re-evaluate the calculations once a day if using a field script or have a form script that you run once a day to scan and update the record colours.

[matt coxon]

hi Brendan, this would be excellent, will it be conditional, example .. I have a checkbox record field “hot list” I use this for the most important records within a form. Currently I select all “hot list” via a filter, and then manually mark all as red. (and when no longer in the hot list I have to manually de-select the color) Would be good if I can automate (via a script)

thanks
Matt

[Sam Moffatt]

I’m not as sure about how to do this on iPad as I do most of this on the Mac and sync it over using CouchDB to my iOS devices however you should be able to do all of this on iOS as well.

1. I duplicate the entire document and then export the forms to a new document from time to time. If you use the duplicate option in Tap Forms on a document, it’ll give it a new document ID and isolate it for you. This is useful for testing, making sure sync doesn’t accidentally go somewhere you don’t intend and gives you the confidence that you can delete everything and start from scratch. The other thing I do is export the form template and load it up into temporary documents to toy with things.

2. You can recalculate either an individual record or all records in a form. To recalculate an individual record, on iOS you can drag down a record to recalculate it’s formulas and on the Mac use the refresh button at the bottom of the record layout or use the menu to go to “Records” > “Refresh Selected Record”. To recalculate an entire form, on iOS you can drag down the record list to recalculate and on the Mac use the refresh button at the bottom of the list for the view you are using or use the menu to go to “View” > “Refresh Records List”. Tap Forms will automatically recalculate a calculation when you change a referenced field unless you have the calculation field set to “Calculate only one time” (useful mostly for functions that use UUID() or some other fixed, one time operation). Similarly when you click refresh/drag down, it will ignore any “Calculate only one time” fields as well.

That said if you’re happy to wait a moment, refreshing an entire form isn’t the end of the world. I do it on my calculation and script heavy forms all of the time and it’s only a mild inconvenience. Many of my script fields also invoke web API’s hosted within my network, so I can easily see when I make that mistake. I do wish if Tap Forms notices it’s taking longer than a few seconds to recalculate that it gave some sort UI popup indicate where it’s at with stuff.

[Michael Harding]

Hi Sam. Again: many thanks for your help. It puzzles me that this formula once worked for me and continues to for me in one area of my form (the ‘discounting area’ versus the ‘unit cost’ calculation).

Nevertheless, I’ve spent hours trying to come to grips with it and did succeed in getting one cell to link to the total cost calculation result. Replicating the formula for other cells didn’t and doesn’t work.

I’ve looked everywhere and into everything to divine why this is so. Nothing seems to present itself and my analysis suggests that the problem isn’t so much the equation/scripting but an error somewhere else.

The cells are all correctly set up as number cells. They link in the correct order, as Brendan suggested doing a few days ago. But there must be something incorrect in the way Tap Forms is seeing the cells.

I have been through the various cells checking and checking and just don’t see where the problem lies.

[Brendan]

Hi Helmut,

Pick Lists don’t work for Date fields because you already get a popover view to select a date from the calendar.

Thanks for the feature suggestion for a fixed date value for a Date field.

One option would be to write a Form Script which you use to create new records that also sets a fixed date value for your Date field.

Thanks!

Brendan

[john cesta]

I guess I’m not sure how to use it.

Earlier I was opening a record with data in it. For that I received the no record error.

Now I opened a new record. When I run script it runs with no found data, no error either though.

So my guess is that it is searching for something but not finding anything so no results.

What I don’t know is how to tell the script what to look for. Do I need to have the barcode_field in the record filled in with a valid barcode for the movie I want to find? If so where do I find that barcode for the movie?

Can it use the title of the movie?

[Brendan]

Make sure you’ve selected a record first, then tap the action menu, then tap Run a Script from the record details view. The record object should be available at that time.

[Sam Moffatt]

The error is indicating record isn’t set in the context it’s trying to be used. On the Mac I’ve seen this when running a form script when there isn’t a record available. I think on iOS I’ve seen if where if you run a form script from the record list, this will happen because there is no record. If you’re running a form script from an open record and seeing this on iOS then that would be a bug I think. I think on iOS I have also run into this when in the script editor in certain places as well.

Do you mind sharing what you did and where you were at before triggering the error?

[john cesta]

Will the movie script work on the iPad mini tap forms?

I wasn’t sure if it’s only for the Mac.

If it works on the mini I’ll putt with it.

[Michael Harding]

Hmmm. Actually, I think I must have scripted those equations initially in Bento, which explains perhaps why I didn’t recall scripting the IFEMPTY commands…

[Brendan]

Hi John,

Not at the moment. But in the next update I’ve added a method called record.setRecordColor() which would let you do that by giving it a web colour in hex format. E.g. record.setRecordColor('#FF00CC'); It requires you use the Scripting engine though.

Here’s an example I just tested:

function Record_Colour_Script() {

	var number = record.getFieldValue('fld-046db84197fd44a6adf50b3a9ab426d5');
	var colourHex = '#005090';
	if (number > 20) {
		colourHex = '#c59';	
	} else if (number == undefined) {
		colourHex = 'CLEAR';
	}
	record.setRecordColor(colourHex);

	form.saveAllChanges();
	

}

Record_Colour_Script();

It won’t work yet in the production Tap Forms version. But it will in the next update.