Search Results for 'script'

[Victor Warner]

I have the following script which writes data from a .csv file to several fields. It does so by adding a new record and then writing the data to the fields. I would like to know how to do so to the currently selected record.

Any help would be gratefully received.

// this imports the Papa Parse script

form.runScriptNamed('PapaParse');

// replace with your field ID's

var date_of_invoice_id = 'fld-1b800a91fac14b329ef47d23c7cdacb0';
var date_paid_id = 'fld-60fa17dec2a24d9588ce4aafa3dccd5c';
var date_of_receipt_id = 'fld-9ed8f17873a642b4a2ee58ff24eba421';
var method_of_payment_id = 'fld-15b719109ab64053a5c46427622f81f5';
var payment_notes_id = 'fld-3a22501b3096443f8f92c6cf6c7e2de5';

function Import_Entries() {
//let filename = "file:///Users/victor/vwdata/data/Notary/client database/not in use/FileMaker/notary/vPaymentDetails.csv";
let filename = "file:///Users/victor/Library/Mobile Documents/com~apple~CloudDocs/filedtoday/vPaymentDetails.csv";

 

let csvFile = Utils.getTextFromUrl(filename);

if (!csvFile) {
console.log("No CSV file?");
return
}

var output = Papa.parse(csvFile);

// abort if there are any errors and log to console.
if (output.errors.length > 0) {
console.log(errors.join("\n"));
return;
}

// read each line
for (let line of output.data) {
var newRecord = form.addNewRecord();
newRecord.setFieldValues({
[date_of_invoice_id]: line[0],
[date_paid_id]: line[1],
[date_of_receipt_id]: line[2],
[method_of_payment_id]: line[3],
[payment_notes_id]: line[4],
});
//var job_completed_id = 'fld-ba0622aac1ea42ff9e5e9272c4314fa7';

//record.setFieldValue(job_completed_id,"Yes");

document.saveAllChanges();
}
}

// Import entries to form "Who" from filename "Whom.csv"
Import_Entries("Notarial Act", "vPaymentDetails.csv");

• This topic was modified 2 years ago by Victor Warner.

[FrAnksch]

I was looking for a way, to collect all linked records of a 1:n related child form within one note filed of the parent form, in order to use these information for further purposes.

Since I am NOT familiar with software development and an absolutely newbie to scripting, I was searching the TF forums, and with the help of the Child Records Loop  snippet and some tips and examples Brendan published here in the forum, I built a template for “Collecting Child Records in the Parent form”, that works as I expected (I am on iOS, but the template should work on mac as well).

I’m quite sure there are many other “non-software-development” users with minor scripting skills, so I prepared the templates with “speaking” names in the hope that it is understandable even for newbies.

Sorry programmers, this is a beginners guide ;-)

There are 2 forms:

– ParentForm (PF)

– ChildForm (CF)

Within the CF there are 4 different records (children), each with several properties. In one additional field “AllProperties” I put all properties for each child together (calculation field, separate field values are connected via “concat” formula).

The PF is linked with the CF via “1:n relation”. Within this PF there are 2 records (Parent1 and Parent2). Via the field “children” (relation field to child form), each Parent is linked with 2 children.

You can select the children with the “selection checkbox”.

Then there is a calculation field “children count” which shows automatically the number of selected children for each Parent.

Additionally there is a note field “CollectionOfChildren”, which automatically shows the information for the “AllProperties” field for all linked children, one line for each child. Since this is one field with one text (consisting of all properties of all linked children), the text is very clear at a glance and is e.g. printed very nice or could be used for further purposes.

The information for this target “note field” is generated in a script field “ScriptCollectChildren”, which is hidden and thus not visible in the form (only when you edit the form).

The script code is listed below, you do NOT have to adapt the code anyhow, just replace the three (red) fieldIDs (fld-4e07f10f46………) in the upper part of the code.

You can use this forms and adapt it according to your needs, or you can implement such fields to your already existing forms, copy the script code, paste it into your script fiel and replace the field IDs with yours.

I hope this template (and/or the script) helps some of you, at least if you are a “rookie” like I am.

ScriptCode (@programmers: sorry for bad indentation, this was written in TF iOS app)

