jscooper

Hi, I'm updating a site survey app (sounds similar to Caroline's) and stumbled in here looking for the same thing. In prior versions of FMG I had to instruct users to take pictures to their camera roll then import them if they wanted to ensure they had them, regardless what happened to the database. This was needed because a typical user kind of assumes every picture taken lands in the camera roll, and were unpleasantly surprised to find out otherwise after deleting a record or clearing the field. I'll have to do the same thing as earlier versions, with a one-time reminder on the first picture that it doesn't get saved to the photo library. It would be nice to have a "also add to picture roll" option attached to "Insert from Device" (yes, I already submitted a feature request 😁). Thanks, Jeff (wow, just noticed this was my first post here in 14 years 😳. I guess going in-house has kept me distracted.)

Haven't tried this, so I'm not sure if it'll do what you want, but you can try setting up a privilege set and under record access setting the View to Limited with a calculation = (get(accountname)=table1::createdby) or get(layoutName)="report1" or get(layoutname)="report2" etc. This should (I think) allow certain records to show up only for the creator OR if the layout is a particular report.

You can define a Privilege Set then set record access to allow editing only if certain fields are blank.

It depends on how you'll use the values. If they're for a report, you can use subsummaries to show distinct values. If you need a list of values in a form, you can define a value list showing the field you need then use ValueListItems() to display it. Or, if you actually want to find only one record ("copy") of each value then you still have to use a script to do it. I too yearn for some sort of simpler Select Distinct... capability. Jeff

I think I understand what you're looking for: a list of schools, for each school a list of teachers and, if that teacher has any courses, a list of those. If that's right... Try changing the layout to show records from the courses table occurance rather then the schools. Change the body part to a sumsummary when sorted by teacher. Then add another subsummary part sorted by school. On the shool's subsummary put the school name and info. Into the other subsummary, put the teacher info including a field containing all courses the teacher is taking (look at the LIST function for this). When you print the report, sort the records by teacher then by school. This should have a list of teachers print out (each listed once) under school names. Jeff

Available free from Compudude ( www.compudude.com), Find *it* searches the names of various database objects for the text you specify. Especially with large solutions, it's often hard to remember what a certain object is named to find it in the various development dialogs. With Find *it*, simply type in a part of an object's name and get a list of everything with that text in the name. It's also useful when deleting fields since, although you're warned when the field's being used in a script and forbidden from deleting fields used in calculations, FileMaker does not alert you if the field exists on any layout. With Find *it* you can search for the field name and see every layout on which it appears. Find *it* searches through the names of layouts, value lists (including value list items), table occurances, scripts and fields. When searching for fields, it looks on all layouts, in all relationships and in the default table (the first table created in the file). Some may recognize that this utility makes use of the built-in FileMaker Pro Design functions. Therefore, no Database Design Report (DDR) is needed. Requires FileMaker Pro 8.0 or FileMaker Pro 8.0 Adanced.

On the client the tar file shows up as a tar archive (with the mac zipper icon). On the server, which is where I ran the tar command to create it, it's a stuffit tar icon. Another plugin on the same server is autoupdated fine. The server is 10.3.9 (not server) and the client is 10.4.2. Thanks. Jeff

Howdy all, I have an FM8 client with Server 7. I have a plugin set to autoupdate without a problem (Troi File Plugin). But I'm now trying to do the same with EventScript. It's in a tar file. When it downloads to the mac client, I end up with an empty FOLDER called EventScript.fmplugin, not a plugin file. Anyone seen this before? I'm stumped. Thanks, Jeff

Hi All, In v7, I was able to get around the forced alpha sort in value lists by defining a second "space" field and sorting by that. In v8, it looks like that no longer works. Take a look at the attached in 7 then in 8. In 7, the list is sorted in the order the records are entered. In 8, they're alpha sorted. My goal, of course, is to be able to have a non-sorted dynamic value list with only one field being displayed. Since the sort option is disabled when displaying values only from second field, I can't see another way to do this. It looks like 8 killed one of my favorite workarounds. Anyone come up with a new/different way to do this in 8? Thanks, Jeff Value_List_Test.fp7.zip

Do you have developer/advanced? If so, you can use a recursive function such as: TrimP(text)= // TrimP strips spaces and carriage returns from text Case( Left(text;1)="¶" or Left(text;1) = " "; TrimP(Right(text;Length(text)-1)); Right(text;1)="¶" or Right(text;1) = " "; TrimP(Left(text;Length(text)-1)); text) This just removed paragraph marks and spaces, but you can set it to get rid of whatever you want. Jeff

This is too strange so I think I'm either overlooking something obvious or there's a bug in FM7. I have two files: FileA has a value list that includes values from related records that are also within FileA. The relationship is from a global field to a regular text field. FileB has a value list defined to be the same as the ValueList in FileA. NOT values from a field in A, but the actual FileAValueList. I have a field in FileB that uses a Popup menu displaying FileAValueList. The value list (FileAValueList) displays fine in a field in FileA. But when I apply the value list in FileB to a field in FileB, I get "" when I click in the popup menu field. Now, I KNOW it's an unrelated table, but displaying a value list from another file should work even if it is unrelated, shouldn't it? I'm not try to display values from records relating back to a table in FileB. Rather, I'm trying to get the value list that correctly displays in FileA to display in FileB. As I said, maybe I'm missing something, but if there needs to be a relationship from FileB to FileA, then I don't see the practical difference between "Use Value List from Another File" and "Use values from field". Thanks, Jeff

I KNEW there was a good reason for it .. just couldn't think of any off the top of my head. Thanks.

I finally started playing with the Lookup function and, I'm embarrassed to admit, I'm a bit confused. What capability does this provide that's not already available with a regular lookup or an auto-enter calculation? A field set as a calculation field with the function Lookup("Relatedtable::value") seems to have the same result as making the field a regular lookup (and locking it to prevent overwriting the looked-up value), or auto entering the calculation "relatedtable::value" (and locking the field). All result in an indexible field that need to be manually tripped to repull changed values either by triggering a relookup or, in the case of an auto-enter calculation, manually changing the value or adding the match field to the auto-enter calculation to have it update when the match field changes. Why would I want to use this function instead of using a regular lookup field or auto-enter calculation? I must be missing something obvious, but I just don't see it. Thanks, Jeff

Maybe it's supposed to be this way, but I had hoped this would be fixed by v7. Sliding/Reducing size of part does not seem to work properly in certain parts. I have a report that needs to include items from a couple different tables. As an example, imagine a Company table connected to both a Contacts table and an Orders table; I need to get a list of companies and, within each company, a list of contacts AND a list of orders all on the SAME REPORT. The only way currently to do this is with portals -- base the layout on Contacts (which go into the body part) and put Orders into a portal in a subsummary by Company or a grand summary or header (or visa vera). Anyway, that's kind of what I need to do. Using a portal in my situation would work if I could make it correctly close-up whitespace in either a title-header, subsmmary or leading grand summary.I already tried scripting the portal contents into a big text field. the field closes around the text, but the part does not reduce in size, I assume because it's in a part that doesn't like reducing. Anyone know of a work-around/trick for this? Thanks, Jeff

Anyone know if there's wany major drawbacks to running Fm Server 5.5 and FM Server 7.0 on the same machine? I'm doing an upgrade to 7 and it needs to be done in pieces (lots of unrelated databases). Since it runs as a service on OS X I assume it's ok, just making sure so I know if I have to buy a new machine. Thanks, Jeff