Hi Sam,
Nice script, but perhaps there has been a change in the syntax.
Looks like line 44 needs the change in two places ‘ID’ -> ‘Id’.
Thanks,
John
4/18/20, 11:58:17 AM / Movies not owned / SamsUnmodifiedScript
SamsUnmodifiedScript: TypeError: sourceFields[sourceId].getID is not a function. (In ‘sourceFields[sourceId].getID()’, ‘sourceFields[sourceId].getID’ is undefined), column:41, line:44
Thanks to both of you. I was already using “Saved Search” but display of number of these matches is a bit subtle for me, and I already have ten “Saved Search” categories displayed in my Multi-column list view. The more prominent record count for Forms more pleasing to my eye. If desired, Sam’s script can move the occasional record between forms for me without re-entering the data.
I appreciate the elegantly simple integration of Java scripting you have done, and have not used it until now.
As an aside, a solution I’ve posted elsewhere is to use a link to form field with a second form which will give you the table interaction style still and the ability to add in your own sort field. It does require some scripting, it isn’t entirely bulletproof but it does generally work.
Hi John,
Ya, as Sam suggested, a Saved Search is your best bet for handling this sort of task. It’s what I designed Tap Forms to do for you.
But if you must, you can look into Sam’s script or you can use the Export Records command to export a list of records, without the Export Record IDs option enabled, then use the Import Records command to import those records back in to your other form.
Thanks,
Brendan
Out of the box I think the suggestion is to just use a search to filter records that should be included or excluded. Tap Forms’ saved search feature is powerful and allows you to easily see a subset with navigation displayed on the left.
A while back I wrote a script to copy records between forms, though deleting I purposefully exclude because of the obvious risk of data loss though it should work fine.
Oops. Ok, I’ve just fixed the printing bug with Script fields not being printed.
Hi Alejandro,
Tap Forms can only create Saved Searches on the parent form. Not on the child forms.
But you can create a Saved Search on the child form directly to filter that. You just can’t filter the parent records directly with values obtained from the related child form.
However, you could write a script to get information from the child form to propagate up to the parent and then do searches on that. Or with a one-to-many relationship, you could add a Calculation field or a Script field which extracts information from the parent form. Then you could add the search directly to the child form.
Hope that makes sense.
Thanks,
Brendan
Thank you Daniel,
I will have a deep look at your script.
On the other hand, I expressed myself somewhat misleadingly … it sounds you think of the Apple Apps “Notes and Photos” I wrote about but with Notes and Photo I mean the field types “notes” and “photo” Tap Forms offer…
Hello Wilma,
I’m glad that you’re enjoying Tap Forms!
I would recommend switching the Field Type of your Description field to be a Note field instead of a Text field. You’ll get a much larger area to view and edit the values then.
You’ll get a warning when switching the field type from Text to Note, but it’s ok. Your data will display just fine after the switch because Note and Text fields are compatible. They just display and edit differently.
Thanks!
Brendan
Hello all, after my beloved Bento gave up a couple of weeks ago, I switched to TapForms and I’m not disappointed. In fact, I’m so pleased with it that I deleted Bento altogether and I can also trash the old MacBook I kept around just for the purpose of the one Bento database that I cherish :-)
Importing the Bento data was very easy and without a glitch and pretty quickly found my way around Tap Forms to customise a form. Synching to my iPad works like a dream (except for today, perhaps the update?) but I have one question: my movie database has a large “description” (text) field but on the iPad I can only see a very limited part of this description: the beginning of it and when I tap on it, it shows me the last bit of the description. There’s no pop-up or fly-out field on the iPad to show the entire description. The description is restricted to the one-line box.
Am I missing something? Is there a way to see the entire description on my iPad also?
Here is something I’m working on: https://api.danielleu.com/public/tf5/v1/files/configHandler-v1.js
I use a form where I store variables that can be used by different forms and their scripts. To use it in a calculation field, you would need to add a field script that just returns the global variable. Then in your calculation, you can reference this field.
No idea about what and how to go about your wanted usage of variable in Notes and Photos. This might be something for a form script.
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks
…thank you very much Sam, I really appreciate the time you have spent to explain me your script, I’m going to analyze it, try to understand it and reproduce what you explained in a new TapForms file in order to link a form to table.
Thank you again Sam ;)
Lorenzo
Hi Sam!
Thank you! I’m looking for all your scripts at GitHub and are great to learn a lot!
Neat! That’s a similar concept to a form logger script I wrote a while back. The latest version on GitHub includes a mode that outputs the script fields as Javascript variables prefixed by form name to ensure that your fields across multiple forms aren’t confusingly duplicated. I copy the output of the console log for this script to a new form script called “All Fields” which I can reference everywhere and use the same variables.
Thanks for replying Brendan.
I’m absolutely new to Javascript. Is it alright if you upload an example working database which uses the child records loop snippet?
