Search Results for 'script'

[Patrice Hof]

Hi Brendan,
After having re-installed TF from scratch, as announced previously, I am testing iCloud sync with 2 Mac only.

The fresh new restored DB size is 1 Go (TapForms_db.sqlite) on both macs. Bidirectional syncing seems to succeed.

After 2 days of minor changes (modified 3-4 records and added 2-3 others), taken into account by both macs, the db.sqlite on Mac 1 has doubled its size: 2.16 Go, even after running maintenance scripts.

On Mac 2, the db remained at 1 Go. And both TFsyncDoc…[0] are always 600 Mo.

Do you think it is normal?

[David Butenhof]

If you export the “small duplicate” forms as CSV and then import them back into the “large main” form, the large form should retain all characteristics, but the new records will be added to it. Yes, if you imported the CSV as a new form you’d lose any design/configuration — but that’s not what you’re doing. What you end up with should be exactly the same as using the form’s “+” button and typing in each of those records manually.

Be careful, though, when checking for “duplicates”. It’s good that none of your names are duplicated, so you won’t end up with “duplicate records”. However it’s still possible (although unlikely) that the form_record_id column might have duplicate values. When you import the CVS files, that column is how TapForms determines whether the records are “the same”, and it’ll treat an identical form_record_id as an UPDATE to the existing record. (That’s how sync works.)

In order to check this you’d need to either export the “large” form as CSV or access the TapForms sqlite database directly, and run a script comparing the form_record_id values between the two forms. It’s not something that would be easy to do visually since the values are long meaningless strings.

[Frank Nichols]

I think I may have been using conflicting (with you) terminology earlier, so first to clear that up. In the following description I call the SUMMARY the parent/master and the options (COLOR and SIZE) child/details, after seeing how your link to options work, I think you refer to them the other way around.

Lets say I have three forms, the first form is SUMMARY which displays a list of selected options, each record in SUMMARY would allow the selection and display a different selection of options. I can’t use pick lists for this because the options have multiple related values – so, I use linked forms.

Forms 2 and 3 contain rows of options that can be selected by the SUMMARY form. Lets call them COLOR and SIZE.

To setup this relationship I go to the COLOR form and create a field of type Link to Form with a ONE-TO-MANY relationship and select SUMMARY in the Link to Form drop down menu. I also tick the Display Inverse relationship option.

I then go to the SIZE form and create a field of type Link to form and set a ONE-TO-MANY relationship and select the SUMMARY form in the Link to Form drop down menu and then tick the Display Inverse Relationship option.

Both option forms have multiple attributes (fields). I selected in List View Fields the 2 option to display the first two fields only.

Now, I go to my SUMMARY form and create a new record and I can click/touch the COLOR field to bring up the selector and select one of the COLOR records. When I do that the color I selected is then displayed on the SUMMARY form in the COLOR field, as I would expect.

Next I click/touch the SIZE field and I can select a SIZE record.

When I select a SIZE record, the COLOR field (previously selected) is cleared and becomes blank. If I go back and reselect the COLOR record, it is displayed and the SIZE field is cleared.

That is not what I would expect, I would expect the two to operate independently, and I need both to be displayed after being selected. In fact, on my real form I have about 30 of these option links displayed. It would not be very useful for the user to have to click each blank field to see what option had been selected.

I have tested this on both Mac and iPad versions with the same results.

As a side note, on the Mac display I would prefer to not display the controls under each of the LINKED FROM fields (SIZE and COLOR) or maybe to have the option to hide/show them, and then just click on the field to bring up the options – much as it is displayed on the iPad. With a lot of selections in my list (30 or so) having those controls on each row adds a LOT of screen space and clutter I don’t need. It isn’t a deal breaker, but just thought I would mention it. I haven’t created a custom layout with the Mac yet, so maybe that would fix this issue, but it still seems to be a lot of controls that really don’t need to be displayed – or at least could be optional for those that don’t want them.

Thanks,

Frank

[Frank Nichols]

Thank you for your quick reply, it is very appreciated. That does work as a One-To-Many relationship.

So, the remaining (at this time :) ) issue I need to resolve is to be able to display field(s) from the child form on the parent form when the child record is selected.

The application I am working on is to allow users to create a product requirement by working through a series of forms and selecting predefined attributes and adding custom attributes. The predefined attributes are available in a series of child forms which are initially populated by me, and can be extended (records added to) by the user. This is a long complex process and it is required that the user be able to “see” their choices as they progress or review the forms that have been filled out.

