Search Results for 'script'

[David Oxtoby]

Thx Brendan, i’d assumed i needed a script, i just wasn’t sure how to even start referencing the form/records in the linked form to pull out one of the values, any pointers would be great. Thank you

[Brendan]

Hi David,

If you have a One to Many Link Type from Customer to Venue, then you can enable the Show Inverse Relationship option and you can get one customer to display on your Venue layout.

However, it looks like you probably have a Many to Many relationship. Is that required?

The only other way to get the customer information to appear in the parent field is to use a Script and pull out the first Customer record and populate the field on the parent form.

Thanks,

Brendan

[Vera Milosavich]

Thanks Chris. I knew I wasn’t the only one who felt that way, and I was also disappointed by FM’s competition — such as it is. TapForms has been the least formidable aside from it’s use of javascript.

It’s also encouraging to know you’ve had such success. I hope for the same. I had no trouble with FM’s scripting and formulas but I’m totally at a loss when it comes to javascript, and I know I’ll need that for my solution. I’m more than willing to try, but I’ll have no choice except to rely on this forum for help with that.

[Vera Milosavich]

That sounds promising. My current Filemaker db has 3 or 4 linked tables and 14k+ records in the largest table, accumulated over 5 years so roughly 2k new records are added each year. But that rate may increase in future years. It’s about 20mb now which is nonexistent compared to yours! I have no attachments but (combined amongst all tables) hundreds of fields, calculations, scripts (no JS!), and layouts — many of which I would eliminate if I retool for TapForms.

Aside from the upgrade cost of $540, my next biggest issue with FileMaker is that it has a crippled mobile app with no iCloud support nor import abilities. I can modify records and create new ones on the mobile app, but the hassle of transferring it back to my desktop to do monthly imports for invoicing isn’t worth it. So I basically use it as a read-only app which is better than nothing, but just barely.

If FM weren’t so expensive, I would upgrade and live with the lack of iCloud support and importing capabilities on mobile. But with those three whammies, I’m not happy. Even if I have to rebuild a stripped-down version and struggle with the learning curve, as long as TF can do the minimum of what I need, I think it’ll be more practical for me to switch over.

I understand TF for iOS has iCloud sync support. I don’t know if it can import CSV files, but as long as it can sync, I can live with that.

Thanks for the info on record capacity!

[Vera Milosavich]

This is an extract of a setup I have and the simple problem I’ve been trying to solve:

I have two linked dbs with the following relevant fields (and field types) set up:

1. TRANSACTIONS (has many records with the same Month/Year): Month/Year (calculation:text); Invoice (script:number); link_Invoice (link to form:join where Month/Year matches in both dbs)
2. INVOICES (Month/Year will be unique to each record): Month/Year (text); invoice number (number)

I want the Invoice field in TRANSACTIONS to display the Invoice Number from INVOICES where Month/Year matches so I used this script:

var invoice_number = link_invoice[index].getFieldValue('fld-8b601a885fab4ddca84e44bed77e8bc5');

I didn’t key in anything. I only selected the snippets I wanted then double-clicked the field I wanted from under the section with the link I set up. I get this error when I run the script in the editor view:

5/11/20, 4:11:06 PM / Paypal Imports (405) / Invoice-script
Invoice-script: ReferenceError: Can't find variable: link_invoice, line:(null)

I used Join as the link type, but I tried the others with no more luck. I can’t tell what I’m doing wrong because I can’t decipher the script.

I’m hoping it’s something simple…… although I’m officially beyond simple with my nonexistent javascripting abilities!

[Vera Milosavich]

Thank you, Sam. What I have is nothing as far as scripts go. I’ve tried using what seems to be the simplest snippet (get field value) but can’t get it to display the results:

var month_year_cart_item = record.getFieldValue('fld-66ac9ba074134a8598ae601cc72a1eb7');

As soon as I get a chance, I will post a description and diagram of the system I’m trying to develop. If from that information you can show me the script for creating summaries, and where it goes (and maybe tell me what each element of the script does?), I might be able to figure out some of the rest on my own.

Thanks again!

[Brendan]

Hi Vera,

Is there anything that’s common in your form for the 10-50 entries each day the that you could group your records by? When you set the First Sort Field to a Date field, Tap Forms automatically groups them into Month, Year sections.

If you need something more fine grained than that, you would need to create a Calculation or Script field that returns the day, month, and year as a Text value.

For example, a Calculation field with the formula:

DATE(Item Date; "yyyy-MM-dd")

That will return a value for your Item Date field (or whatever it’s called) and Tap Forms can then group on that field. So then all records with the same year, month, and day would all be grouped together into the same section.

Give that a try and see how it goes.

Thanks,

Brendan

[Vera Milosavich]

Can I get help with the Child Records Loop snippet — or whatever it takes to generate my invoices & summary reports? I have zero clue how to use javascript.

[Alejandro]

HI Brendan!
thank you!
I’m going to store the eventID in other fields of that form. Is like A600F804-4729-48FC-906B-E85ED7ACC874:117BCA7E-0500-457C-A101-DB830C1E3EE0

My idea is to have a special calendar for TF, and create events every time I see a Movie for example.
Then I can Visualise on my calendar when I saw movies. And also I add the link like:
tapformz://record/view/db-d604320e10394cd582b9b345b76a8f97/frm-b1e2b68a569c4dbe9e468c31f3a62188/rec-XXXXXXXXXXX
to get the details.

But If I need to reset my calendar I want to delete all days for example.

By the way, is there a way to run a script and the output (like console.log) save it to a file?

Kind regards
Alejandro

[Daniel Leu]

Now I see it….

Brendan, double-clicking on ‘Get total of field from form’ snippet returns

`var field-name_id = ‘field-id’;
var total = form.getTotalOfField(field-name_id);1

But the - is not a valid character to be used in a Javascript variable name.

The same applies to the other three Get... snippets.

Cheers, Daniel

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

[Wolfgang]

Hi Daniel,
that’s exactly what I wanted to say.
In Tap Forms in the script field the variable of the formula “get total of field from form” is displayed with “-” and always gave me an error message.
That’s why I removed the “-” and used “fieldname” or “field_name” …

[Brendan]

Ok, well that should work.

And sorry, for some reason I didn’t see your attachments before.

Did you return the values later on in your script? Or did you just define the vars?

[Brendan]

Can you post your script?

[Wolfgang]

Thank you for the info. But no result is shown …
I use 2 field scripts (see screenshots).
– one with the line you mentioned above
– one using the formula of the list in the script window
No entries in the fields!

Wolfgang

Attachments:

You must be logged in to view attached files.

[Brendan]

Hi Vera,

Ya, building a layout system that handles a fully customizable rows with grouping and summarizing is a ton of work. It is something I want to eventually do though.

Tap Forms can do multi-page reports by linking custom layouts together. But each custom layout can only be one page tall. But that does allow you to have lots of fields with complex layouts spread over multiple pages per record.

You could actually write a script that generated the summary data for you from your Link to Form (or Table) fields. You could even use a separate Table field to store the summary records and use that on your Invoice. So your Invoice could have the Table field (or Link to Form field) with all the details, plus a separate Table field to store the summary results.

You would have to use the Child Records Loop snippet as Sam suggested to loop through your child records accumulating a total for a field. I should really add the getTotalOfField() function to the record object so you could ask a Table field for a total of a specific sub-field.