Search Results for 'script'

[Goutalco]

Thank you Brendan,

I converted all my dictionaries to images and using your hint I successfully imported these images to my document via a CSV file. This part was quite straightforward.

Now I like to create a search inside a form script via the Prompter class and since my understanding of JavaScript is at best rudimentary I really appreciate any comment to the script that I was able to generate using the help file.

var root;

var user_input = function printOut(continued) {
	if (continued == true) {
	
		var page_for_root;
	       // Getting the pages of the dictionary
		var pages = form.getRecords();
		
		// Getting the id of the field that takes the first root present on a page
		var root_1_id = 'fld-e724350c999d4fddafc12d258d407a3c';

		// Getting the id of the field that takes the last root present on a page
		var root_2_id = 'fld-a01b915c72904b2caba68eb8c2657055';
		
		for (var index = 0, count = pages.length; index < count; index++){
			// Getting the first root present the current page
			var root_1 = pages[index].getFieldValue(root_1_id);
			// Getting the last root present the current page
			var root_2 = pages[index].getFieldValue(root_2_id);
			
			// Compare the root the user is searching for to root_1 and root_2
			var compare_1 = root_1.localeCompare(root, 'ar')
			var compare_2 = root_2.localeCompare(root, 'ar')

		       // Try to get the first page that contains root and 
                       // leave the loop in this case
			if (compare_1 <= 0 && 0 <= compare_2) {
				page_for_root = pages[index];
				break;	
			}			
		}
		
		// If there is at least one page that contains root, show the first one
		if (!(page_for_root === undefined)) {
    		        form.selectRecord(page_for_root);
  		} else {
  			console.log("Root not found");
  		}   
   } else {
          console.log("Cancel button pressed.");
   }
}
	
function Search_For_Root() {
		
	let prompter = Prompter.new();
	prompter.cancelButtonTitle = 'Cancel';
	prompter.continueButtonTitle = 'OK';
	prompter.addParameter('Root: ', 'root').show('Enter a root', user_input);

}

Search_For_Root();

Thank you for your patience.

Cheers

• This reply was modified 3 years, 11 months ago by Goutalco.

Attachments:

You must be logged in to view attached files.

[Goutalco]

Hello everybody,
I like to create a dictionary database for classical languages based on some scanned dictionaries (19th and 20th century) that are available in the form of PDF files. The PDF files are not searchable and due to the mixing of several alphabets and diacritical characters present in these files ocr is not reliable (creating searchable PDF files would be very time consuming).

The database should work with user input based on the roots of the language.

Example for one PDF file. Let’s call the dictionary DIC and let ABC be a root.

All entries in DIC pertaining to the Root ABC are present on a certain page of DIC.

I have a list of all possible roots and the page number pertaining to each root, for example

ABC: 23
ACE: 51`
BBD: 134`
…

I like to create a Tap Forms 5 document which has one of the following two options:

When the user searches for Root ABC, either

1. Tap Forms 5 tells the Preview or any other PDF-Application to open file to open the dictionary DIC and show page 23,
2. or a Form which contain all images of DIC opens record # 23.

For performance reasons (the PDF files are quite large – several GB) I’am inclined to opt for the second option.

So I have to create a form with a field that is able to accommodate photos obtained from the pages of DIC.
My question is:
1. How can I import thousands of photos into a Tap Form 5 form
2. and how can I search for roots?

The answer to the second question is probably connected to the Prompter class of the JavaScript API. But how can I import all the photos inside a Tap Forms 5 document?

Cheers

[Brent Willingham]

Brendan,

Thanks for the prompt response. The more complicated scenario, scenario 2, is what I’m looking to do. I have no experience with scripting, but looks like a fun challenge and this may be a good little project to practice on.

Thanks again for the support, and I really love the App!

[Brendan]

Hi Brent,

Cascading Pick Lists is something I’m working towards, but it’s not there yet.

But within a Script you can set a Pick List on a field based on some condition.

my_field.pickList = document.getPickList('Sub-Practice 1');

The tricky thing about cascading Pick Lists are there are really two different ways to go about them.

1. A simple hierarchical menu whereby you select the last level value and it gets entered into the field.
2. A more complicated scenario where you select a value from a Pick List in Field A, then Field B’s Pick List changes to list only those values that are associated with the selected value in Pick List A. For example, select a Country, then the Province field’s Pick List changes to those Provinces which are relevant only for the selected country.

[Brendan]

Hi Michael,

I added back-ticks around your code so it’s easier to read.

That looks like it should work. But record is a keyword that means to use the currently selected record. In the script I would change record to rec or something like that. See if that solves the problem.

Thanks,

Brendan

[Brent Willingham]

I think this thread pretty well describes what I am looking to do. I want to create a database that tracks activities and expenses related to Wildlife Management Practices that need to be done to maintain a wildlife exemption on a property. There are 7 different pre-defined main management practices and each has it’s own set of sub-practices. So a parent/child pick list situation – I think. There would be a Management Practice field that has a pull down pick list. Depending on which practice is chosen, it’s respective sub practice list would appear in the Sub Practice field.