So, (If I explained that clearly?) what I would like to do is to have the parent form allow them to select from a list of child form values that are predefined (or extended by them, by editing the child form – not during the selection on the parent form). The child values/records would have various attributes associated with each – name, description, value1, value2, value3, etc… When a child record is selected on the parent form, I would like a specified (or by default the first field) field to be displayed on the parent form so that the user can see what choice they made.

As it works currently, it seems, there is an indication that a choice has been made – the number of associated child records is set to 1 instead of 0 – but the choice is not displayed until you click/touch that field on the parent form.

In the Mac OSX documentation it shows the child record(s) displayed on the parent form in a sub-table at that point in the parent form. That would work okay for my application but is not necessary if adding a sub-table field is difficult, all I really need is for the parent field to be filled in with the current contents of the child’s first field, similar to the way the parent field is populated by a Pick List item.

Thank you again,

Frank

[David Butenhof]

Bento started behaving unreliably on Yosemite. For some, it apparently doesn’t run at all. For me, it runs, albeit with some occasional odd dialog boxes or hangs. Clearly, it’s time to jump ship — even if it’s still not entirely clear there’s a safe place to land.

Most of my Bento forms imported into TapForms flawlessly, so thanks for that! However, the two main forms where I made use of Bento Simple Lists remain problematic. They’re too big to re-enter manually. I can’t shut down Bento for good without moving them. And I’ve still got no handle on how to do it.

I had written a Python script that would strip out the Simple Lists from a Bento CSV export into separate forms which, in theory, could be imported into TapForms. Having been unable to accomplish this, I’d resorted to round-trip TapForms export/import; and as recorded in this thread back in the Spring, I’d had trouble even getting that to work. But that was a demo version.

Now I’ve gotten around to trying again with the released TapForms 3.0.2; and it’s not working any better than it did back then.

I created a simple Movies form, with a linked Movie Viewings form. I entered two movies, more or less randomly, with one viewing each, and this seemed to be working just fine.

So I exported the parent (Movies), and TapForms created a Movies folder containing Movies.csv and Movie Viewings.csv. Each shows two records, as expected, with all the UUID columns apparently intact. In the attached archive file, you can see the Movies folder and the contents.

I then Deleted both forms from TapForms, and imported the Movies.csv parent.

First oddity: it imported the form just fine, but with no records. I have to import a second time to get the data.

Now I go on to import Movie Viewings. The form imports fine, with data. Now I go back to Movies, and edit the fields, selecting Movie Viewings form the Link to Form popup on the appropriate record. The embedded table appears; however, no matter what I try, I can’t seem to get it to actually find the data in in the child form. The table is empty. This obviously doesn’t do me any good; and if I can’t re-import exported TapForms data, it’s no surprise that I can’t make my converted Bento data work.

Note that if I export the imported data, the Movie Viewings.csv file shows no data, only the headings. Clearly the linkage didn’t work correctly. This is the Movies1 folder in the archive file.

So am I missing something, or does this just not work?

Attachments:

You must be logged in to view attached files.

[cd13]

Hello Brendan,

Don’t know if you looked into this request any further but I have the same requirement as Franz. Only it has to do with my wine database; what I would like to do is link my wine purchases and notes to a second database that has descriptions of the wine/grape varieties.

E.g. My Wine db would have an entry for Calamus Vinemount Ridge Riesling then if I would like to get the grape descriptions I could either lookup “Riesling” in the Wine Variety db or have the descriptive appear in a new data field called “Description” (the same Riesling description would appear for all Riesling wines).

Many thanks,

Chris

[LeoC2]

FYI I tried something else and it seems to work fine. Instead of making a new Section Heading for each field I simply name the filed with the description included. While this makes for a very long field name it seems TF handles it fine and it makes for a cleaner entry screen. One interesting thing I discovered is that when I changed the field names any calculation fields automatically updated with the proper field names.

Also when I pasted the field names in they came across with carriage returns which made for an even cleaner form. Speaking of CRs, how can I enter one in a form title?

The attached image shows the new field names in red.

Attachments:

You must be logged in to view attached files.

[George Drohan]

Thanks for the response Leo. Dave’s handbase is great but the interface is a bit dated. Also I was using external popup lists(pick lists) that are huge 500+ entries for categories and style and it was a bit difficult to scroll thru all the entries (even though it does have a side “index”). It doesn’t seem that TF supports external pick list other than linking forms. But I read somewhere that TF has a better search.

