Search Results for 'script'
-
Search Results
-
Hello,
I have a parent form called Clients and child form with a number field called Target. I’d like to use record.getMaxOfLinkedFieldForField(linkedFieldID, fieldID); to find the max of Target for each particular client.
I’ve tried using different field ids in the linkedFieldID and fieldID positions and the the script will run without errors but no output is produced.
Are others having success with this?
Kind Regards, Dan
Hello All,
I have TapForms iPad form connected to a client form via a “linked to form field”. When I run a simple script to duplicate the current record, the duplicate doesn’t show up until I return to list view.
The script:
var copyOfRecord = record.duplicate();
document.saveAllChanges();This works as hoped in a “Table Field” record, but not otherwise.
I’m surely missing something.
Kind Regards, Dan
I frequently have multiple edit windows open for
noteormarkdownfields, sometimes from the same record and sometimes from multiple records. One problem I keep running into is that I frequently confuse which window is for which notes field because there’s just not enough info in the title to differentiate. As an example, I have three windows open right now onnotefields from three rows of a table, and all three are titledNotes - Occurrences– withNotesbeing the table field’s name andOccurrencesbeing the form’s name, both of which are the same for all three fields/windows. Often when this happens, I end up closing and reopening all of them to straighten things out mentally.To help, I try to position each window uniquely and then use position as a factor to identifying which window is which. However, this doesn’t get me very far because the main database windows are positionally tied to the edit windows: move the former, and the latter move with it, as though they’re one unit. So if I have multiple databases open at the same time (as I usually do), if I move one of the main windows so that I can better see something else, everything shifts and my spatial system breaks down.
Thus, I’d like to propose adding more information to the title of the edit windows. To ensure there’s always enough info to differentiate, you’d probably need to do something like
<form name> - <record’s first sort value> - <field name> [- <row number>], with the last part only applying to table-ish-type fields. That’s probably a bit much, so some configurability would be nice. Ideally, you’d just have a place for me to specify this in the field properties, maybe using tokens or even a calculation/script. Then I could do cool things like mix static text with the DB name, the form name, other field’s values, or a particular table column’s value.Hi, is it possible to configure sort preferences through a script, as opposed to using “Sort & Group Settings” in the forms inspector panel?
Seems like field.sortOrder simply specifies field order in the form inspector, but maybe I’m misunderstanding its use?
Hi Mike,
There’s a setting on Number fields to display the value red if it’s negative. But not for Date fields that are past due.
But you could use a Script field to return an Emoji character that’s red along with some text perhaps such as “OVERDUE ‼️”
Topic: Automate/script export?
Is there a way to automate Tapforms’ existing Export Records function? I’d love to be able to run a script that basically exports the current thing I’m looking at as an Excel file. (Ideally I’d love to have an automated “export, then publish to Google Sheets” kind of functionality, but at the moment I’d be happy just reducing the number of steps.)
I’m an ignoramus of Javascript, though I can hack my way along by modifying others’ code. Same applies to AppleScript.
Thanks in advance for any suggestions!
Mike