Since I’m a novice and don’t have any experience with scripting, I think I’d be ok with Sam’s idea in Reply 43418: “If you have a few options, you could use the built in pick lists and create one for each of the levels.”

I don’t expect the categories or sub-categories to change so I don’t mind creating pick lists for each of the levels – I just don’t really know how to get started here.

Thanks,
Brent

[Victor Warner]

I am using the prompter function and for a popup list is it possible for one to be the default?

On running the script, the default is “Unspecified”

For example in the following code for passport_type_list variable, I would like the first entry (‘United Kingdom of Great Britain and Northern Ireland passport’) to be automatically shown rather than ‘Unspecified’.

var heshe;
var heshe_list = ['his', 'her'];
var director_signee;
var passport_type;
var passport_type_list = ['United Kingdom of Great Britain and Northern Ireland passport', 'Irish passport', 'United States of America passport'];

let prompter = Prompter.new();
prompter.cancelButtonTitle = 'Cancel';
prompter.continueButtonTitle = 'Continue';
prompter.addParameter('Passport type: ', 'passport_type', 'popup', passport_type_list)
prompter.addParameter('He or she: ', 'heshe', 'popup', heshe_list)
prompter.addParameter('Name of the director signing: ', 'director_signee')
.show('Choose whether there is a he or she\n\n\nIf a company then put in name of director signing',output);

• This topic was modified 3 years, 11 months ago by Brendan.

[Daniel Leu]

Yes, using a custom layout you can place buttons that execute a script. It is a big time saver.

In the custom layout editor, select the ‘add run script button…’ at the top right, place the button on your layout, and the set the button script.

Attachments:

You must be logged in to view attached files.

Cheers, Daniel

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

[Tom Vogt]

Is there a way to create a button (or something looking like a button) in a layout and trigger a script through it?

I’m building a simple book keeping thing with Tap Forms for my wife and she’s a complete non-techie. Starting a script from the menu would work for me, but for her a button right at the right place in a layout would be much better.

[Michael Tucker]

I have fields just two fields that need to operate in a form….

ShareSell$Amt (numeric, id:fld-89c6961ad2ec43e8853ff13e052fc807)
NextRung$Amt (calculation, id:fld-276de1515a7c4054b9df9410cbbefd29)

I just want after a find of the fields involved, to run a script to
read in the first found record field NextRung$Amt,
move to the next record and insert that read amount into field ShareSell$Amt,
then continue thru the found set of records.

The first record has the beginning ShareSell$Amt that is calculated in the record as NextRung$Amt.

The function I’m looking for — is that number from the field NextRung$Amt is picked up and put into the next record’s ShareSell$Amt, and that makes that record calculate a new NextRung$Amt, which is picked up and put into the next record, then on until records in the found set run out.

This script just stops on the first record, so it needs something.

function Calc_NextRung_LADDER4() {
	let balance = 000000;
	var nextrung_id = 'fld-276de1515a7c4054b9df9410cbbefd29';
	var newsharesell_id = 'fld-89c6961ad2ec43e8853ff13e052fc807';
	//var transaction_date_id = 'fld-2567fc59b0ce45f982f2fe2d20eb0d79';
	//need a saved find 'Calc_Balances LADDER4'
	//Sam Moffatt, Tap Forms Forum, 10/21/2019 #37289
	
	for(record of form.getSearchNamed('Calc_Balances LADDER4').getRecords())
	{
		balance += record.getFieldValue(nextrung_id);
		record.setFieldValue(newsharesell_id, balance);
	}
	document.saveAllChanges();
}

Calc_NextRung_LADDER4();

In the screenshot, this set has 8 records or “rungs”. Theoretically the script would populate the 7 following rungs or records after the amount is first set to begin in the first record.

Thanks for those that make these things easy for those of us who infrequently dabble in scripts,
Mike

• This topic was modified 3 years, 11 months ago by Brendan.

Attachments:

You must be logged in to view attached files.

[Stig Widell]

Hi,
The Swedish farmer now has an excellent tool with Tap Forms 5 in organizing cows and calves. Two script are involved created by Brendan and Sam, thanks to both of them.
However there is a need for one more script.
The birth date of a calf in form “Kalvningar” is equal to the delivery date for the mother cow. In the form “Rekryteringsdjur” there is a list of all deliveries for a cow.
Now there is a need for a field in “Rekryteringsdjur” identifying the date of the cows latest delivery.
I hope someone can help me!!
Enclose the template.

Attachments:

You must be logged in to view attached files.

[Brendan]

Hi Ed,

So are you looking for some sort of a dashboard or something?

You could do that with a Form Script that fetches totals from fields from different forms and then displays them in a form.

See the scripting topic here:

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

To get a total of a field from a specific form, you can use code like this:

function populateFormTotals() {

   // get the form you want a total from
   var form1 = document.getFormNamed("Form 1");

   // get the field ID you want the total from
   var form1Field1Id = form1.getFieldNamed("Quantity").getId();

   // get the total for all records in form1 for the specified field.
   var totalOfForm1Field1 = form1.getTotalOfField(form1Field1);
   
   // put the total into a field on this form.
   var totalField1Id = form.getFieldNamed("Total Field 1").getId();
   record.setFieldValue(totalOfForm1Field1, totalField1Id);
   form.saveAllChanges();
}

