Search Results for 'script'

[scneophyte]

Hey TF Gurus! I’ve peeked at the template exchange and didn’t see anything. I’m embarking on a new TF database project: a repository for household expenses, specifically for organizing home-buying associated receipts (hooray!).

As a secondary purpose, I’d like to capture monthly expenses, likely through data-mining electronic downloads of my bank account.

My idea now is to use a similar framework as I have for my business:
Form 1: Companies
Form 2: Expenses
Form 3: Expense Categories
Picklist 1: Created from Form 3, used on Form 2

Form 1 joined to Form 2 on Company Name
Form 3 joined to Form 2 on Expense Category value

I’d consider myself a firmly average user of TF. I can code in Python, but don’t know any JS. Just looking for any friendly advice or ideas from other users, or inspiration to spend the time to develop some scripting knowledge, for example to automate the record creation from the bank download.

Thanks for reading!

[Brendan]

It’s awesome that you’re getting use from Siri Shortcuts integration in Tap Forms. Sometimes you never know how things like that will be used when you build them. The Script field is a super powerful feature in Tap Forms now. So many different things you can do with it. If you have the know-how that is :)

[Brex]

Thanks Brendan

That video was very helpful in getting me this far. I’ve been using about a dozen Siri-driven shortcuts that Form Scripts which add new records to self-monitoring TF database – with values that are specific to the Script I evoke (through Siri). All good.

Hoping to turn each of them into IOS Shortcut buttons at some later time – Siri doesn’t work well in all scenarios, per background noise and social setting :)

thanks as always

Brex

[Brendan]

Hi Brex,

Did you watch the video in the link I posted above? That basically shows how the Siri intents works. It works only with Form Scripts and not Field scripts.

I’m not sure about that error. This is the only thing I’ve found referencing that error:

https://talk.automators.fm/t/problem-running-from-shortcuts/2154/5

I’m not sure what I need to do yet to allow Tap Forms scripts to run from within the Shortcuts app. I’m sure there’s a bunch of work I have to do.

I’ll have to work on that.

[Brex]

Hi Brendan

I’ve made some handy voice-activated Siri Shortcuts that allow me to log things/create new records in TF. My use case doesn’t require input or a selection, I have several different scripts that add specific things, without interaction being necessary.

Not sure how to wrap each of these as a new IOS Shortcut button (which is even more convenient and accurate than Siri). IOS even “suggests” my Tapforms scripts, when I go to try to write a Shortcut, but it fails and can’t find explanation for error message on the web. “IntentsErrorDomain error 1307”

More work on your side required to enable TF scripts to work with the new Shortcuts (just as Siri-enabling was required)? Or am I doing something wrong?

thanks

Brex

[Denny Tuckerman]

Does anyone know how Tapforms (Ipad) can be loaded into Tapforms please. I’ve managed to get it as far as showing in Imports.
It’s an old format that was used (typically) for Windows Cardfile software. Or even a utility to convert my AZZ file into a CSV file?
Failing that – I’m currently designing a Tapforms database that holds the modules and descriptions of an online EE course I’m doing. I would like to have a link from the Tapforms record to open up this AZZ files as it’s a database of Electronic Symbols used in EE along with descriptions.
Don’t suppose anyone already has a template to save me reinventing the wheel?
Thanks
Dennis

Leave the Planet (tlalticpac) in a better shape than when you first found it
I’m Undead, I’m not Unreasonable (Dracula)

[Martin Kendall]

Thank you for that.

I’ve done some more investigation and the problem is when I change the field value using a pick list.

When I pick an item the script does not run, but if I type the value in it does run (this is an iOS issue only).

Shall I email you my form so you can see the issue? (It isn’t a parent firm, it is just a single form with an embedded table field)

Thanks for your help,

Martin

[Brendan]

Hi Martin,

It’s possible I’m not calling the code to run calculations and scripts when you save a value on a Table field.

If you’d like to email me your parent form template I could do some experiments on your form to make sure I get it right for your situation.

Thanks,

Brendan

[Martin Kendall]

Hi,

I have a field script dependent on a table field’s field.

On the Mac the field script runs when a new row is added or the field is modified.

However on iOS the field script only runs when a new Table field row is added.

Is this the expected behavior?

Thanks

Martin

[Brendan]

Hi Andy,

From your line var rating_id = 'fld-0f294ce98c3043e0a9873bfe1933276e;; I see that you had 2 semi-colons but no closing single-quote. That would not work.

It would have to be like var rating_id = 'fld-0f294ce98c3043e0a9873bfe1933276e';

No, a * wouldn’t work. But you could write a script to count the asterisk characters and convert that into an integer. But it would get more difficult with your “1/2” values, etc. You’d have to do some string parsing in that case.

There’s no undo. So make a backup first.

[Andy Rawlins]

Hi again

When using the format from the web site it worked perfectly so thanks.

One other query, in one of my databases, to get round Bento’s 5 star rating issue, I used a simple text field for rating and input what I needed as stars and 1/2 if I wanted. So if something was 3.5 stars I would enter ***1/2. Would the script work on that and if it did, could I then change it to a proper ratings field? I’m guessing it won’t because a * is not an integer in this context.

Also, is there an undo for this script or would I need to recover from backup if it went wrong. I have about 420 records in this database so could enter them in a new field manually if necessary but if the script would work, that would be great.

Many thanks

[Andy Rawlins]

In the script editor I selected the rating field and copied the ID into your script like this:

var rating_id = 'fld-0f294ce98c3043e0a9873bfe1933276e;;
var records = form.getRecords();
for (var index = 0, count = records.length; index < count; index++){
var aRecord = records[index];
var rating = aRecord.getFieldValue(rating_id);
aRecord.setFieldValue(rating_id, rating * 2);
}
form.saveAllChanges();

I didn’t see anything happen at all. Looking at it now, I left off the single quotes, have some extra characters at the beginning and an extra semicolon at the end. All these things appear in the email version of the script but not here on the website. I guess Mail has garbled it a bit. I have some other databases to do so will try it on them :)

Many thanks

Andy

[Brendan]

Did you use your own ID value for the rating_id field? Or did you just copy and paste and try to run the script?

Did you get any error messages in the console log?

I’m glad the other way worked for you at least.

Thanks,

Brendan

[Andy Rawlins]

Great, thanks Brendan. I couldn’t get the script to work – it didn’t seem to do anything but I was probably doing it wrong. However, the find and replace worked a treat so thanks for that :)

[Brendan]

By the way, to write the above script I only had to mostly just double-click on the various snippets in the Snippets list. The only thing I had to do was change the default variable name in the snippets. And this line of code I typed in: var aRecord = records[index];