Jonathan Veit

Hey All, So I thought I found a great solution but unfortunately it's not working in IWP and thought maybe some of you would have ideas. Most of our clients access our database through IWP. It would be nice if there was a way for them to store documents related to project records. Using the client I can setup a web viewer to look for a particular folder in dropbox. After an initial login to dropbox, the web viewer will show the project folder according to a formatted project-id as you scroll through the records. I thought excellent! But alas nothing is loading in the webviewer when accessed through IWP. Any thoughts or methods? Thanks in advance. Jon

Ah Thanks LaRetta, I suppose I was being ambitious putting a field related to the table occurrence for the portal inside the portal. I got rid of this and my problem went away. My confusion has to do with the fact it worked to certain extent. What are the rules about doing this, is it just bad etiquette? an absolutely wrong way to do things? Jon

Hello, I'm hoping for someone might point me in the right direction for this strange anomaly. At first, I wasn't sure what was producing the error but I have to do is login through IWP and on the first page, all I have to is click edit and then submit. This first page has two portals, one for the projects, and the second for the requests of those projects. A few "random" projects will duplicate their title within the projectName field. Something like "Hotel Sonesta" will become: "Hotel Sonesta Hotel Sonesta Hotel Sonesta" There is no auto-enter, and no script involved, and I've been trying to figure out what might ties this projects together but I have no clue. Anyone have any idea? Jon

Checked both of those but nothing turned up. Saving the scripts as PDF as searching them was a very useful tip but nothing shows me why this would be happening. It seems to happen on the most frequently access projects but I still have problems isolating the problem. If anyone else knows a possibility or ways of isolating the problem I'd appreciate it. Thanks!

So I'm neck deep into my first database design using filemaker and would describe myself between novice and intermediate. The needed functionality was prioritized over well thought design due to time concerns so there is a lot of going back after the fact and fixing being done. I'm prefacing so I can perhaps be spared the lecture - I know this is a bad form but the company I work for needed a solution quickly. So now my database is producing a bug I'm trying to understand and fix. For some reason the text within the projectName field of my Projects table has been occasionally repeating itself within the field. For example, if the project is titled 'Hyatt Hotel - New York', at some point is modified to be: "Hyatt Hotel - New York Hyatt Hotel - New York Hyatt Hotel - New York" sometimes repeating over 20 or so times. I don't know what's triggering this and was hoping there might be some suggestions for isolating the problem. I figure something within one of my many scripts is causing the problem but not sure even where to begin. I don't have a copy of advanced filemaker so I don't have a debugger but maybe there are ideas or methods to isolating the problem. I couldn't really find a proper forum category for this problem so sorry if this is miscategorized. Thanks for any help in advance. Jon

Ahh.. thanks so much, that makes so much more sense!

Thanks in advance for taking my question. I hope I'm not being too novice about this. I also hope I can explain my problem clearly. So I have two tables whose records want to relate to each other. Specifically, any number of invoices can relate to any number of shipment invoices and vice versa. Having this work in both ways took a repeating field and some scripting. This is not my problem. My dilema is then creating unique information for that relationship. I can't simply reference information in a record in Table A from record in Table B because that record in Table A might be related to multiple records in from Table B, all which require a unique value. I thought maybe a repeating field to store each different value a record in Table B could reference but I can't seem to find a way for this to work. I can't refer to specific values in the repeating field throug the portal as I would in a function, using the [ ] notation. I even thought of creating a new table and portal system but I started realizing trouble in this direction as well. Any help?