Search Results for 'script'

[Sybille van Zuylen]

Hello,
I’m using tap forms to prepare coaching sessions.
I have a “session” table which is related to “activity” table.
Each session has several activities which are numbered in the order I want to do them.
From there, I am trying to prepare a “session summary” printout to give to the client where all activities and their descriptions are listed in the correct order.
So I made a new presentation (I’m sorry if the word is not right, I’m using the French translation).

My problem is I manage to display the “activity” table within the page, but its content is of course cropped in a way that makes it unusable.
How can I make a well designed text list of the activities related to my “session” record?

• This topic was modified 8 months, 1 week ago by Brendan.

[Daniel Leu]

There are a few issues with the ChatGPT proposal: one is that TapForms 5 doesn’t support calling AppleScripts. Utilities.executeAppleScript(script); is not supported. The API is documented in https://www.tapforms.com/help-mac/5.3/en/topic/javascript-api.

TapForms has an API to support adding events to the calendar: Utils.addToCalendar() and Utils.updateCalendarEvent(). So maybe the proposed code can be adapted to use these functions.

I don’t use the calendar integration with TapForms so I don’t know the details how it works. There’s an example in the API documentation.

Cheers, Daniel

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

[JScottA]

Using the custom GPT, Tap Forms 5 Assistant (unofficial), I got the following. Maybe it can assist you:

Response to Tech Support Post

1. Automating “Add to Calendar” for New Entries

Currently, Tap Forms requires users to manually press the “Add to Calendar” button for each entry in a date field. There is no built-in setting to automate this process for new records.

However, automation might be possible using scripting. Tap Forms supports JavaScript for automating tasks, and it may be possible to write a script that triggers the “Add to Calendar” function whenever a new record is created. You can refer to Tap Forms Scripting 101 for guidance on scripting in Tap Forms.

To apply this automation to existing records, a script could loop through all records and execute the “Add to Calendar” function in bulk.

2. Toolbar Calendar Icon Not Jumping to Current Month

From the Tap Forms manual (Section 7.3, Calendar View, p. 47-48), the calendar view allows navigation between months, but clicking on the calendar icon in the toolbar does not automatically jump to the month displayed in list mode. You must manually navigate the calendar using the arrows at the top.

3. Calendar Not Jumping to Selected Record in Sidebar

In the Calendar View, selecting a record from the list in the sidebar does not cause the main calendar view to jump to the corresponding month of that record. This behavior is currently by design.

A potential workaround could be:
• Clicking on a specific date within the calendar to filter records displayed.
• Using a Saved Search to focus on specific date ranges.

Summary & Suggested Fixes
• Automate “Add to Calendar”: Use JavaScript scripting.
• Toolbar Calendar Icon Behavior: No automatic jump to the current month.
• Calendar Sidebar Selection: Selecting a record in the sidebar doesn’t change the calendar view.

Would you like help drafting a script to automate adding records to your Apple Calendar?

and…

Here’s a Tap Forms JavaScript script that will automatically add records to your Apple Calendar when a new record is created. This script iterates through all records in a form and adds any missing entries to the Apple Calendar.

Steps to Use the Script:
1. Open Tap Forms.
2. Navigate to the Form where you want to automate the “Add to Calendar” function.
3. Open the Scripts Editor.
4. Create a new Script Field and paste the script below.
5. Run the script manually or set it up to execute automatically when new records are added.

Tap Forms Script to Add Entries to Apple Calendar

// Tap Forms script to automatically add all records with a date field to Apple Calendar