populateFormTotals();

You would then want to populate all the fields in your form with the values obtained from the different forms and fields. But you have to decide what those would be.

Then whenever you want to see the overall totals, just run the form script again and the fields will update.

Thanks,

Brendan

• This reply was modified 4 years ago by Brendan.

[johnny_law]

I just started having the same problem with a script I use everyday that programmically adds rows to a child form using the command “ record.addNewRecordToField(id)”

The first time a row is added it is linked to the parent form. The subsequent rows are not.

This broke with the last update I just updated yesterday to version 5.3.24.

Prior to this version it was working great.

Regards,

Johnny

• This reply was modified 4 years ago by johnny_law.

[Victor Warner]

In a post I received a help from Sam Moffat and Brendan on how to create, from one form, a set of records in a linked form with a form script. (The post: https://www.tapforms.com/forums/topic/how-to-add-more-than-one-record-at-a-time-using-a-form-script/).

The script below work correctly (it creates the records in the link). However, only the first record created in the linked form is linked. The others are not linked, and it is necessary to go through them one by one to create the link.

The field linking the two forms is Link to Form, One to Many.

Is there a way to overcome this? Any help would be gratefully received.

The script:

`// Fields from Time Spent form
var order_of_records_id = ‘fld-d78467379e004205b7893109bca23db2’;
var date_of_activity_id = ‘fld-5b07fd9bb7b441848d31de782bcd8780’;
var time_spent_id = ‘fld-be5bcddb8b46426eb90dded15790ef89’;
var activity_id = ‘fld-160340262dbd416291dbeebd7119bd86’;
var description_of_activity_id = ‘fld-c4316e0ee4e7457b92b2f8cc6f699200’;

// Date fields

// Add today’s date
var date_signed = new Date();

// Formatted to 23/04/2022 for entry in a time entry
var date_signed_formatted = date_signed.toLocaleDateString(“en-GB”, { year: ‘numeric’, month: ‘long’, day: ‘numeric’ })

console.log (date_signed + “\n” + date_signed_formatted);
var output = function printOut(continued) {
if (continued == true) {

console.log(heshe + ‘\n\n\n’ + date_signed + date_signed_formatted);

let entries = [{
[order_of_records_id]: “1”,
[date_of_activity_id]: new Date(),
[time_spent_id]: “6”,
[activity_id]: “Calls & emails”,
[description_of_activity_id]: “”
},
{
[order_of_records_id]: “2”,
[date_of_activity_id]: new Date(),
[time_spent_id]: “6”,
[activity_id]: “See and identify client”,
[description_of_activity_id]: “See client at [ ] – identify client by ” + heshe + “United Kingdom of Great Britain and Northern Ireland passport and a second form of identification”
},
{
[order_of_records_id]: “3”,
[date_of_activity_id]: new Date(),
[time_spent_id]: “12”,
[activity_id]: “Discuss client’s document(s)/matter, see client sign document(s)”,
[description_of_activity_id]: “Client [ ]\n\nObtain confirmation that:\n\n(i) client has read the Power of attorney, \n\n(ii) the facts and information contained in the Power of attorney are correct,(iii) client is willing to be bound by the Power of attorney; and \n\n(iv) client is willing to grant the power of attorney in favour of the person(s) named in the power of attorney\n\nOn ” + date_signed_formatted + ” at [ ] and [name of client] signed the power of attorney in favour of person named as the attorney in my presence as a deed with myself acting as a witness”
},
{
[order_of_records_id]: “4”,
[date_of_activity_id]: new Date(),
[time_spent_id]: “12”,
[activity_id]: “Notarise document”,
[description_of_activity_id]: “Prepare covering certificate for 1 document (Power of attorney) and attach the covering certificate to the Power of attorney document – bind, seal and sign”
},
{
[order_of_records_id]: “5”,
[date_of_activity_id]: new Date(),
[time_spent_id]: “6”,
[activity_id]: “Arrange for legalisation/apostille”,
[description_of_activity_id]: “Arrange with legalisation agent to collect 1 document (Power of attorney) and then obtain apostille using normal service of the Foreign, Commonwealth and Development Office, and deliver the documents by courier”
},
{
[order_of_records_id]: “6”,
[date_of_activity_id]: new Date(),
[time_spent_id]: “”,
[activity_id]: “Write up notarial register”,
[description_of_activity_id]: “”
}

];

for (let entry of entries) {

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

newRecord.setFieldValues(entry);

}

document.saveAllChanges();

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

}

}

var heshe;
var heshe_list = [‘his’, ‘her’];

let prompter = Prompter.new();
prompter.cancelButtonTitle = ‘Cancel’;
prompter.continueButtonTitle = ‘Continue’;
prompter.addParameter(‘He or she: ‘, ‘heshe’, ‘popup’, heshe_list)
.show(‘Choose whether there is a he or she’,output);`

[Tom Vogt]

Hm.

Is there a way to script this, basically “when opening this view, refresh records” ?