Yes, you can use buttons to launch scripts using custom layout or universal layout. You can navigate to a child record as well and back.
This is how my own navigation menu for my CRM form looks like. So many things can be done.
Attachments:
You must be
logged in to view attached files.
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks
Hello there,
I have recently switched from Tap Forms 5 to Tap Forms Pro.
While everything looks promising so far, there is an issue that I have not been able to solve.
I usually make my own Layouts in Tap Forms 5 and like to customize everything so it is not only visually pleasing but also easy to navigate.
Coming from Tap Forms 5 I always hated the look of linked forms in custom layouts. They are bulky, barely customizable in shape and color and jump out of the surrounding layout in a way that I find distracting.
In Tap Forms 5 I usually use a workaround:
I set the dimensions of the linked forms table very small, so that only the controls at the bottom of the field are visible. That lets me pick records to link or access them, but I don’t have to see the big white table in my parent layout. To display linked records in any parent form, I use a script that concatenates and displays values from the linked records. See screenshot for what that looked like in Tap Forms 5 you have the small linked form tables shrunk only to display the controls on the right and the values of linked records on the left.
In Tap Forms Pro, table fields of linked forms don’t really disappear anymore, when you make them really small, but part of the table always remains visible. Also, they seem to forget that you switched off their background color, so every time you re-open Tap Forms, they will appear with thick white frame in addition to the table portion that can not be hidden or changed in color (see second screenshot). It is annoying.
I have been wondering if there is a different workaround from the one I have been using, possibly by using scripting. I am just not that experienced in using Java Script. Is it even possible to embed a button in a form that lets you run a script and have that script take you to the linked records in that linked form?
Any help or ideas will be greatly appreciated!
Melanie
Attachments:
You must be
logged in to view attached files.
No, Tap Forms will only run a calculation or script for the currently viewed record when you make a change to a field that’s referenced by a calculation or script field.
Why it’s taking 2 – 4 seconds before it allows you to make another change is a mystery.
If you’d like me to do a performance evaluation on your document, you can send a backup file to support@tapforms.com and I’ll take a look at it.
No, there are no calculations, scripts or any other type of logic behind. The database document contains roughly 20.000 records but most of the forms are just a collection of text fields. The whole document is for reference only – without any calculation or other high performance demanding stuff.
1 form with 500 records contains icons but this form has no relation to the form that was updated. There are only 2 forms that are linked (n:m) but they are not effected by the changes.
Does every change in one form lead to recalculation in all other forms of the same document? If so perhaps the number of records causes the issue.
Oh that’s very strange. I’ve never seen that or heard of that issue before. Do you have any Calculation or Script fields that may be running when a value in your field is changed? That could definitely be causing some performance issues depending on the formula or script.
Hi Brendan,
The field in question is called Ending Mileage.
I tried your suggestion and duplicated a record. After the sync, all the fields had there values transferred from the duplicated record.
If I go back and make a small change to the Ending Mileage field in Mac OS, the change will occur on some records on my iOS device. If I make a small change on the iOS side, no records receive the updated change on the Mac OS side for that field.
The issue with the Ending Mileage field seems to happen only when the record is created with the script I run. If I enter a new record manually, the issue doesn’t occur. All fields transfer correctly and I can make small changes that sync properly.
The script creates a new record, taking the ending mileage from the previous record and placing it in the new record’s beginning mileage field. I then, manually, add the ending mileage into the new record. It’s that Ending Mileage value I enter that is not syncing.
1 var beginning_mileage_id = ‘fld-dac67386ca7d4603b26f76b16554f162’;
2 var ending_mileage_id = ‘fld-adb786f0ef994f84bf565d422f6537b0’;
3
4 var ending_mileage = record.getFieldValue(ending_mileage_id);
5
6 var newRecord = form.addNewRecord();
7 newRecord.setFieldValue(beginning_mileage_id, ending_mileage);
8
9 console.log(ending_mileage);
10
11 form.saveAllChanges();
I have a form that syncs all of its field’s data, except for one field. This field’s data does not transfer whether syncing from Mac OS (Tahoe 26.5.2) to my iOS (18.7.8) phone. It is a number field, entered manually. There’s a number field right before it that’s populated by a script and it transfers the field data fine.
It could very well be an issue with iOS 18.7.8. If it is, it’s time for me to upgrade my old iPhone SE.😎
Hi Ray.
You add a new field to your form with the Field Type set to Script.
Then use the above script in the field. Set the Field ID to be your Title field.
Then you set the First Sort Field to this Script field, not the Title field.
After you add the Script Field, you may need to refresh the records list to update the result in all the records.
Thanks,
Brendan
I am having this same problem but have not used Scripts in TFP before. I am creating a database of my movies and want the sorting to not include articles (such as A, The, An). I took the script above and modified the field ID for mine, but since I have never used scripts before, I don’t know what to do with the script. It only pertains to my field “Title“ but I didn’t want to do a text manipulation to actually remove the article. Is this created as a script form? Am I still sorting by the title or by some other field? I put this in my database and ran it, but it didn’t seem to do anything. I am still sorting the database by “title“ but should I use some other field? I could create a field that removes the article, Hyde that field and then sort by that field, but I was wondering if there was a more elegant way of doing this?
Thanks Brendan. I’m not planning on keeping attendance in the database. I will only use the database, at the least the roster layout part, to print a roster.
I may try, as you suggested, adding a field for each date, but putting these fields in a separate “dates” form, so that my student demographic database doesn’t get peppered with dates fields.
I was imagining using javascript to call data and place it meticulously in text boxes on the layout. Hopefully that meticulous work would only have to happen once. But I’m so unfamiliar with javascript, I don’t see that happening.
You are totally right, it is MB, not GB. Sorry for confusion!
My trial period ends tomorrow, so I have to decide whether to stay with Ninox or to go on the migration path to Tap Forms. There are pros and cons for both products. After checking my app statistics on the App Store I found out that I had my first Tap Forms app back in 2011 – boy, that‘s 15 years now. Time is running. In 2021 it was updated to version 5 and currently the Pro version is under observation. So why did I switch to Ninox and FileMaker Pro in between? Honestly – I don’t know. I think the main reason was that these products were used in the company I worked for. And I know there where some issues losing data – which for sure was my fault. Nevertheless I migrated to the other products.
What does mean all this for my decision? Staying with Tap Forms for 1 ½ decade – even if not in the drivers seat – is a strong signal that this app is something great. While switching to the other products I always came back to Tap Forms. The latest experiences with this app told me why. The development takes – a big thank you to Brendan – huge steps, the trashcan will help avoiding loss of data (perhaps regularly backups as well…) and the support is outstanding. Furthermore the community is here to help out or bring new inspirations.
Taking these facts into consideration there is only one solution: I will end the trial period tomorrow but continue with a subscription. There is so much of functionality within Tap Forms waiting to be revealed, so I am really looking forward to continuing this exciting journey.
Thank you all for being part of my decision – and sorry for this long piece of prose but I wanted to share my thoughts with you as you were directly involved.
Hi Cliff,
There isn’t anything yet to do that. That’s a great idea though. I’ll definitely add that to the scripting engine so you can select the Dashboard. And with that you’d be able to run a Shortcut to do that.
Thanks,
Brendan
I love the new Dashboard feature. Will you be updating App Intents so we could create a shortcut that will open a document into the dashboard? Or can this be done now, maybe using a script?
Hello, is there a script that automatically removes members from a membership database when the cancellation date is reached?
Well we still have some time before MacOS 28 arrives :)
The “Lite” version would be the same but with limitations (max. number of records and/or databases for example). So it should not require much separate maintenance. You would make the update on the Pro, and add the limitations to the Lite versions. The objective would be to NOT cannibalize subscriptions of TP Pro, but to add users that would balk at an annual $50 cost (the problem is that it all adds up, and if all software is subscriptions, users will need other define priorities). it could be a one-time cost (Audirvana Origin includes updates for 2 years, then has paid update), or a lower subscription cost, one that could be justified for a lighter use, within the limitations of the “Lite” version…
If you find the right levels, you should be able to ideally get additional revenue. Because users of the Lite version could “upgrade” to the Pro version easily, you would also provide an easy path to further revenue increases.
Just food for thought at this point…
