jschwarz

Yes, it is a repeating field with 5 reps. Can you point me to a code example for a script that does something similar?

I posted this in the import forum, but it's a bit low traffic. I'm converting an older version of a database into a newer one that we've developed for a non profit doing fundraising. The old DB has "home phone", "address phone", and "other phone". The new DB has a 5-field array of phone numbers, and a corresponding popup menu with phone types, including fax, work fax, etc. Is there any way to map the separate fields from the old DB to be imported into the array? Otherwise, I can only import the home phone, essentially. Can someone let me know if this is feasible with FMP, or if I'm going to have to do this manually (yikes)? Thanks

I'm converting an older version of a database into a newer one that we've developed for a non profit doing fundraising. The old DB has "home phone", "address phone", and "other phone". The new DB has a 5-field array of phone numbers, and a corresponding popup menu with phone types, including fax, work fax, etc. Is there any way to map the separate fields from the old DB to be imported into the array? Otherwise, I can only import the home phone, essentially. Thanks

Aha! That worked, thanks so much. It was there all the time, just invisible... how frustrating.

Since I have two shots, and they're a bit large, I'll link them instead of attaching them. Layout View Browse View (there are 4 records total) Let me know if that helps.

Ok, that's what I thought, but I can't get it to work. If I have "show vertical scroll bar" checked, and show 3 records, starting from record 1, and there are 4 records, I can only see the first three. There's no scroll bar. I made sure that the portal was wide enough to contain a scrollbar, but I still don't see one. Any thoughts?

I've made the layout as big as possible, which seems to be about 111 inches high. At that height, I have room for 36 rows now. I guess I'm looking for a way to show more rows than that (like 100), but have them scroll within a smaller physical area (like an iframe, if any of you are familiar with that html feature).

I do have the scroll bar on, but I'm still limited on the total number of records I have... right now, the most it will let me show is 35. If I try more than that, it says it will exceed the maximum size of a layout. Perhaps I'm not experiencing the benefit of the scrollbars... I can't see where the come into effect. But there are two issues - 1, how do I show more than 35 records, and 2, which is less important, how can I display all those? I'm thinking that the scrollbars can help with the second problem, but I still can't solve the first.

I'm working on a fund-raising app for a non-profit group. They want to keep track of donations, pledges, etc. They've designed the DB, and I'm building it for them. However, on gift entry, there's one layout for gifts, no matter the type. I have a menu for type: pledge, pledge payment, matching gift, etc. I have a summary field on the gifts db that totals all the gifts by each person. So far, so good. However, if someone enters a pledge for $1000, then pays it off with two payments of $500, the total is going to show up as $2000... it counts every entry as contributing to the total. What we really want is a way to have two totals: all money pledged, and all actually given so far. I come from an SQL background, and so the way I'd do it is have a summary of each type of gift... all pledges, all payments, etc, and then I could display those. Is there any way to do that in File Maker as my fields are setup, or will I have to create separate fields for payments and pledges? I can clarify on the field setup more if needed. Thanks.

Is there any way to get around the limitation on the number of rows in a portal? I have a portal that lists a number of events for a fund-raising program for a non-profit, and they think they eventually may have many events. Do I need to artificially limit the number of events (only show the last 25 or so), or is there some way to dynamically expand the size of the portal? I think they wouldn't mind it being essentially infinitely long if they could scroll through it all. Thanks.

Beautiful. Thanks for the help.

I have a list of people, and a salutation field that allows you to choose how an envelope should be addressed. Choices should be Mark and Anne, Mr and Mrs Smith, Mr and Mrs Mark Smith, etc. I have this by having a field Salutation which is a value list based on a calculation field (Salutation Calc). If I display Salutation Calc, everything is perfect, but when I display Salutation, it has Mark and Anne, James and Suzanne, Mr and Mrs Smith, Mr and Mrs Johnson, etc, because it is indexing the calculation from every person's record. How can I display the field for just that one record? It doesn't have to be a popup menu, just anything that will allow someone to select one option. I tried unindexing the salutation calc, but the value list doesn't work if the field it's looking at is not indexed. I don't think there's a way to index per record... is there?

Thanks for all the replies so far. Just to clarify, what was initially asked of me was truly just a one-to-many relationship, as they didn't mind re-entering event info each time. This is, of course, silly, and a waste of effort. So, sorry for being slow, but I have a few more questions. 1) Instead of joining my People table and Events table, I should create a third table, Signups, perhaps, and it's connected to both of the others? If so, I imagine it would have fields for People Serial and Event Serial... and that's it? 2) To add a new event, the layout should be based on the Events table. However, to fill in one person's details for an event, it should be based on the Signups table? Finally, a third layout based on the Person table would show all events for one person? Thanks again for the help.

Sort of. Since this will contain details specific to each person for each event, it's really just one-to-many. We're not concerned with details about the event, but rather, each person's details about the event - has an invite been sent, have they RSVP'd, have they paid, etc. I have my tables all set up, so this is more of a technical issue than a design issue. I need to know how to get the serial from the person that I select and store it in the event record.

I had posted a similar question under relationships, but this is a broad question, so I think it's appropriate in this section of the forum. I have a table of people, for a fundraising db, and a table of events. Each event needs to be tied to a person, as it contains their payment info, etc. There need to be many events per person. I want to have a layout that displays all events per person. I am planning on using a portal for this. However, I can't create new events on that page (all events), as they need to be looked up. I did this by creating a field on the Events table which is joined to the Person serial. On my layout for creating an Event, how can I get that Person serial? I have a choose Person field, created by a value list that looks that the People field and references a Full Name calculation. I suppose I need to do some calculation based on the name selected, get the person's serial from that, and insert it into the events person serial. Can someone help me with that? I can clarify if needed.