function addToCalendar() {
    var form = document.getForm(); // Get the current form
    var records = form.getRecords(); // Get all records
    var dateField = form.getFieldNamed("Your Date Field Name"); // Change to match your Date field name
    var titleField = form.getFieldNamed("Event Title"); // Change to match your title field
    var calendarScriptField = form.getFieldNamed("Added to Calendar"); // Optional: Track if event was added

    if (!dateField || !titleField) {
        alert("Please check that you have a valid Date and Title field.");
        return;
    }

    for (var i = 0; i < records.length; i++) {
        var record = records;
        var eventDate = record.getFieldValue(dateField);
        var eventTitle = record.getFieldValue(titleField);
        var addedToCalendar = record.getFieldValue(calendarScriptField); // Check if already added

        if (eventDate && eventTitle && !addedToCalendar) {
            var script = 

tell application “Calendar”
set newEvent to make new event at end of calendar “Your Calendar Name”
set start date of newEvent to date “${eventDate}”
set summary of newEvent to “${eventTitle}”
end tell
`;

// Execute AppleScript to add event to Calendar
var result = Utilities.executeAppleScript(script);

if (calendarScriptField) {
record.setFieldValue(calendarScriptField, “Added”);
}

console.log(“Added to Calendar:”, eventTitle, “on”, eventDate);
}
}
}

// Run the function
addToCalendar();

`

How It Works
• This script retrieves all records in a form.
• It checks for a date field and an event title field.
• If a record hasn’t already been added to the Apple Calendar, it:
• Runs an AppleScript command to create an event in Apple Calendar.
• Marks the record as “Added” (if you have a field for tracking).

Setup Instructions
1. Replace “Your Date Field Name” with the actual Date field name in your form.
2. Replace “Event Title” with the name of your event Title field.
3. Replace “Your Calendar Name” with the actual name of your calendar in Apple Calendar.
4. Optional: Create a new Text field named “Added to Calendar” in your form to track which records have already been added.

Execution & Automation
• Run this script manually to add existing records.
• If you want it to auto-run when a record is created, use a Trigger Script Field with Tap Forms.

Would you like assistance setting up an automatic trigger for new records? 🚀

If you want further assistance, you can use the assistant or wait for the Safe of TF to give you to canonical response.

[Dimitris Panagiotakopoulos]

It would be ideal to be able to attach a file in a file attachment field and be able to add a description and a date on it. I suppose one can name the file before attaching it, but it would be way better to be able to do it in the form.

[Brendan]

So you’re changing the value of your fld-631813d9eff54787894020691031bc77 field? That should trigger the script to run. Put in a console log to see if that solves the problem. Also don’t forget to call form.saveAllChanges() to commit the change to the database. That generally triggers a refresh of the display.

[Daniel Leu]

You could import your CSV data into a separate form using TapForms import function. Then you link the two forms together using the join relationship with the student identifier fields set to match values.

Now you can get all the information from the import in your main form. You could use a field script to extract some information to make it more legible.

Cheers, Daniel

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

[Courtney Craig]

Hey all,

I am by no means a coder, but I love Tap Forms and use it in the business I work for. I have a dilemma that I am hoping someone might be able to help with.

Context – we take school photos and have parents complete an authorisation form at the beginning of every year for what their student can order throughout the year.

I’m hoping to write a script that will take the CSV data I receive from the parents and merge it with the school provided student data, based on a unique identifier like a student number. Has anyone done something similar and be able to help?

The CSV contains a fair amount of data, parents can select what they want their son to order for several different photos, along with credit card information and shipping information.

Thanks,
Courtney

[Stuart Barry]

I have created a script that works to change the colour of the record conditionally. I initially created it as a form script and can run it or use a shortcut and it does what it is supposed to do. I tried the same script on a field because I want it to activate automatically as soon as a new record is added or an existing one changed. Although the script works when I run it manually on the field it does not automatically activate when the reference field is modified.

The first line of code (var type_id = record.getFieldValue (‘fld-631813d9eff54787894020691031bc77’);) references the field and gets the data successfully.

Any suggestions?

[Daniel Leu]

But is there a way to set the scripts to run automatically for each post?

Yes, you must use a field script instead of a form script. Create a new field of type script and assign the code you already have. This is why I recommended to use the return value instead of setting another field’s value. This makes it easier to understand what’s going on, specially if you have several scripts.

• This reply was modified 9 months, 1 week ago by Daniel Leu.
• This reply was modified 9 months, 1 week ago by Daniel Leu.

Cheers, Daniel

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

[Josef Tingbratt]

Thanks i did solve it oth help from ChatGPT, I just needed to point out the correct table to search in :)

But is there a way to set the scripts to run automatically for each post?

[Daniel Leu]

It seems that the script is a bit more complicated than it needs to be. You only have one customer per note, don’t you? The script assumes several. I would remove the save field functionality and just use the return value. Set the return type to text.

Just out of curiosity, I used ChatGPT to simplify your script and the result seems reasonable:

function calc() {
    // Fält-ID för det fält i relaterade tabellen som innehåller namn
    var namn_id = 'fld-e59a27d956a442f7b1995c71bffdde1e';

    // Fält-ID för fältet som länkar till relaterade poster
    var relaterade_falt_id = 'fld-1234567890abcdef1234567890abcdef';

    // Hämta relaterade poster
    var relateradePoster = record.getFieldValue(relaterade_falt_id);

    // Kontrollera om det finns exakt en relaterad post
    if (relateradePoster && relateradePoster.length > 0) {
        // Hämta namn från den relaterade posten
        var namn = relateradePoster[0].getFieldValue(namn_id);

        // Returnera namnet
        return namn;
    } else {
        // Om inga relaterade poster finns, returnera en tom sträng
        return '';
    }
}

I think you could achieve the same result by using a calculation field. Select the field of your related form and set the return value to text.

Cheers, Daniel

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

[Josef Tingbratt]

I have a basic CRM-setup. For my meeting notes I connect all of them to a customer (a related table). I would like to fetch the name from the related table (customer name) and put in to a text-field as a string. Been trying with CHatGPT with the following script but it doesn’t fill the text filed with the value:

function calc() {
// Fält-ID för det fält i relaterade tabellen som innehåller namn
var namn_id = ‘fld-e59a27d956a442f7b1995c71bffdde1e’;

// Fält-ID för fältet som länkar till relaterade poster
var relaterade_falt_id = ‘fld-1234567890abcdef1234567890abcdef’;

// Fält-ID för textfältet “Kundnamn”
var kundnamn_id = ‘fld-9b111db729f343629bdc9823c7af9810’;

// Hämta relaterade poster
var relateradePoster = record.getFieldValue(relaterade_falt_id);

// Kontrollera om det finns relaterade poster
if (relateradePoster && relateradePoster.length > 0) {
// Skapa en lista med namn från relaterade poster
var namnLista = relateradePoster.map(function(poster) {
return poster.getFieldValue(namn_id); // Hämta namn från varje relaterad post
});

// Kombinera namnen till en kommaseparerad lista
var sammanstalltNamn = namnLista.join(‘, ‘);

// Skriv värdet till fältet “Kundnamn”
record.setFieldValue(kundnamn_id, sammanstalltNamn);

} else {
// Om inga relaterade poster finns, töm fältet “Kundnamn”
record.setFieldValue(kundnamn_id, ”);
}

// Returnera ingenting (fokus är på att skriva till textfältet)
return ”;
}

[JScottA]

The following response to your post is from Tap Forms 5 Assistant (an unofficial custom GPT). Use with caution. Maybe it can assist until Brendan is able to get to you. Here is the response:

The issue you’re experiencing with addFileFromUrlToField crashing Tap Forms might be related to one of these factors:
1. Field Configuration: Ensure the file attachment field (file_attachment_id) is correctly set up as a “File Attachment” field and that the “Multi-File Enabled” option is properly configured. The field must support attaching files. You can verify this by checking the properties of the field in the Tap Forms application under Field settings.
2. URL Accessibility: Ensure the PDF URL is accessible and not blocked by any permissions or firewalls. Test the URL in a browser to confirm that it downloads correctly.
3. Scripting API Limitation: According to the documentation, there could be platform-specific limitations or bugs in the JavaScript API for Tap Forms, especially on iPadOS. If addFileFromUrlToField works on other platforms but not on iPadOS, this indicates a bug that should be reported to Tap Forms support.
4. Error Handling in Script: Add error handling to your script to catch any issues during execution. For example:

function Test_Pdf() {
    try {
        // Field ID
        var file_attachment_id = 'fld-858558a7165649e6ac3bd117e17483ec';
        // File URL
        var url = "https://cdn.manula.com/user/1444/1328_16794_en_1538683502.pdf?v=20240123105634";
        // Add new record
        var newRecord = form.addNewRecord();
        // Add file to field
        newRecord.addFileFromUrlToField(url, file_attachment_id);
        document.saveAllChanges();
    } catch (e) {
        console.log("Error: " + e.message);
    }
}

Test_Pdf();

5. File Size or Compatibility: Large files or unsupported file formats could also cause crashes. Test with smaller PDFs or other supported formats to identify if file size or type is contributing to the issue.
6. Bug Report: If none of the above resolves the issue, it might be a bug in the Tap Forms app. You should report this to Tap Forms support, providing details about the script, iPadOS version, and steps to reproduce the issue.

For additional scripting resources, refer to the Tap Forms Scripting 101 guide, which might offer more insight into debugging and advanced script usage in Tap Forms.

[Daniel Leu]

When you run the script in the editor, what is the console output? Do you get anything?

Attached is my test form showing that my script works.

Attachments:

You must be logged in to view attached files.

Cheers, Daniel

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

[Calion]

How do I get the field ID?

// Okay, I found the answer to that, but nothing is showing up in the script field.

Here’s the script:

function Table_Text() {

	// set field value according to your form
	const table_id = 'fld-26a15768a8f54cc5b8cc3cec0cd7d295';

	// get table records
	let tableRecs = record.getFieldValue(table_id);
	
	// extract all table values
	let tableValues = [];
	tableRecs.forEach( (a) => {tableValues.push(a.values)});
	
	//console.log("Raw data:\n"+JSON.stringify(tableValues,"",4));
	
	// extract all table values
	let tableText = [];
	for (tableValue of tableValues){
		let row = [];
		for (const [key, value] of Object.entries(tableValue)) {
			row.push(value);
		}
		tableText.push(row.reverse().join(", "));
	}
	
	//console.log("Extracted data:\n"+tableText.join("\n"));
	return tableText.join("\n");	
}

Table_Text();

I set the Result Type to text, but that didn’t change anything.

• This reply was modified 9 months, 2 weeks ago by Calion.