Search Results for 'script'

[Brendan]

Peter,

Your Result Type for your Total Script field is set to Text. Try setting it to Number and see if that solves your issue.

Thanks,

Brendan

[Peter Riley]

Thanks Daniel and yes, it’s the Inventory table, which should look like the attachment.

My field script for the Total field is this: record.getTotalOfLinkedFieldForField('fld-ac6d9e3d03ae441994ff64b37ebba4f4', 'fld-b02673a0fe39401583e737a0876998e6');

The interesting thing is that if I change the brew that currently has a total of 11 remaining bottles to a number less than 10 it works, so I guess you’re right in that the Total field is being interpreted as a string and therefore the search for a number less than 3 fails because it parses the first ‘1’ of ’11’ only. Using return parseInt(total) as follows doesn’t seem to make a difference (the console in the editor correctly displays 11):

function return_total() {

var total = record.getTotalOfLinkedFieldForField('fld-ac6d9e3d03ae441994ff64b37ebba4f4', 'fld-b02673a0fe39401583e737a0876998e6');
return parseInt(total);
    }

return_total();

Thanks

• This reply was modified 2 months, 1 week ago by Peter Riley.

Attachments:

You must be logged in to view attached files.

[Daniel Leu]

Is the table you’re revering to the Inventory table? Looks like you just discovered a but where the TFF file doesn’t contain the fields inside the table.

In your script field, it might be that the result is interpreted as a string and not an number. You might want to try to use return parseInt(total); and set the return type accordingly. I don’t have the content of your script field so I’m just imagine what you might do.

Good luck and cheers!

Attachments:

You must be logged in to view attached files.

Cheers, Daniel

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

[Peter Riley]

My home brew database has a record for each beer recipe and each record has a table field where I log each brew of that recipe. One of the table’s fields is Quantity (number of bottles produced) per brew, so there are usually several rows in the table. The main recipe record has a Total field that is a script field to sum the remaining bottles from the table Quantity field with this code:

record.getTotalOfLinkedFieldForField(linkedFieldID, fieldID);

to populate it, where linkedFieldID is the table ID and fieldID is the Quantity field.

I have a search named ‘Brew Some More’ to filter the records where Quantity = 0. That works OK, but if I edit the search criterion to be ‘Quantity is less than or equal to 2’ I get beers with 11 bottles remaining, but not those with 4 or 8. I suspect I have a data type issue maybe?

Attachments:

You must be logged in to view attached files.

[Brendan]

Hi Glen,

So sorry for my delayed response.

1. A Field Script can be written which will run automatically when the Company is selected from a Pick List. You could then use the Prompter feature in the script engine to fetch a list of addresses from the selected company and let the user select from a popup which address to select. It’s a bit involved in writing a script to do that though. Not sure how your JavaScript skills are. Look at the Prompter instructions in the online user manual:

https://www.tapforms.com/help-mac/pro/en/topic/javascript-api

2. The Link to Form field popover view won’t filter the list of addresses based upon the selected Company Name. So that won’t work. Although you can type into the search field to find the company and it will filter the list. As long as the Company Street form also has a field that contains the company name.

Thanks,

Brendan

[David Kramer]

Question to Brendan Duttridge – On page 66 of the TFP manual shouldn’t this link to the Client Expenses form NOT the Client Call Log?

GENERAL QUESTIONS

(1) Field Types: What is the difference between TEXT field and NOTE fields. Can Notes fields be searched? What is the specifications in terms of number of characters for each?

(2) Check Box. On my FM database I have Boolean fields. In FM they are either 1 or 0. Then in the layout I describe what the meanings are for 0/1. In TFP do I import them as numeric and can I then convert to a Checkmark. How? Or do I leave them as numeric and maybe a pick list will format numeric into correct items or checkmarks?
Any ideas are welcome.

THE FOLLOWING WAS A QUESTION I WAS GOING TO POST – BUT I THINK I HAVE A SOLUTION:

3)on my FMDB I have 4-tables. Each one has a unique ID. I have exported them from FM as Merge files and massaged in Numbers. I have renamed the FM IDs as -rec_Form_Record_ID and imported as type=numeric.

Three of the FM tables imported (mostly) correctly but one table reads only 2 records and stops (ignores 150+ records). In Numbers I deleted the first 10 records thinking there was something there causing problems but TFP still only reads 2 records.

Then I had an idea. I opened the merge file in Excel. Saved it as CSV; changed the name. AND TFP imported ALL the records.
There was a small problem in that TFP created additional records with field information out of order. However those were easily deleted.

4) so I have imported my FM data. In each record there is rec_Form_Record_ID. I then redefined the child record id as Link-To the appropriate child record. Moved the link-to field onto the layout. I expected to see the child-records in the parent record. But I Do Not see the child records automatically. I do see the child records if I choose “Select existing linked records.” And manually link them. But not automatically based on stored ID values.
Note: The import data prefaced the id fields with -rec_Form_Record_ID which I changed to Form_Record_ID once it was imported.

5) In FM I used a starting value which is different for each table. Since I already have unique ID numbers how do I specify the starting ID number in TFP (starting from the last number ID used and then use an increment.

6) after a lot of trial/error I was able to format field names and values (stroke/fill). But I could not get TFP to format a button I added to my form?

7) I’m asking a favor. Can someone write a script for me that when runs opens a layout (1) within this form and or (2) opens a form in a different form. Once I have that as a template I’m sure I can figure out other buttons I need. Thank you.
Forms:
– Form1
– Form2
– Form3
Layouts I created:
– General
– Instructions
– Expenses

Example: From the General layout the user may want to go to the Instructions [button] layout which is within the same form or may want to go to the Expenses [button] layout which is in a different Form.

Thank you all.

[Glen B]

Perhaps I am approaching this wrong.

Simply put I have two Forms
Company
Order

Company Form has multiple fields but only two that we are needing to work with for this problem
Company Name
Company Street

On the Order Form there are two fields of interest
Company
Street

On the Order Form Company is a Picklist from Company Form using Company Name field for the list

The problem trying to be solved is that every Company may have multiple Street addresses so on the Order Form I would like to have the field Street be a Picklist based off of the Company selected in the Company field.

My thoughts are:

1. Can a script be triggered on the selection of the Company from the Picklist that then generates a list of Street values for that company and those are then populated into the Picklist for Street? Not sure what happens between records as different Companies or different Streets are needed.

2. Or is there a relational link that can be done between the Street fields that utilizes a filter based on the Company selected.

Any direction or solutions are appreciated (hopefully I have explained the problem clearly)

regards,

[Daniel Leu]

Two things come to my mind:

1. 1) Is client_first_name_and_email_address_details defined? Maybe the contact details link is missing. In this case I would use if (client_first_name_and_email_address_details == undefined) return; to skip the rest of your script. You might want to add a log message as well.
2. 2) Did you just migrate to Tap Forms Pro? If yes, client_first_name_and_email_address_details is likely an array. So you might want to use just the first element with client_first_name_and_email_address_details[0].

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

Cheers, Daniel

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

[Victor Warner]

I have a field script in Form which pulls in data from another Form (client_contact_details), which was working the last time I used it, but it is now producing an error:

Email adress for invoice: TypeError: client_first_name_and_email_address_details.getFieldValue is not a function. (In 'client_first_name_and_email_address_details.getFieldValue(company_name_id)', 'client_first_name_and_email_address_details.getFieldValue' is undefined),line:(null)

The script is now within a function, so I do not understand the error means. Any help in solving this would be greatly appreciated.

The script:

// Return values
var Dear_Name = "Placeholder";
var Email_to_send_invoice = "test@example.com";

// Form ID
var client_contact_details_id = 'fld-c53e48e48e3a40c7a5656ab92f39ecc9';
var client_first_name_and_email_address_details = record.getFieldValue(client_contact_details_id)

//Company details
// company name
var company_name_id = 'fld-a3300e3db044421598ae171c0a2d4834';
var company_name = client_first_name_and_email_address_details.getFieldValue(company_name_id);

