And that will also update the single-column list view too.
Yes but I need to switch views for the single-column list views to update. I’d love to be able to edit using the transcript layout and have the single-column updated dynamically, without having to switch views at all. I think it does make sense for that view to be updated after I click outside the note like you say?
It also seems that there’s another issue: If editing in transcript mode and then switching to Multi-column view the last edit to the text field is lost unless you’ve switched from transcript to Default Layout while still in single-column view.
Hi there,
Using the OS X version (3.5.9) and I usually edit text fields in transcript mode (because it’s annoying to have to open a window just to enter text).
The problem is that the corresponding single-column view text field doesn’t update when I edit text in the transcript, I have to actually close and reopen the Form.
Thanks,
Czuch
Attachments:
You must be
logged in to view attached files.
As always, you’ve got an answer for everything ;-)
Can I change a text field to a note and not damage/lose the content? Having already imported large blocks of Description as a text field, if I globally change that Description text field to a note will I lose the imported text? If so, how do I migrate it to a note field (I have over 700 records so one by one is not really an option).
Also, can you change both the default formatting and lined paper appearance of notes? Thanks.
Hi Opi,
You can ask Tap Forms to calculate the Average by selecting Average from the Summary Calculation function on a Number or Calculation field.
There’s no IF statements for non-numeric values. So you can’t have a text value injected into a field based on a comparison. FileMaker has a huge scripting language built-in to it so that’s why they’re able to do advanced stuff like that. I have a basic math parser in Tap Forms that can do some things, but not as much as FileMaker.
An IF statement would look like this:
IF(Price > 100, 1.05, 0.0)
That will return 1.05 if the Price is greater than 100. Otherwise it will return 0.
Thanks!
Brendan
How do you find the average of the numbers in several fields???
I have several complex scripts in Filemaker, which I find cannot be done in Tap Forms such as inputting a message into a field IF a number in a field is < or > than a certain number or IF an average number is too far off from other average numbers in other fields of averages. From what I can tell, this cannot be done and it’s back to Filemaker.
Let’s just start with finding an AVERAGE. I would like to find the average of numbers in several fields; but only IF there is a number in each field.
ie – the AVERAGE of 100 fields containing 5, blank, 4,4,3,5, blank, blank, blank, blank… is 4.2 (the blank fields don’t count as ‘0’)
How can this be done????
Hi Brendan,
Firstly – as a new user – many thanks for your obvious hard work and dedication to creating and maintaining this software.
My question is this: I’m trying to create an Invoice for customers.
I have used the “Call Log” Form and inserted this into my “Customers” Form.
I have also created an “Invoice” Form within my “Customers” Form.
I would like to keep track of all my calls here and bill directly from this.
My question is: can I pull the SUM of time from the “Call Log” and insert this into the “Invoice” Form and then apply a calculation based on a monetary amount? (e.g.: 1:30 hours x €50 =) so this appears on my invoice?
As a secondary question – is it possible on a Form to put a blank, fillable text field (e.g.: Description of Work) that is not pulled from elsewhere (or doesn’t appear on the Default Layout)?
Everyone apologises hoping they haven’t asked an already answered query (or just a dumb questions)… so, I also apologise!
Many thanks,
Chris Reina
Brendan,
Do you ever plan to support the now standard app extensions format for export on iOS? I’m asking specifically because you can write simple app extensions in python using the pythonista app. That’s particularly interesting to me because pythonista supports quite a few graphics and plotting packages. Several of my forms are for tracking numeric things like weight and blood sugar (I’m a diabetic) where the most useful way to look at it is in a plot. I would like to create multiple simple extensions to show the data in various formats or to do calculations that are not convenient in TF like show the averages of measurements at different times of the day. I know I can export the csv file to the shared area then switch to python, find the script I want to run, tell it which file to use etc but it would be very nice to skip those steps launch the extensions directly from TF especially when I just want a quick look. It seem like the combination of TF as a front end to capture data and extensions (including pythonista extensions) to do fancy processing would be a powerful combination.
Since it is the standard I was sort of expecting this to be there already and was a little disappointed when I bought TF and discovered that the standard share icon didn’t pop up the standard iOS share dialog with its ability to add arbitrary extensions that are prepared to handle the data format. Not too disappointed (TF is too nice in so many other ways) but it would be nice.
-steve (aka zencuke)
Sorry, I should’ve been a bit more descriptive.
Allow me to go back to my previous example with 100 records, and let’s assume the following creation date distribution:
records 1-80: All created on the 1st of June 2014
records 80-100: Created in one day intervals starting 20 days ago
Now the problem is that then the date Table Index displayed on the right is laid out so that 80% of the space (20 days) is dedicated to the last 20 records, while the first 80 records are almost impossible to scroll through using the Table Index because they are all crammed into a tiny space.
Visually this would look like:
| June 2014 |
| October 2015 |
| October 2015 |
| October 2015 |
| October 2015 |
| November 2015 |
| November 2015 |
…
If, however one could use that “creation index” (by that I mean the ordinal by which is created, i.e. the “row number” on a spreadsheet) to map to the Table Index instead of the date, then I would get a linear Table Index based on the number of entries, but still sorted by their creation date. So then the 80 records created all on the 1st of June 2014 would take 80% of the Table Index height:
| 10 |
| 20 |
| 30 |
| 40 |
| 50 |
| 60 |
| 70 |
| 80 |
| 90 |
| 100 |
Let me know if you still have questions, and thanks for your interest in any case!
Thanks,
czuch
Hi Brendan
Thanks for the quick response. Are you able to confirm if the move to the new database engine will be a free update ? I realise that a major new version may require a new subscription but I am concerned that the product needs to be able to handle a few thousand records so would not want to have to pay for an upgrade for just that database engine migration or are the 2 things linked ?
Thanks again
Andrew
So you could have several fabrics, of different types, colors, lengths, etc… For the most part, I’d guess that it’s fairly specific to the pattern. It sounds like that could be accommodated with a link to another form, one to many, and hidden from the usual display. Let’s call that form “Fabrics.” You could add as many or as few records for fabrics to a single pattern, for each pattern.
With a fabrics form, linked to your patterns, you could specify a description, length, cost per yard, number of yards, and a calculated cost for each fabric. The sum of the fabric costs could be shown on the main pattern form, with a “tokenize” function.
The fabrics would have to be entered manually, unless someone has a more clever idea to import records into the fabrics form and associate them to patters, one to many.
Does this help?
Hi Judy,
If by barcodes you mean Universal Product Codes (UPCs), then you wouldn’t get much more than the product name. Still, you could search off of a product code to see if you have it in the database. It’s possible to get all of the UPC information available (outside of TapForms) for any codes you have and use it as an import file. This would help you identify if you already have the pattern. There is a UPC lookup website where you could enter a few codes and see if it is descriptive enough for your needs. If you decide that you need hundreds of codes processed that way, let me know.
Any fabric info would have to be entered in or associated for each item. I would only add that kind of detail as needed.
I’d like to know more about what you’ve tried so far and see if I can help. Have you contacted the person who posted the recommendation on the sewing blog? Perhaps you could get them to export a template for the structure they use.
It’s not working for me.
I imported my credit card statement. It’s very simple.
These are fields:
Name And Type
1. Date – Date
2. Card # – text
3. Description – Note
4. Debit – Number
5. Credit – Number
My form has a calculation set to the field debit
Both Debit and Credit has summary calculations set to total.
I saved a search where the field credit is set as not empty so the resulting list is that of all my credits.
I’d like to see a total of just those records. Instead the search result list still shows debit at the bottom with a total of $0.00
What aren’t I doing?
I know it should be simple!
Thanks
Yvette
Hi Doug,
Which version of Tap Forms are you using? Mac or iOS?
On the Mac version you can access it with the following menu command:
Layout > Font > Baseline > Subscript/Superscript
It’s not available on iOS.
Thanks,
Brendan
Is there a way to include subscript and superscript? For example the scientific forumla for dihydrogen monoxide (water) is H20. It would be great to have the 2 a subscript.
