Search Results for 'script'

[Daniel Leu]

1.) Is there a way to find the selected cell in a column from a table field? (image attached)

AFAIK, the select state of a cell or row is not exposed.

2.) Can I call a File open window to select a file on my hard drive to get a UNIX file path?

To open Finder, you can use Utils.openUrl("file:///Users/josef/Desktop");. For this to work, you need to set the script access folder.

To get the file path, control-click, middle mouse button, or two-finger click on the file to get the context menu, press the option key and select Copy “xxx” as Pathname.

Then you can write a script that gets the copied Pathname from the clipboard using Utils.copyTextFromClipboard() and proceed with processing it. To trigger the script, you can use a checkmark field like you launch the play in VLC script.

You can automate this further: Create an AppleScript that is selected from the Quick Actions context menu. This script would get the file path and then call a TapForms script using tapformz://script/db-xxxx/frm-xxxx/Test+Script?option1=A&option2=B. Most likely you would have to provide the id of the record and the id of the table row record as parameters. This script would then store the file path in your table.

Sounds like a fun project!

Cheers, Daniel

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

[Josef Senti]

Hello

1.) Is there a way to find the selected cell in a column from a table field? (image attached)
2.) Can I cal a File open window to select a file on my hard drive to get a UNIX file path?

I’d like to write a script that can write the path of a file in a selected table cell.
Or by input window, but ideally with a window that let me select the file on the hard drive.

For example:

Open file search window
Get the UNIX path of that file
Add “file://” in front of that path
Look for the selected cell in the column
Write the path in that cel

Attachments:

You must be logged in to view attached files.

[Daniel Leu]

You’re using a custom layout. So you can add a button that will launch a form script.

What you do is get the field value of your table field. This is an array of records. Each record represents a row in your table. Then you just loop over it and clear the checkmark field.

Here’s the form script. You just have to set the ID of the aforementioned fields

function Clear_Checkmarks() {
	const table_id = 'fld-xxx'; // id of your DVD Verwaltung table
	const table__check_mark_id = 'fld-xxx'; // id of your Gesehen field

	let tableRecords = record.getFieldValue(table_id);
	
	tableRecords.forEach((a) => {a.setFieldValue(table__check_mark_id,0)});
	document.saveAllChanges();
}

Clear_Checkmarks();

;

• This reply was modified 1 year, 2 months ago by Daniel Leu.

Cheers, Daniel

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

[Josef Senti]

I have a lot of rows in a table field. One of the columns is a checkmark field to take record if I have seen this episode. (image in the attachment)

Now I try to write a script that sets all the checkmarks to false in this table for this series.

I found out how I can change a checkmark field alone, but not when it’s in a table.

Can someone pleas help me.

Ideally I’d like to press a shortcut and all the checkmark fields in this table get set to false.

Attachments:

You must be logged in to view attached files.

[Daniel Leu]

Based on something I already have and use, I propose following:

I’m using a checkmark field to trigger the opening action of a PDF file. You can use the same code to trigger opening your video.

Add two fields to your table, the checkmark field called Open and a script field (use a meaningful name). For usability, place the Open field in the first column. You can hide the script field.

Here is the script code. You have to update the open_id and link_id constants to contain the IDs of the Open field and the Pfad field.

function Attachment_Open() {

	const open_id = 'fld-xxx'; // id of the newly created checkmark field
	const link_id = 'fld-xxx'; // id of your Pfad field

	let open = record.getFieldValue(open_id);
	let link = record.getFieldValue(link_id);
	
	if (link && open){
		console.log("Opening URL " + link);
		
		link = "file://" + link.replace(/[ ]/g, '\ ')
		console.log("Opening URL " + link);

		Utils.openUrl(link);

		// clear opening flag
		record.setFieldValue(open_id, false)
		form.saveAllChanges()
	}
}

Attachment_Open();

Now, when you click on the Open checkmark, VLC should open your video.

In case it doesn’t work, please open the console and then click on the Open checkmark of one of your videos. Then report the console output.

Good luck!

Cheers, Daniel

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