function CollectChildren() {

var parentform_Children_id = ‘fld-4e07f10f46c84c0c99c5ca723ee42ad5’;//table of sourcedata (1:n LinkField to ChildForm)

var parentform_Children = record.getFieldValue(parentform_Children_id); //datasets of sourcedata

var childform_RequiredProperty_id = ‘fld-570a6131139842288f18683e91833f6c’;//field of interest of sourcedata

var parentform_CollectionOfChildren_id = ‘fld-557c63ce9156491e8f8891b00c0def5b’; //tagetfield for collected data from field of interest

var temp_CurrentChild = []; //array for collecting data

//running through all datasets & collecting data into temp. array

for (var index = 0, count = parentform_Children.length; index < count; index++){

      var childform_RequiredProperty = parentform_Children[index].getFieldValue(childform_RequiredProperty_id);

if (childform_RequiredProperty) {

temp_CurrentChild.push(childform_RequiredProperty);

}

}

//joining collected data from temp. array into temp. variable

var temp_ChildrenList = temp_CurrentChild.join(“,\r”);

//writing joined collection from temp. variable into target field

record.setFieldValue(parentform_CollectionOfChildren_id, temp_ChildrenList);

return temp_ChildrenList;

form.saveAllChanges();

}

CollectChildren();

• This topic was modified 2 years ago by FrAnksch. Reason: format optimization
• This topic was modified 2 years ago by Brendan. Reason: tagged code as code
• This topic was modified 2 years ago by Brendan. Reason: tagged code as code
• This topic was modified 2 years ago by Brendan.
• This topic was modified 2 years ago by Brendan.

Attachments:

You must be logged in to view attached files.

[Shannon Miles]

Hello. I thought I’d share the movie library template I created to keep track of both my physical media (DVD, Blu-ray, etc.) and digital library. It’s essentially a main form with the basic movie information with two linked forms, one for physical media and one for digital.  There is also a script to fill in the basic information using the TMDB Number/ID. I cobbled it together from these two topics: https://www.tapforms.com/forums/topic/watched-tv-shows/ and https://www.tapforms.com/forums/topic/get-movie-details-from-themoviedb-api-help-needed/. I know not this odd thing called JavaScript, but am a copy and paste demon, so thanks to everyone who contributed to this code. There are instructions in the script for use.

P.S. Programmers beware, I don’t know the indent rules, so it may cause an eye twitch.

Attachments:

You must be logged in to view attached files.

[Giovanni Vittoria]

Thank you Daniel!

I checked this and you”re absolutely right:

the script IS working, but the updated results are not displayed correctly on my iPhone. The temporarily arranged return value appears in the script field.

The date fields are displayed correctly as soon as I go back to the entry list and back to a single entry, even without manual refresh (I am on iPhone).
On my iPad (with list view on the lefthand side) it is clearly visible, that the date fields are updated as soon the checkbox is changed.
So everything is Ok for me.
Thanks for opening my eyes! ;-)

• This reply was modified 2 years ago by Giovanni Vittoria.

cheers, Giovanni

[Daniel Leu]

I do think that the script runs as you expect it to run, but the issue is related to displaying the updated results. You could check that the script runs by adding a return value or putting something in the console.

I’ve seen this before that TapForms doesn’t display updated fields. Unfortunately, the only solution is the one you’re using :-(

Cheers, Daniel

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

[Giovanni Vittoria]

Hi,

first if all: I’m a absolute rookie in terms of scripting, so SORRY for the bad code & for my stupid questions. But I’m willing to learn ;-)

I have 2 date fields and want them to show the date when a boolean field (checkbox) was checked or unchecked.
Within the form I use a script-field with the script below.

The code  is not nice, but it works in general. But only if the entry is manually refreshed (iOS: pull down).

