Agent Ska

If your goal is to generate a list from those cells then you could go right to a list within the tell record. tell application "FileMaker Pro" tell table "2008X2DGEN" tell (every record whose (cell "AREA_ID__C" is "R8M00")) set x to count of records set addressList to cell "ADDRESS_NAME__C" end tell end tell end tell

Can you explain a bit more what you are trying to do here? I'm not following what you are trying to accomplish.

Sorry. Not sure that I am following you here.

(I would think this topic has been covered somewhere in this forum, but my keyword searches must be lackluster. This question has also been posted in another thread that had started dealing with a much different concept - but, I thought that this specific question would be better served in this forum.) I have a portal that includes a graphic button in each row, that when selected, adds a parameter to a global field and, conditionally formats the portal row. When clicked again, it removes the parameter from the global and reformats the field. It's beautiful. If multiple rows are selected, multiple parameters are added to the global field. This obviously only works in the FM Client. I have a need for a layout using the same portal information to be accessed via IWP. Obviously, the conditional formatting will not work there. I have searched the forum for a manner in which to use a checkbox on the web layout, but have come up empty. (My concern, of course, is that the user can see which rows have been selected vs. which rows have not) I tried setting up a checkbox attached to a value list with only one value, and attaching a button with the same set field steps to that checkbox. However, the check box clears itself after adding data to the global field. And if a secondary checkbox is selected it over-writes the global field, rather than adding to it. Is there another way to add an interactive button/checkbox for use in IWP?

I set this up in the database and it works beautifully with a graphic button, that when selected, adds the parameter to a global field and, conditionally formats the portal row. When clicked again, it removes the parameter from the global and reformats the field. It's beautiful. This obviously only works in the FM Client. I have a need for a layout using the same portal information to be accessed via IWP. Obviously, the conditional formatting will not work there. I have searched the forum for a manner in which to use a checkbox on the web layout, but have come up empty. (My concern, of course, is that the user can see which rows have been selected vs. which rows have not) I tried setting up a checkbox attached to a value list with only one value, and attaching a button with the same set field steps to that checkbox. However, the check box clears itself after adding data to the global field. And if a secondary checkbox is selected it over-writes the global field, rather than adding to it. Is there another way to add an interactive button/checkbox for use in IWP?

Thank you both for the suggestions. Søren, I think I am going to combine the data. I love the separation model you posted - that is indeed a very interesting tactic. I think I was keeping the data separated because of a belief that production information and accounting information need not exist in the same place for security reasons. However, there are enough security parameters in Filemaker that, I suppose, blows that concept out of the water. Plus the information was going to exist on the same server anyway. Again, thank you for the suggestions and the educational links.

It seemed cleaner to keep them as separated databases. One is an image database. The other is a financial database. How else would the Art Description be called onto a Worktag/Invoice if not by a lookup? No, the description does not change over time.

One database is an order entry system used for selling Art. The other database is used for cataloging the art. In the Order Entry screen, the user types in the artID, and the Description is then looked-up from the catalog of art. (This portion is also scripted from the customer's layout for easy re-ordering - which is primarily how it would be used in the IWP solution). The lookup, and subsequently, the "Calculated lookup" work fine in the Filemaker client, but not in the IWP Solution.

Ok, I have re-read and doubled back and checked everything. IWP access is definitely enabled for both databases. The user is not the default "Admin" account, but a userX account. The User does have full access rights, and also in the extended privileges the fmiwp and fmapp sets are enabled.

Not at all. The field in question is defined as a lookup and I am attaching a screenshot illustrating that fact.

Ok, so I registered for the Safari books and read the chapter and it still didn't exactly help... even if I force a commit record to happen after entering the information necessary for the lookup, the lookup does not happen. Again, all local lookups happen without issue. It is the lookup to the external data that is not happening.

Took me a few tries, but I figured out where they should be calculated from. Thanks for pointing me in the right direction.

Funny, I had seen this topic before posting, but did not see your response listed for some reason. Odd. Anyway, my local lookups are working great, it is simply the lookup to the external database. That's alot of exclamation points. I don't have that book in my library - I have "The Missing Manual."

Currently, the only user that is accessing it is me and I am signed on with full-access priveleges. And, not sure that it should matter or not, but it is the same user & password for both databases. Both databases are shared via IWP and filemaker network.

On a single host, I have two shared databases. Both of which are open and running. One of the databases has a value that looks up the related data from the other database. Within a filemaker client, the lookup works beautifully. If I try to call the same data, from IWP however, the lookup fails. Is there a way to force the remote lookup to work in IWP? (a script step, perhaps?)

OMG! That is gorgeous. Thank you!

Although, I prefer the other method because of the added flexibility it provides me. Thank you for this thought, however. I may integrate it into other areas of this or other solutions.

Well, now that we are past the holiday's, I am back attacking this project and this is the step I am hung up on currently. Is there a function that would be able to test if the string exists in the field - and then to add or remove depending on it's existence? I think I have figured out how to add it to the field, but definitely not how to remove it. And I have not found a similar topic on here - although I find the search feature on this site a bit clunky. Thanks, in advance.

I would think the only way to handle this would be with a script, as there is no way that I can see to add multiple values to a global field with any of the options in the button set-up. Am I correct? And, I'm confused, don't the global fields present the same issue that the checkboxes would if multiple sales people were logged in at the same time?

Ok, I think I now see exactly how the self join is supposed to work. Thank you for all your help on that. Why would I need to commit the record? I thought once the customerID field was committed, the lookup should work fine. Isn't the customerID field committed once the customer is selected from the drop-down box?

I guess you are right, I shouldn't need it. However, there is something not working quite the way we want it to with the calculation. If a line item was been ordered by two different customers, it will only display on the first customer's portal. Yes, thanks, I corrected that.

Thank you! That looks great, except the customer name is still not auto-populating in the lineItems Table. And, I don't see a reason that it wouldn't perform the lookup.

Ok... So, I think I am very close. Attached is an example.fp7 file. I have followed the examples found here for the "Ugo Method". I have two hiccups with what I have done. First, I added a lookup to the lineItems table to include CustomerName. That does not auto-populate on line-item creation for some reason (and the customerName has already been selected on the Invoice layout). Secondly, when I view the portal on the Customer's Line Items layout, it now displays blank lines for each time the product was ordered. Can someone take a look and tell me what I am doing wrong with both those issues. (and any other you may spot) : example.fp7.zip

For this, use, I am not in need of totals, simply a way in which I can see what line items have been ordered - and an easy way to select those line items and set-up a re-order.