console.log(company_name);

if (company_name == null) {
// first name of individual
    var first_name_id = 'fld-45599a4f0a6342d8973faed53dfbfed8';
    var first_name = client_first_name_and_email_address_details.getFieldValue(first_name_id);

    // Email address of individual
    var email_id = 'fld-8f9a928a7d554527b4127ef811136210';
    var email_individual = client_first_name_and_email_address_details.getFieldValue(email_id);

    Dear_Name = first_name;
    Email_to_send_invoice = email_individual;
} else {
    // first name of company contact
    var first_name_company_contact_id = 'fld-24ee4dae33d941bf81e1667853a7a949';
    var first_name_company_contact = client_first_name_and_email_address_details.getFieldValue(first_name_company_contact_id);

    // email address of company contact
    var email_company_contact_id = 'fld-8cfa7613f04f4a8b82652bc27f3c05df';
    var email_company = client_first_name_and_email_address_details.getFieldValue(email_company_contact_id);

    Dear_Name = first_name_company_contact;
    Email_to_send_invoice = email_company;
}

console.log(Dear_Name + " " + Email_to_send_invoice);

Email_to_send_invoice;

[Harry]

No problem. I’m sure the launch of TFP has kept you pretty busy.

In my original post, I used a calculation field to illustrate the problem. But I also use script fields in a few forms to calculate days between dates. The script fields are not working. Here’s a script that I use:

function Days_Since() {

var today = new Date(Date.now());
today.setHours(0,0,0,0);

let last_occurence_date = record.getFieldValue('fld-a00b75456ce64c09b3333f5205eebbae');
last_occurence_date.setHours(0,0,0,0);

var daysAgo = Math.round((today.getTime() - last_occurence_date.getTime()) / 86400000);

if (daysAgo == 0) {
	return "Today";
} else {
	if (daysAgo == 1) {
	return "Yesterday";
} else {
    if (daysAgo > 1) {
    return daysAgo + " Days Ago";
    }
}
}
}    
Days_Since();

This field returns a text value.

This field does not update when I pull down on the list. But it does update after I close the form and reopen it. That’s what I’ve been doing. Just a minor inconvenience.

• This reply was modified 2 months, 4 weeks ago by Harry.
• This reply was modified 2 months, 4 weeks ago by Harry.

[Daniel Leu]

