Search Results for 'script'
-
Search Results
-
Hi David,
You could do this with a Script Field. Something like this:
function Sortable_Title() { var title = record.getFieldValue('fld-3b1b39ccf20f43e583fe66b8aaa0602c'); var sortableTitle; if (title.startsWith('A ')) { sortableTitle = title.substring(2); } else if (title.startsWith('An ')) { sortableTitle = title.substring(3); } else if (title.startsWith('The ')) { sortableTitle = title.substring(4); } else { sortableTitle = title; } // console.log(sortableTitle); return sortableTitle; } Sortable_Title();You could enhance it to support other article words if you like.Thanks,BrendanTopic: How to call another API
Hi, I am quite new to Tap Forms. I wanted to know, since using JavaScript is an option, if you are able to use fetch (or another JS API) to make an HTTP Request.
I have a client using tap forms 5 and has some renewal_date column. I wanted to automate sending out emails on this renewal date. I wrote a script already to find records that are passed the renewal_date. Now, I have a webhook expecting some record data (email, client_No, renawal_date, …). I would like a way to make an HTTP request to my webhook providing the record data saved in tap form.
Could anyone advice me please as I don’t find a way to do it. Is this even possible in TapForm??
Many thanks!
There is at least one previous post about this topic, to get records not to sort by articles, where writing a script is suggested.
I have a music title database with titles in many languages, so getting the sorting right is important. I’m thinking of setting up two fields, a display title and a sorting title. The records would sort by the sorting title:
Étoile
Jahsager
Man in the High Castle
But the form would only include the display title, and so the sort would appear like this.
L’Étoile
Der Jahsager
The Man in the High Castle
Not like this:
Der Jahsager
L’Étoile
The Man in the High Castle
It’s a lot of work to do this obviously, so I’m checking to make sure there is no other easy solution. Also, I guess this will work?
Muchas gracias,
DavidHey again Brendan,
I just finished creating that second form. I followed the manual for the linking (I have to say, it’s so difficult for me to do simple things. I was searching everywhere how I should make the primary key, where it’s done automatically. So fantastic job in making things so easy).
Once done, I followed your post and everything works now as intended (Yay ! I’m so excited it does work, now I finally have a solution to not only deal with my extensive list of video games (18 000+), but I can also finally evaluate the real cost of a game with all its DLC listed.
That’s fantastic and no regrets in my choice to go for Tap Forms ! Thank you so much !
Edit : I would like to give back to you as a thank you a small change your could bring to the application. Don’t worry, I’m sure it’s very easy to do, just a field to edit at best I think. There is an annoying (to me it is annoying) translation in the field description for the French language. I guess it would be “Important Date” in the English version, but in French it’s been translated as “The important date”. That’s confusing to me for a field description. So the suggestion would be to change “La date importante” into “Date importante”
Topic: Movie Database
Hope you find the attached useful. I used to use an app on my phone and Mac but the subscriptions costs increased by 100% and so I thought I would have a go myself. Hopefully you may find it useful as well.