[Josef Senti]

Thank you!!

I have all the series in a table, like in the image attached. Where do I put the script and haw can I call the path in that script from the selected row?

Sorry, I’m all new to this ;)

Attachments:

You must be logged in to view attached files.

[Daniel Leu]

Using a script:
You can use Utils.openUrl(url); to open an external file. Use following scheme to set an url to point to a file on your disk: url="file:///Users/daniel/Desktop/song.mp4".

This will open the file in the predefined handler for that file type. This script can be assigned to a button when using

Using a website field:
You can assign the path using the url format shown above. When clicking on the globe, the file will be opened in the handler for that file type.

So for both cases, you must make certain that the VLC Player is the default player for your iso and mp4 files. If this is not practical, it might be possible to use the VLC url scheme: url="vlc-x-callback://x-callback-url/stream?url=file:///Users/daniel/Desktop/song.mp4"

Cheers, Daniel

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

[Josef Senti]

Is there a way to run a file from a path in a field using script?

I try to make a movie database. In a table I have a field with the path to the MP4 or ISO file.
Is there a way to write a script that can make that file run with VLC Player when I press a shortcut or a button or whatever is possible?

[Stuart Barry]

I already had the save command and console log. The type-id field is picked up correctly by the colour only changes when I run the script manually. I’d like it to run automatically on changing the colour field using the drop down box. Script shown below.

function Change_record_colour() {

var type_id = record.getFieldValue (‘fld-631813d9eff54787894020691031bc77’);
var red_col = “#ffbac6”;
var white_col = “#caffd4”;
var sweet_col = “#fef3a4”;
var fort_col = “#fdbb9c”;
var spark_col = “#a3ff79”;
var rose_col = “#f4d8dd”;

console.log(type_id);

if (type_id == “Red”)
{record.setRecordColor(red_col);}

if (type_id == “White”)
{record.setRecordColor(white_col);}

if (type_id == “Sparkling”)
{record.setRecordColor(spark_col);}

if (type_id == “Sweet”)
{record.setRecordColor(sweet_col);}

if (type_id == “Fortified”)
{record.setRecordColor(fort_col);}

if (type_id == “Rosé”)
{record.setRecordColor(rose_col);}

form.saveAllChanges();

}

Change_record_colour();

[Daniel Leu]

I don’t know how long your objective description is, but maybe you can use markdown to format it.

Here’s a field script that fetches all the activities records and formats them as markdown.

You need to update field ids for the activity form and the respective fields. Additionally, define a summary field in your main form of type markdown.

When you update an activity record, the summary field is updated. The first line is the number and title, followed by the objective. Unfortunately, TapForm 5’s markdown implementation doesn’t support tables.

Hope this helps! Bonne chance!

function Update_Summary() {

	// define the field ids
	const activities_id = 'fld-xxx';
	const activities__number_id = 'fld-xxx';
	const activities__title_id = 'fld-xxx';
	const activities__objective_id = 'fld-xxx';
	const summary_id = 'fld-xxx';

	// get activities records
	let activities = record.getFieldValue(activities_id);
	
	let md = "# Activities\n\n";
		
	// loop over all activities and create the markdown entries
	for (activity of activities){
		let number = activity.getFieldValue(activities__number_id);
		let title = activity.getFieldValue(activities__title_id);
		let objective = activity.getFieldValue(activities__objective_id);
		
		md += `**${number}: ${title}**   
${objective}    
`;
	}
		
	// update markdown field
	record.setFieldValue(summary_id, md);
	document.saveAllChanges();
}

Update_Summary();

Cheers, Daniel

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

[Brendan]

Hi Sybille,

On your custom layout, you can adjust the widths of the columns on your Link to Form field to make the related table look a bit nicer. You may also want to print in landscape orientation so you can get more space on the page for your columns.

What does it currently look like? Can you post a screenshot?

Thanks,

Brendan

P.S. I’m moving this topic out of the Scripting Talk forum because it doesn’t have anything to do with scripting as far as I can tell.

[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 1 year, 2 months 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.