Using a form script with the Tap Forms Pro API (https://www.tapforms.com/help-mac/pro/en/topic/javascript-api), you could publish content from TFP to Listmonk.com.

Cheers, Daniel

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

[Victor Warner]

I would like help with a Form script concerning a prompt.

The prompt window displays a date field and then 3 further fields:

1. Field 1: to the type of service,
2. Field 2: to choose the number of items, and then
3. Field 3: how to send it items

It runs from one form (Notarial Act) and once the fields in the Prompt are populated with data, then the script creates a new record with the data entered in another (Linked to) Form (Disbursements). If all 3 fields are populated, 3 records are created in the Linked to Form.

The script below does this.

However, I would like to be able to amend the script so that if Field 3 is set to ‘none’, then only 2 records are created.

Given the way the prompt script is written/structured, I am not sure how to add this option. Any help would be greatly appreciated.

`

var date_id = ‘fld-7b9283660edc4c818320ec930d427747’;
var type_of_disbursement_id = ‘fld-aad6018d791d477f9c0d323c604712a7’;
var unit_price_id = ‘fld-5dad44183eb04dc38d6c8565e008be25’;
var no_id = ‘fld-27cb8e3b36c7472eb4967ccb45b804d9’;

var output = function printOut(continued) {
if (continued == true) {

// take date entered in prompt (put into variable date_of_invoice)
// and format so it can be written

var vDate_of_invoice_2 = date_of_invoice.replace(/(\d+)\/(\d+)\/(\d+)/, ‘$2\/$1\/$3’);
var vDate_of_invoice_3 = new Date(vDate_of_invoice_2);

// var vDate_of_invoice_formatted = vDate_of_invoice_3.toLocaleDateString(‘en-uk’, {year: ‘numeric’, month: ‘2-digit’, day: ‘2-digit’});
// var vDate_of_invoice_formatted_ISO = vDate_of_invoice_formatted.replace(/(\d+)\/(\d+)\/(\d+)/, ‘$3-$2-$1′);

if (service_type==’Standard Service’){

var Type_of_Disbursement_variable = ‘FCDO – apostille (standard service)’;
var Type_of_Legalisation_Service_variable = ‘Legalisation agent (standard service)’;

} else {

var Type_of_Disbursement_variable = ‘FCDO – apostille (restricted urgent)’;
var Type_of_Legalisation_Service_variable = ‘Legalisation agent (restricted urgent service)’;

}

if (service_type==’Standard Service’){

var cost_of_apostille = ’40’;

} else {

var cost_of_apostille = ‘100’;

}

if (service_type==’Standard Service’){

var legalisation_cost = 18 + (18.00 * number_of_apostilles);

} else {

var legalisation_cost = 100;

}

let entries = [{
[date_id]: vDate_of_invoice_3,
[type_of_disbursement_id]: Type_of_Disbursement_variable,
[unit_price_id]: cost_of_apostille,
[no_id]: number_of_apostilles

},
{
[date_id]: vDate_of_invoice_3,
[type_of_disbursement_id]: Type_of_Legalisation_Service_variable,
[unit_price_id]: legalisation_cost,
[no_id]: “1”

},
{
[date_id]: vDate_of_invoice_3,
[type_of_disbursement_id]: “Courier costs (via legalisation agent)”,
[unit_price_id]: courier_cost,
[no_id]: “1”

}

];

for (let entry of entries) {

let newRecord = record.addNewRecordToField(‘fld-7e308c2071e248fba8012dee54b53b97’);

newRecord.setFieldValues(entry);

}

document.saveAllChanges();

} else {
console.log(“Cancel button pressed.”);
}
}

var date_of_invoice;
var service_type;
var service_types = [‘Standard Service’,’Restricted Urgent’];
var number_of_apostilles;
var number_of_apostillesx = [‘1′,’2′,’3′,’4′,’5’, ‘7’, ‘8’, ‘9’, ’10’];
var courier_cost;
var courier_costx = [’75’,’none’];

let prompter = Prompter.new();
prompter.cancelButtonTitle = ‘Cancel’;
prompter.continueButtonTitle = ‘Go’;
prompter.addParameter(‘Date of invoice: ‘, ‘date_of_invoice’)
.addParameter(‘Type of Service: ‘, ‘service_type’, ‘popup’, service_types)
.addParameter(‘Number of apostilles: ‘, ‘number_of_apostilles’, ‘popup’, number_of_apostillesx)
.addParameter(‘Cost of the courier: ‘, ‘courier_cost’, ‘popup’, courier_costx)
.show(‘Add date, number of apostilles, service and whether sent by courier’, output);

`

[Brendan]

Calculation fields can only get an aggregate value from a Link to Form field.

If you need to pick out specific records and fields from a related form, you’ll need to use a Script field.

Calculation and Script fields are essentially read-only.

[Alan Hayman]

Hi, Brendan,
That doesn’t do it.
My iPhone is an 8 Plus (I know, it’s obsolete) running iOS 16.7.10, and my iPad is an M1 iPad Pro 13″ running iPad OS 17.6.1.
In both cases, when I tap the blue “Subscription Options” button from the 10-record limited screen, and then tap “Restore Purchase”, it hesitates for a moment, and then goes back to the 10-record limited screen with the “Subscription Options” button.
In both cases, I have WiFi turned on, and I have Tap Forms Pro open and running on my Mac.
Suggestions?
Thanks.

[Glen Forister]

That is what I was looking for. I thought I had that answer in my Form of questions in TF, but couldn’t find it. So I went to copy the question and answer to enter it into my Questions form.

WHAT? I can’t copy any text from this web site anymore. How are we going to copy those Scripts to use in our forms???