Search Results for 'script'

[Chris Ju]

Thanks, Sam, but what do mean exactly with

“you can also work around that by using self referencing script fields that maintain their value set by an external script”?

Do you have a short example?

[Sam Moffatt]

Chained fields is going to be complicated because how many times does the refresh need to be called to resolve everything becomes a recursion problem. How do you know when to stop evaluating if someone adds say a time based script that mutates each execution.

A model I’ve used is having a single script that calculates everything and then stores the data in normal fields. There isn’t a read only option so they can be mutated by the end user but you can also work around that by using self referencing script fields that maintain their value set by an external script.

[Sam Moffatt]

Are you looking for exact duplicates (all fields identical) or duplicates on a primary or subset of key fields? If you want all fields identical, does this extend to link to form fields, table fields or photo fields and their contents?

I was working a while back on tooling to do merging of records through the scripting interface to handle when I end up with duplicate shipping records due to key mismatch (sometimes the tracking numbers are changed in transit) but I never got it finished because the UI experience wasn’t something I figured out.

If you’re after a subset of key fields, I did a quick POC where you create a new field in your source form with the key. I already had a composite key field built using a calculation field I use which looks like this (square brackets for field placeholders):

IFEMPTY([Marketplace];"No marketplace";
CONCAT([Marketplace], "/",[Store Name], "/",[Order ID]
))

This creates what should be a unique key for the record based on my own metadata (designed to handle direct sales and hosted marketplaces). I then created a new form called “Orders Dedupe” and put in it three fields: a *string* type field called “key”, *link to form* field called “Order Dedupe” and a script field which counts the entries in the order. The link to form field is configured as a JOIN type on the “key” field of the dedupe form and the calculation field in the original form. The script field looks like this (change your ID’s to match):

function Key_Match_Count() {
	var order_dedupe = record.getFieldValue('fld-fde68e7d2b384cb2a4452d3ae66bbab1');
	return order_dedupe.length;
}

Key_Match_Count();

In this form also create a new saved search that uses the script field and is set to look for values greater than one as those will be the duplicates.

Last step is to populate this form, go back to your base form and create a new form script. I wrote the script below to scan each record, use an md5sum implementation to create a hash of the key field and then look to see if that record exists in the dedupe form:

document.getFormNamed("Script Manager").runScriptNamed("md5sum");

var purchase_key_id = 'fld-3e49aaa5bc32429c8f0f0f234878356d';
var dedupfield__key_id = 'fld-c52906ee940142a0a54fac1a98346afd';
var dedupForm = document.getFormNamed("Order Dedupe");

function Extract_Purchase_Keys() {
	for (let sourceRecord of form.getRecords()) {
		let purchaseKey = sourceRecord.getFieldValue(purchase_key_id);
		if (!purchaseKey) {
			console.log("Missing purchase key for record: " + sourceRecord.getUrl());
			continue;
		}
		let purchaseKeyHash = "rec-" + md5(purchaseKey);
		let dedupRecord = dedupForm.getRecordWithId(purchaseKeyHash);
		if (!dedupRecord) {
			dedupRecord = dedupForm.addNewRecordWithId(purchaseKeyHash);
			dedupRecord.setFieldValue(dedupfield__key_id, purchaseKey);
		}
	}
	document.saveAllChanges();
}

Extract_Purchase_Keys();

This actually found me a dupe record that I hadn’t found in my orders form when I went back to look at the saved search. It’s a bit of a journey, might turn it into a video at some point when I get some more time.

[Bert Rietveld]

I have over 84,000 records. Sorting and manually scanning would not work. Is there a script to find duplicates?

[Chris Ju]

I just resolved the automatic refresh of all required fields (with all their dependencies) just by changing the order of the fields and adding an if-loop to each of the calculation fields and the script field. Now i can click the “+>”-Button and all fields are refreshed without hitting CMD-R.

BTW: I had also the idea to merge the calculation fields to the script field, but i don’t know if this will do it (at the moment i haven’t the time to “translate” the formulas to javascript)…

@Brendan: Isn’t possible to add an function like << record.refreshRecord(recordID) >> which will do the same as CMD-R?

