Search Results for 'script'
-
Search Results
-
I’ve a solution that’s a work-in-progress, but in essence I created a dummy field I was happy to sacrifice in TapForms, checked it was created in CouchDb as a Table, and then ran this AppleScript
— Define CouchDB URL and credentials
set couchdbURL to “http://192.168.1.240:5984/db-1a619b6d486c466c9fc32a1b4a494f00” — Replace with your CouchDB database URL
set couchdbUser to “admin” — Replace with your CouchDB username
set couchdbPassword to “your password” — Replace with your CouchDB password
— Define the document ID and the field to be updated
set documentID to “fld-0f69d93fa3bd48c99df27375911e2040” — Replace with your field ID
set fieldName to “name” — The field name to update
set fieldValue to “Test” — The new value for the field
— Step 1: Fetch the current document to get the _rev value
set fetchURL to couchdbURL & “/” & documentID
set fetchCommand to “curl -u ” & couchdbUser & “:” & couchdbPassword & ” ” & fetchURL
— Debug: Display fetch command
— display dialog “Fetch Command: ” & fetchCommand
set documentJSON to do shell script fetchCommand
— Debug: Display raw JSON response
— display dialog “Document JSON: ” & documentJSON
— Extract the _rev value from the document JSON using JSON parsing
— Use AppleScript’s
do shell scriptto execute a Python command for JSON parsing— Extract the _rev value using Python for robust JSON parsing
set pythonCommand to “python3 -c ‘import json, sys; doc = json.load(sys.stdin); print(doc[\”_rev\”])'”
set revResult to do shell script “echo ” & quoted form of documentJSON & ” | ” & pythonCommand
— Debug: Display extracted _rev value
— display dialog “Document Revision (_rev): ” & revResult
— Step 2: Create the JSON payload for the update
set jsonPayload to “{\”_id\”:\”” & documentID & “\”, \”_rev\”:\”” & revResult & “\”, \”” & fieldName & “\”:\”” & fieldValue & “\”}”
— Debug: Display JSON payload
— display dialog “JSON Payload: ” & jsonPayload
— URL to update the document
set updateURL to couchdbURL & “/” & documentID
— Create the shell command for the curl request
set curlCommand to “curl -X PUT -u ” & couchdbUser & “:” & couchdbPassword & ” -H ‘Content-Type: application/json’ -d ‘” & jsonPayload & “‘ ” & updateURL
— Debug: Display update command
— display dialog “Update Command: ” & curlCommand
— Run the shell command
set updateResponse to do shell script curlCommand
— Debug: Display update response
— display dialog “Update Response: ” & updateResponse
— Optional: Notify completion
display notification “CouchDB document update request sent” with title “CouchDB Update”
this works, i.e. when run it forces TapForms to update. The one issue I have is that I’ve killed that field so it’s no longer visible at all in TapForms, but is in CouchDb, I think because I didn’t PUT the whole Fields values back, but only the new name (test), but I think it’s a solution, all be it dirtly, and I could then at least creat triggers/schedules for my AppleScript outside of TapForms as/when needed.
I can see from previous posts there isn’t an on-form-load trigger event in which I could attach a script to do a series of things or update calculated fields when I open my datbase, but I could make a script which I manually trigger or I manually click refresh records.
I wondered about an idea that might achieve the same thing but allow me a level of automation/scheduling via a backdoor sort of route.
I sync my database with CouchDb (hosted on my NAS), I wonder if I could issue a command to make a tiny edit in the TapForms CouchDb to my database, which would then cascade a refresh to TapForms, and this would then force the calculated fields or scripts to execute.
the Apple Script code to do something to couchdb would be based on:
— Define CouchDB URL and credentials
set couchdbURL to “http://192.168.1.240:5984/db-1a619b6d486c466c9fc32a1b4a494f00” — Replace with your CouchDB URL
set couchdbUser to “admin” — Replace with your CouchDB username
set couchdbPassword to “removed” — Replace with your CouchDB password— Create the shell command for the curl request
set curlCommand to “curl -u ” & couchdbUser & “:” & couchdbPassword & ” ” & couchdbURL— Run the shell command
do shell script curlCommand— Optional: Notify completion
display notification “CouchDB refresh request sent” with title “CouchDB Refresh”what I’m not sure, having looked in CouchDb is what or where i’d start to make a tiny tweak. i.e. i could create a dummy field in TapForms I don’t need, but I changed via AppleScript to cascade a refresh.
Thoughts anyone????
Cheers
Topic: Check List via a Table?
I’m wanting to create a table as a list of jobs to do, and have table fields that include things like ‘Task’ ‘Priority’, ‘Done’. (where Done is a check-mark).
I’d wondered if I could add a script field into the table that somehow runs whenever the check-mark is checked, and it’ll run a script like something below, to delete the row that I’ve just added the check-mark against, sort of acting like a to-do list that deletes completed tasks.
the below runs but it doesn’t work, and I wonder if I’m missing anything obvious.
function deleteCheckedRows() {
var tableFieldID = ‘fld-e6d2b5eaf2fb4e78b708ff36d05f31a5’;
var checkmarkFieldID = ‘fld-475a8bbcba634befbca61e39a61fef8c’;// Get the rows in the table field
var tableRows = record.getFieldValue(tableFieldID);// Array to hold the rows that should remain
var rowsToKeep = [];// Loop through each row in the table field
for (var i = 0; i < tableRows.length; i++) {
var row = tableRows;// Check if the checkmark field is selected (true)
if (!row.getFieldValue(checkmarkFieldID)) {
// If not selected, keep this row
rowsToKeep.push(row);
}
}// Set the filtered rows back to the table field
record.setFieldValue(tableFieldID, rowsToKeep);// Save changes
document.saveAllChanges();// Optional: Provide feedback
Utils.alertWithMessage(“Checked rows deleted”, “All checked rows have been deleted.”, “info”);
}// Run the script
deleteCheckedRows();