Other tests with website-field (according to https://www.tapforms.com/forums/topic/pre-processing-field-entry/) work automatically when the entry is stored.
I would like to have my script running as soon as the checkbox is checked or unchecked.

Could  anybody please optimize my code or help me to get this work?

Thanks!

function Checkdate() {

var check_field_id = “fld-abc”;
var date_field1_id = “fld-xyz”;
var date_field2_id = “fld-zyx”;

var check_value = record.getFieldValue(check_field_id);
var date1_value = record.getFieldValue(date_field1_id);
var date2_value = record.getFieldValue(date_field2_id);

if (check_value == 1)
{
if (date1_value == null)
{
record.setFieldValue(date_field1_id, new Date());
record.setFieldValue(date_field2_id, null);
}
}
else
{
if (date2_value == null)
{
record.setFieldValue(date_field2_id, new Date());
record.setFieldValue(date_field1_id, null);
}
}
form.saveAllChanges();

}

Checkdate();

cheers, Giovanni

[Daniel Leu]

Default values are working, but the default parameter is the 5th one:

var value_1;
var value_2;

function script() {

var callbackFunction = function() {
console.log(value_1);
console.log(value_2);
};


let prompter = Prompter.new();
prompter.addParameter('Label 1', 'value_1', '','','Default Value')
.addParameter('Label 2', 'value_2', 'popup', ['Option 1', 'Option 2'], 'Option 1')
.show('Message prompt', callbackFunction);

};

script();

Cheers, Daniel

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

[Fernando DS]

<p style=”text-align: left;”>I send another script later and I think it’s more complete.

</p>
var fecha_pago_o_cobro_id = ‘fld-3671b67b092b4b3b949984292c023511’;
var pagos_y_acumulado_id = ‘fld-a1ee93e141f34774be95df31d316be12’;
var importes_y_acumulado_id = ‘fld-d72e37e939fe476e820ff4f3c4ef12c7’;
var fecha_proximo_pago_o_cobro_id = ‘fld-51be737772e840d2b4d365bd1f5230cd’;
var saldo_proximo_pago_o_cobro_id = ‘fld-a554770fd7834b22802b65c488be9f0d’;

var fechaActual = new Date();
var registros = form.getRecords();

registros.forEach(function (registro) {
var calculos = registro.getFieldValue(‘fld-d8a58dbf35914f3c858c6dfb880c1c48’) || [];

if (calculos.length > 0) {
var ultimoCalculo = calculos[calculos.length – 1];
var fechaPagoCobro = new Date(ultimoCalculo[fecha_pago_o_cobro_id]);
var importe = ultimoCalculo[importes_y_acumulado_id];

if (fechaPagoCobro < fechaActual) {
// Cumplimentar el campo Pagos con el valor del campo Importes para saldar el pago o cobro
ultimoCalculo[pagos_y_acumulado_id] = importe;

// Determinar la nueva fecha de pago o cobro
var periodicidadTexto = registro.getFieldValue(‘fld-aaba9a24064a4a8893a3963f7cbe8595’);
var nuevaFechaProximoPagoCobro = new Date(fechaPagoCobro);
switch (periodicidadTexto) {
case ‘Mensual’:
nuevaFechaProximoPagoCobro.setMonth(nuevaFechaProximoPagoCobro.getMonth() + 1);
break;
case ‘Bimensual’:
nuevaFechaProximoPagoCobro.setMonth(nuevaFechaProximoPagoCobro.getMonth() + 2);
break;
case ‘Trimestral’:
nuevaFechaProximoPagoCobro.setMonth(nuevaFechaProximoPagoCobro.getMonth() + 3);
break;
case ‘Semestral’:
nuevaFechaProximoPagoCobro.setMonth(nuevaFechaProximoPagoCobro.getMonth() + 6);
break;
case ‘Anual’:
nuevaFechaProximoPagoCobro.setFullYear(nuevaFechaProximoPagoCobro.getFullYear() + 1);
break;
// Añadir más casos de periodicidad si es necesario
default:
console.error(‘Periodicidad no reconocida: ‘ + periodicidadTexto);
break;
}

// Crear una nueva línea con la nueva fecha de pago o cobro y el mismo importe
var nuevoCalculo = {
‘fecha_pago_o_cobro_id’: nuevaFechaProximoPagoCobro,
‘importes_y_acumulado_id’: importe,
‘pagos_y_acumulado_id’: ”
};
calculos.push(nuevoCalculo);

// Actualizar los campos fuera de la tabla ‘Cálculos’
registro.setFieldValue(fecha_proximo_pago_o_cobro_id, nuevaFechaProximoPagoCobro);
// No es necesario actualizar ‘Saldo/próximo pago o cobro’ si es un campo calculado automáticamente

// Guardar los cambios en el registro actual
registro.setFieldValue(‘fld-d8a58dbf35914f3c858c6dfb880c1c48’, calculos);
}
}
});

form.saveAllChanges();

[Fernando DS]

• Hi everybody,

  I have an income and expense form and I want to automate it as much as possible. To do this, and with the invaluable help of my friend ChatGPT, I have made the script that I am sending you. What I want is for the last pending payments or collections to be credited when the script is executed, if the current date is later than the date of said payments or collections. The payment records are in a table-type field called “Calculations”, which includes the fields: – “Payment or collection date”, date type field, is the expected date for payment or collection. – “Amounts and accumulated”, numerical field, is the amount to be paid or collected. – “Payments and accruals”, numerical field, is filled in with the value of the Amounts field when the Payment Date arrives. What the script intends is that when the Payment or Collection Date is before the current date, the script will be executed and the following actions will occur: In the line of the last pending payment, the Payments field will be filled with the value of the Amounts field, so that payment or collection will be skipped. At the same time, a new line will be created with the new Payment or Collection Date and the new Amount, which is always the same, and therefore will copy the one imported from the previous movement. Regarding the new date, the script will take into account the “Periodicity” field, a text field that marks the type of period that passes between one movement and the next, monthly, annual, etc., and which is also outside the Calculations table. And with this the next pending payment or collection will be fulfilled. 2 more fields will also be fulfilled, which are outside the Calculations table: – Next payment or collection date, date type field, which will copy the date of the last pending payment or collection that has been created. – Balance/next payment or collection, field calculated with a formula, which is the balance between the totals of the Amounts and the Payments. Here the new balance will be incorporated, which will be equal to the previous one. And that would be it. I want to clarify that I also have records with different imports, but I find it very difficult to measure these in a script. Each record in the form is a different payment or collection and are independent of each other. Without prejudice to the fact that the amounts are added to obtain totals and balances.
  Obviously the script does not work. It has no errors in the console, but not working.

• Anyway, I hope I have explained myself. Although I will clarify any doubts. And this is the script

 

var fechaActual = new Date();
var registros = form.getRecords();

registros.forEach(function (registro) {
var calculos = registro.getFieldValue(‘fld-d8a58dbf35914f3c858c6dfb880c1c48’) || [];
var fechaProximoPagoCobro = registro.getFieldValue(‘fld-3671b67b092b4b3b949984292c023511’);
var saldoProximoPagoCobro = registro.getFieldValue(‘fld-a554770fd7834b22802b65c488be9f0d’);
var periodicidadTexto = registro.getFieldValue(‘fld-aaba9a24064a4a8893a3963f7cbe8595’);
if (calculos.length > 0 && fechaProximoPagoCobro && saldoProximoPagoCobro && periodicidadTexto) {
var fechaUltimoCalculo = new Date(calculos[calculos.length – 1].fecha_pago_o_cobro_id);

// Si la última fecha de pago es anterior a la fecha actual
if (fechaUltimoCalculo < fechaActual) {
var nuevaFecha = new Date(fechaUltimoCalculo);
var meses = { ‘Mensual’: 1, ‘Bimensual’: 2, ‘Trimestral’: 3, ‘Semestral’: 6, ‘Anual’: 12 };
var dias = { ‘7 días’: 7 };

// Añadir tiempo a la fecha según la periodicidad
if (meses[periodicidadTexto]) {
nuevaFecha.setMonth(nuevaFecha.getMonth() + meses[periodicidadTexto]);
} else if (dias[periodicidadTexto]) {
nuevaFecha.setDate(nuevaFecha.getDate() + dias[periodicidadTexto]);
}

// Si la nueva fecha es en el futuro, añadimos una nueva entrada
if (nuevaFecha > fechaActual) {
var ultimoImporte = calculos[calculos.length – 1].importes_y_acumulado_id;
calculos.push({
fecha_pago_o_cobro_id: nuevaFecha,
importes_y_acumulado_id: ultimoImporte,
pagos_y_acumulado_id: ”
});
}

// Actualizamos el campo ‘Pagos y acumulado’ del último cálculo
calculos[calculos.length – 1].pagos_y_acumulado_id = saldoProximoPagoCobro;

// Guardamos los cambios en el registro
registro.setFieldValue(‘fld-d8a58dbf35914f3c858c6dfb880c1c48’, calculos);

form.saveRecord(registro);
}
}
});

 

Thank you in advance for your kind help.

[Fernando DS]

• I have an income and expense form and I want to automate it as much as possible. To do this, and with the invaluable help of my friend ChatGPT, I have made the script that I am sending you. What I want is for the last pending payments or collections to be credited when the script is executed, if the current date is later than the date of said payments or collections. The payment records are in a table-type field called “Calculations”, which includes the fields: – “Payment or collection date”, date type field, is the expected date for payment or collection. – “Amounts and accumulated”, numerical field, is the amount to be paid or collected. – “Payments and accumulated”, numerical field, is filled in with the value of the Amounts field when the Payment Date arrives. What the script intends is that when the Payment or Collection Date is before the current date, the script is executed and the following actions occur: In the line of the last pending payment, the Payments field will be filled in with the value of the Amounts field, so that payment or collection will be settled. At the same time, a new line will be created with the new Payment or Collection Date and the new Amount, which is always the same, and therefore will copy the amount of the previous movement. Regarding the new date, the script will take into account the “Periodicity” field, a text field that marks the type of period that passes between one movement and the next, monthly, annual, etc., and which is also outside the Calculations table. And with this the next pending payment or collection will be completed. Two more fields will also be completed, which are outside the Calculations table: – Next payment or collection date, date type field, which will copy the date of the last pending payment or collection that has been created. – Balance/next payment or collection, field calculated with a formula, which is the balance between the totals of the Amounts and the Payments. Here the new balance will be incorporated, which will be equal to the previous one. And that would be it. I want to clarify that I also have records with different amounts, but I find it very difficult to put these in a script. Each record in the form is a different payment or collection and are independent of each other. Without prejudice to the fact that the amounts are added to obtain totals and balances. Anyway, I hope I have explained myself. Although I will clarify any doubts. And this is the script

 

var fechaActual = new Date();
var registros = form.getRecords();

registros.forEach(function (registro) {
var calculos = registro.getFieldValue(‘fld-d8a58dbf35914f3c858c6dfb880c1c48’) || [];
var fechaProximoPagoCobro = registro.getFieldValue(‘fld-3671b67b092b4b3b949984292c023511’);
var saldoProximoPagoCobro = registro.getFieldValue(‘fld-a554770fd7834b22802b65c488be9f0d’);
var periodicidadTexto = registro.getFieldValue(‘fld-aaba9a24064a4a8893a3963f7cbe8595’);
if (calculos.length > 0 && fechaProximoPagoCobro && saldoProximoPagoCobro && periodicidadTexto) {
var fechaUltimoCalculo = new Date(calculos[calculos.length – 1].fecha_pago_o_cobro_id);

// Si la última fecha de pago es anterior a la fecha actual
if (fechaUltimoCalculo < fechaActual) {
var nuevaFecha = new Date(fechaUltimoCalculo);
var meses = { ‘Mensual’: 1, ‘Bimensual’: 2, ‘Trimestral’: 3, ‘Semestral’: 6, ‘Anual’: 12 };
var dias = { ‘7 días’: 7 };

// Añadir tiempo a la fecha según la periodicidad
if (meses[periodicidadTexto]) {
nuevaFecha.setMonth(nuevaFecha.getMonth() + meses[periodicidadTexto]);
} else if (dias[periodicidadTexto]) {
nuevaFecha.setDate(nuevaFecha.getDate() + dias[periodicidadTexto]);
}

// Si la nueva fecha es en el futuro, añadimos una nueva entrada
if (nuevaFecha > fechaActual) {
var ultimoImporte = calculos[calculos.length – 1].importes_y_acumulado_id;
calculos.push({
fecha_pago_o_cobro_id: nuevaFecha,
importes_y_acumulado_id: ultimoImporte,
pagos_y_acumulado_id: ”
});
}

// Actualizamos el campo ‘Pagos y acumulado’ del último cálculo
calculos[calculos.length – 1].pagos_y_acumulado_id = saldoProximoPagoCobro;

// Guardamos los cambios en el registro
registro.setFieldValue(‘fld-d8a58dbf35914f3c858c6dfb880c1c48’, calculos);

form.saveRecord(registro);
}
}
});

[Fernando DS]

Of course the script does not work. It has no errors in the console, but not working.

[Simon Spiers]

Thanks Daniel. That makes sense and it now works!

Sam didn’t provide the script, I saw some of it in his video. It seems complex and suited to his own particular use. I’m hoping he’ll weigh in here.

[Glen Forister]

I made an archive of this Form before I started fixing all the problems so I can show them to you. So far I have identified 2 records that when you look at the archive you should be able to see the behavior working.

Select Advanced Search = Finished=N
I think you will find the above mentioned behavior discussed previously on the following records.

Coleoptera, Aderidae, aderus
Coleoptera, Bruchidae
Coleoptera, Curculionidae, Anthonomus
Coleoptera, Melandryidae, Abdera
Coleoptera, Phlacridae, 1
Coleoptera, Scirtidae, Deleted

Please let me know what you find.  I can’t guarantee the behavior will be seen on all records.

I wish I could verify this archive, but I can’t do that without replacing the data in my Form.  Maybe I could do that in another Document I think, but not sure.  I stay away from other documents and keep everything in the same document.

That is one thing I would wish for is a way to copy a form with the data in it and the settings like an archive and create another Form with the archive which has all the work done including the scripts, searches, formatting, etc., just with another name but in the same document.  I often want to create a new document similar to one I’m already using, but don’t want to take the hours or days to do all the work and get it running again like the old one but with a slightly new purpose.

[Daniel Leu]

I was on the correct track that there’s a type issue. The match() method returns an array. So you can just grab the first element or you might want to additionally check that there’s only one element (found.length ==1):

record.setFieldValue(mc_id, found[0]);

Do you have the link to Sam’s parser script? Thanks!

• This reply was modified 2 years, 1 month ago by Daniel Leu.

Cheers, Daniel

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

[Daniel Leu]

Maybe it’s a type issue. Usually Javascript is not very type agnostic. Is MC defined as a number? Does a text field work instead?

Cheers, Daniel

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