Search Results for 'script'
-
Search Results
-
Hello everyone,
I apologize for my long post, in advance ;-)
Situation:
For my Form “Tracks” (Tracks for Hike / Bike), there are two important fields:
1) Creation Date of the Track: The date (typical date field), when the track has been created for the first time. It could be today, or in the past, not in the future. In the past only, when I enter the data today for a track, created in, e.g., 2006.
2) Track number: It is a text field with two-digit numbers 01-99. It is a text field, because of the missing leading zero (“0”) within the number fields for numbers 1-9. It is mandatory, that the track number is always a two-digit number.
2.1) The aim of the field is to have a unique number, starting with one (“01”) and should be entered manually, when a new entry is created. It is like a counter: the number of records that have been created per month. It is mandatory that each number within a month is unique.
2.2) Examples: in January, the first record is 01, the second record is 02 and the third record is 03. In February, the first record is 01, the second record is 02 and so on. March: 01, 02, 03 …
I need these two fields to create a unique six-digit track ID, which consists of the year (YY), the month (MM) and the track number (xx):
YYMMxx, e.g. 250401, 250402, 250403, 250404, 250501, 250502 …
250401 = First record in April 2025
250402 = Second record in April 2025E.g., it is today, and I would like to enter a track that was created for the first time in June 2016. This “new” record is the third record for June 2016.
The track ID should be 160603 (year = 2016, month = June, and track number = 03).
After I have entered the Creation Date (1st of June 2016), the script should tell me that for this month (June) in this year, the minimum Track Number must be 03.
As already mentioned, the problem is that I also create entries retrospectively.
My question:
Which JavaScript could I use to check which is the highest number for the the month, for which I would like to create the Track Number? Something like:
var MinimumTrackNumber = (MAX(TrackNumber)) within ( (YEAR(of Creation Date) + MONTH(of Creation Date) ) + 1; // +1 => one more, than already available. RETURN("The minimum Track Number for this track must be: " + MinimumTrackNumber);Thanks in advance. BR
The easiest way is using a calculation field. Enable Show reverse relationship in the link field of the parent form. Then in the child field, use a calculation field to propagate the the client name or the project name down the hierarchy. Don’t forget to set the return type to text.
The other option would be Javascript. You’d need to enable Show reverse relationship, get the parent record from the link field and from there get the field value.
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricksHey Brendan,
Actually I’m looking to pass the data down the hierarchy. So the field data would technically cascade downwards. So one would create client, then from the client add projects. Going to the projects form, one would create tasks for the projects and on each task we would add time tracking entries for billing the client. However to bill the client, the time tracking form would have to inherit project and client data from the top. Through the “link to form” field you can have the child form inherit a single field but the time tracking form would need to inherit two fields of data namely the project and client info. I know, it’s hard to visualize the topology through text.
The easiest way around it is to just work from the bottom of the hierarchy, namely the time tracking form and manually pick the client, project, and tasks each time one tracks their work but I feel that would be unnecessarily arduous, especially once those forms are well populated. I could do this using PHP/ SQL etc but if I can get Tapforms to handle it, it would save a lot of time from having to manually program everything from scratch.
I’ve been going through Ford’s JS Tapforms tutorials which have been very interesting and useful. At this point I believe I should be able to somehow use scripts to pass the appropriate field info down the hierarchy to the time tracking form. We shall see. :)
Topic: Run Fieldscript
Hi!
I have used chatGPT to create a script in a field that creates a nice Markdown filed of parts of my data. It makes it easy to save datain our devops from my meeting-notes and I can still keep track of my records.However it only works when I open up the script in edit script and clicks “save”. So I have to that when I cwant to create a markdown. Is it possible to make the script run when a post is saved?
I have tried ChatGPT here, but it only talks about functions and buttons I can’t find I tap Forms.
Hello all,
I’m just starting to learn how to use scripts in TapForms 5. I do have some knowledge of Javascript from a web programming perspective.
I thought I’d start with something simple such as create a button that deletes a record. I created the button, and assigned the following script which gets the current record, and then attempts to delete it:
function delete_record() { // get current record var thisRecord = record.getId(); // delete the record form.deleteRecord(thisRecord); } delete_record();The console reports: “deleteRecord: TypeError: Argument does not match Objective-C Class, line:(null)”
I’m sure I’m doing something really noob here such as combining a record function with a form function.
Thanks in advance.