[Chris Ju]

Hello,

i’m trying to refresh a new child record which i created with ‘record.addNewRecordToField’ in background.

I just don’t want to double click the new entry and press CMD-R. In the related child form there a some script and calculation fields. The problem is, that calculation 1 has an result for calculation 2 and these both has a result i use in a script field.

At the moment i have to open the new record and press three times CMD-R. This isn’t so funny that I want to do it 100 times a day…

I couldn’t find something in the javascript documentation to trigger the refresh with a script…

Had anyone had the same problem and have a solution?

Thanks a lot…

[Daniel Leu]

Maybe using web links instead of ‘alias attachments’ might be an option. Usingfile://nas_mounted/path/to/file.pdfas theURLopens the file, assuming that the directory is selected asScript folder access in the preferences.

In one of my uses where I have to link to several files, I use a table. Each row will point to a separate file.

In Finder, if you ctrl-click on the filename and then press the alt key, you can copy the pathname for the file. Then you can use a simple form script to set the URL field based on the just copied pathname using Utils.copyTextFromClipboard()

• This reply was modified 4 years, 3 months ago by Daniel Leu.

Cheers, Daniel

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

[Sam Moffatt]

The files themselves have the same name and extension of the target but the contents are the secure bookmark metadata so double clicking on it directly won’t work because the file needs to be resolved by the owning application (in this case Tap Forms) which then opens the actual file. Finder doesn’t seem to handle this, I ran into this when I was toying with things trying to figure stuff out.

I was looking at the file, it should have the metadata needed to reconnect the file assuming the paths are the same but I guess the security store (TCC maybe?) needs to validate it or something.

If you do the add, it’s just a copy. If you update the NAS file you need to delete it from the Tap Forms document and re-add it. Maybe with a newer version (TF6?) an expanded scripting API for interacting with the local file system might work where you could detect that and process it. I think you can sort of do some of it today but it’s more geared towards web stuff.

[Tim Greenwell]

Is it possible to insert a chart into a layout? Ideally the chart would be fully customizable, even if that requires drawing it with javascript.

Thanks for your advice!

[Andreas .]

Hi,

how is it possible to know the name of a field in the layout mode ?

In some layouts I prefer to delete the description field in some cases or I might loose the information field by dragging the fields around. In this cases I am not able to identify the fields anymore.

I would expect this information in the inspector sidebar.

best
Andreas

[Brendan]

Hi Eddy,

Thanks for the feature request.

You can trigger the Print screen from a Script.

Utils.printRecordsShowPanel(true);

But you can also select a layout first:

document.selectFormLayout(form_id, layout_id);

[Eddy]

Dear Folks!

I apologize in advance. I really searched but didn’t find anything in the forum.

Here is my problem:

In my tapforms-CRM I have a button, that generates an email to the customer when clicked. Indeed, I managed, that this generates a complete addressed email with subject and text. I have also a button for phone calls. (I love tapforms for this!)

Now I would like to have a button, that prints the invoice (from the invoice-layout) or saves it as a PDF.

Of course, I know: I could just go to the invoice-layout and then choose menue>print. But I’d rather have it as a button in the CRM-layout.

Really great would it be, if there could be a script, that could be used to generate an email containing the invoice PDF as an attachment.

Thanks in advance for thinking along.

Regards,

EDDY

[Sam Moffatt]

You can use scripting to build something like this today with the prompter and a saved search.

Create a new saved search with the criteria that you’re interested in and then you can use this to create a prompter with just the options and set the field from there. It’s not as transparent in the UI and does require executing a form script but it does give you some of the same functionality.

I’ve been trying to find a good example on the forum but don’t see one, I don’t think I have a video on it either. Might be something for the backlog.

[Daphne Tregear]

Bingo! All it took was a decent night’s sleep before I noticed that the id was staring me in the face on the Fields panel and that I could just cut and paste it into the script.

It barfed on TIF files for some reason but I can convert these.

Thank you for your patience and assistance.

[Daniel Leu]

Just set the field ‘Image name’ as a script and copy my code in there and adjust the photo_id according to your form.

Cheers, Daniel

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