So even if we can’t choose what fields we wish to view am I doing something wrong about not viewing the original image in the other form?

While I’m at it;
1) The inclusion of the image file name as a real field name is helpful for me but I wouldn’t want to see it in a linked form.
Using excel, I wrote a script that grabs the file name and opens and resizes the image in that spreadsheet based on the file name. It’s was a PIA but it was a way to get the image in spreadsheet as a macro.

2) as in my prior post I wish the manual was a bit more technical and up to date. I’m old school and like to have manuals.

[Brendan]

Hi Leo,

You could add a Section Heading field above another field to give a longer description. That’s what other customers have done that I’ve seen.

Thanks,

Brendan

[LeoC2]

Other than the field label is there a way to add a short field description to the display in the IOS versions? The field label is not usually enough for my purposes.

leo

[Patrice Hof]

Hi Brendan,
I tried again to sync from scratch. It takes several hours to sync a 200 Mo DB on 3 OSX devices and 2 iOS devices. I’m not finished yet, and the terminal shows this error message:

[ERROR] 4049.948 [2014-11-23 22:34:35.667] brc.fs.writer fs.writer BRCFSWriter.m:828
Failed to unstage r:6102 i:FXLPHZS84D.com.clickspace.tapforms:92107664-F3F0-4347-9666-4D8A7A479886 up:idle st{p:FA4B15CB-41C1-4743-90EB-793E5CA53E8B n:”BonDél Sculier 2012 08 15.pdf” fault reserved etag:1ct bt:315442800 m:rw- doc:18220 pino:13613685 s_ino:13624810 s_gen:61} ct{etag:1cs mt:1398437704 sz:829 Ko (849188) n:”BonDél Sculier 2012 08 15.pdf” sig:01d90aacd451316db8eb79b39e32b40ff4898ccb8d device:1 quarantined} downloading{etag:1cs mt:1398437704 sz:829 Ko (849188) n:”BonDél Sculier 2012 08 15.pdf” sig:01d90aacd451316db8eb79b39e32b40ff4898ccb8d device:1 quarantined downloading} [(null)] to BonDél Sculier 2012 08 15.pdf: Error Domain=NSPOSIXErrorDomain Code=0 “L’opération n’a pas pu s’achever. Erreur inconnue : 0” UserInfo=0x7fa51ac26050 {NSDescription=Undefined error: 0}

Could it prevent the syncing to occur? This error message is produced for all pdf documents attached to records…

Thanks for your help
patrice

[Daan]

Brian,

While the Mac-related sync issues slowly seem to resolve themselves, I still get the message ‘Please turn on your iCloud account using the Settings app, including iCloud Drive’ even while iCloud and iCloud Drive *ARE* turned on and are working as expected in all other apps.

I am using the latest versions of TF (3.9.1 – 219) and iOS (8.1) on an iPhone 6 and an iPad Air form last year.

I did log off from iCloud on all devices — and had a lot of trouble signing in afterwards, as my 2-step verification push message does not come through anymore to my Vodafone-subscripted iPhone (a bug in iCloud for several providers at this moment).

Help again?

[Heiko None]

Okay, i updated to Version 3.0 on my Mac.(Yosemite)

Here my Bug description:

If i use the layout function and insert (draw some lines), the lines
will not show in the print preview and the will not print.

Attachments:

You must be logged in to view attached files.

[David Butenhof]

By the way … for what it’s worth, Bento is working fine for me on Yosemite and iOS 8, aside from having to accept a weird dialog when first launching it. I don’t know why you’re having problems — and as you say this isn’t the place to troubleshoot Bento.

But it is aging, and I definitely agree it’s time to move on. TapForms still looks like the only viable migration strategy to me, and in many ways a clear improvement.

The only reason I’m still using Bento is that I still have no migration strategy for my Bento Simple Lists. I’d spent some time a while ago trying to write a Python script to re-structure my Bento CSV exports into something TapForms could import; I just wasn’t able to get it to work, and haven’t had time to try again.

[Rob F]

Hi Brendan,

Thank you. I’ve had a go customising my first lay-out but I can’t seem to get the field names to populate through with the fields, i.e. “Name” field just has the box within which to write the name, but no “Name” descriptor to the side of it?

Thanks for your patience :)

Rob