GregInChrist

I can not guarantee either. To maybe better phrase my question... Because I do not know that the fields will be filled or not contain carriage returns, is the solution I found above the simplest(or best) or would there be a better(simpler) way to handle this. From what I gather the solution I found above will work but it might be overly complex? Again I cannot rely on the data being filled in (though it should be) nor can I guarantee the data does not contain carriage returns, that is unless I run each field through some other functions to account for them. Knowing this, what do you suggest?

Office people want it to be duplicated. I currently have it related. Short answer is they want it that way. They pay my salary Does the script that I posted in my second post above suffice or would you recommend something different? I can add a table occurrence. I assume permissions still managed in the other file?

Still need help. I can only pass one variable between files. I knew that was going to come up. Any ideas? Also sorry for having a conversation with myself here!

If i understand the following correctly this is what I am looking for. This looks like a solution that is similar to my comment above "If it were not terrible difficult to do I would almost like to capture all the records data in the PlateMaterial side and save them as a C struct so to say." Can any one confirm that I am on the right track. I think this is what I am looking for. If I do not hear back from anyone I will test it with display dialogs rather than writing to the new records. I will follow up if this worked for me. http://www.filemakertoday.com/com/showthread.php/29288-Copy-Data-Between-Tables-in-Script Short answer to your question, version 2: loop through the found set, setting one $variable for each field to itself & Left ("¶", Length ($variable)) & YourTable::ThatField, for each such variable. So that you end up with each $variable containing a stack of values, with a hard return between each value. Then go to the layout of the other table, set a pointer $variable (let's call it $Pos) to 1 and start a new loop, making new blank records, then setting each field in this other table to GetValue ($theAppropriateVariable; $Pos) then incrementing $Pos to $Pos + 1, with an Exit Loop condition: Exit Loop If [GetAsNumber ($Pos) > ValueCount ($OneOfYourStackVariables)

I am looking for the cleanest way to duplicate a given number of sub records from one table records from table into a different table. As an overview Order table is related to PlateMaterial table and PO table. The PO table is in a different file. The PO table has related records in a table called lineItems. I am being asked to script automatic POs that are populated from the records in PlateMaterial. They should function as a look up and duplicate the data. So from the perspective of Order. User presses a button and all related PlateMaterial records are used to create line items on a new PO. I need to know the best practice for handling this. My RUFF code translation MyScript(){ Create Record in PO Table; Set PO ID to var; Open new window with all related records of PlateMaterial Loop for each item in found set{ Set fields to vars; Open PO Line Items; Create Record; Set fields to var data including PO ID for relationship; Close PO Window; } } I am concerned this will be slow from opening and closing windows in different files. I am also concerned that it will be a pain passing multiple values as a list between the two files. If it were not terrible difficult to do I would almost like to capture all the records data in the PlateMaterial side and save them as a C struct so to say. From my experience Filemaker does a pretty poor job of parsing out lists of variables easily. Hope I made my intention clear. Please let me know if it looks like I am reinventing the wheel, if there is some function that does what I am looking for already. Thanks sincerely for your help!

I have seen some videos around that show FMP having the ability to drag and drop items in a list or probably rather a portal. I have heard it can be done without any extra table occurrence and with just a single script. However I can't find the scripts anywhere. Is this just someone trying to get me to buy into a subscription?!?!?! Here is one video I found, the video just says I need to buy a subscription under the video is a link to the sample video not full instructions. Is this legit? Do I need to buy the video or is there a tutorial someone can point me to? http://www.filemakermagazine.com/videos/portal-row-reordering-using-drag-drop Thanks!

I am transforming our solution to include tracking of time and materials and a communication log. I have these tables created. I need however to allow my standard users (rather then managers) to be able to enter(create a record) in the time and materials table but not be able to modify them after they have been entered. The same with the communication log. We do want standard users deleting or modifying data at a later point in time. I am thinking to use script triggers on a layout to restrict modification. Maybe if the field has a value, revert the field. Unless there is a better way, maybe through the security settings? Do you think I am going about this the right way? Thanks!

I'll take that as a no...

Is there anything special needed to delete a portal row via IWP? Putting a button in the portal row with the delete portal row script step works via the client but not in IWP. I also tried capturing the portal row index number and telling the portal to delete a specific row number. Both work in the FMP client but not IWP. Any Ideas? Thanks, Greg.

I am looking to implement a a flag that would indicate if any records meet a particular criteria. In the header of a layout I would text to show up red if any record in the table has field1 with a value of "myValue" The idea is that any record that was created by a particular user will be scripted to set field1 with the value of "myValue". I want a flag to show up for a higher level operator to review that record. // Just to express clearly I do not want the flag to only show up on a record that said user has created, but rather a flag to show up on every record to indicated there is a new record somewhere that the higher skilled operator needs to review. The operator will be able to search field1 for "myValue" or a button can perform the search and the operator will change the value to remove the flag. Is this possible with basic conditional formatting or do I need a more elaborate setup? Thank you in advance, Greg.

I think I found the issue. The same field is on the layout more than once. It looks like only the field that was placed on the page last works. I tested this by duplicating a field that worked. It then stops working and the newer field works. Then I repeat the same thing duplicating the newer field that is working. It stops working and then newest one works. Is this a known issue and is there a solution other then only having the field once on the layout?

Some fields on a layout in iwp will not save the information, other fields work. They are all enabled to be editable in browse mode. I have a button with a commit record/request script step tied to it. Permissions schema is to allow view and modify on all tables, view layout is enabled for the layout I am working with and modify records is enabled for the layout I am working with. All fields let me type data into them or modify the data in them but when I hit the commit records/request button I created some of them do not update. The fields that do not work are both from the same table that the layout is associated with and from related tables. Same with fields that work some are from the same table the layout is associated with and others are not. (I hope that makes sense) Any ideas?

The value is not entered by the user but entered automatically by a script. I copied the field options. You can see field options below. 1. field options 2. Auto Enter Options 3. Validation Options

I have not fully traced out what the original developer has going on. The auto enter is not done in the field definition. This is preformed by a script. It puts build the current two digit year, two digit month, two digit day, and two digit job of the day beginning with 01(job of the day). It is a text field The validation is just not allowing users to modify on entry.

I have a field with unique values which are our job numbers. When I search for a value 12101206 in a field called jobNumber, my result brings up 12081707 and 12101206 in my found set. If I do a search for 12081707 is says no records found. The field options are as follows... Indexed, Auto-enter Data, Can't Modified Auto, Always Validate I don't even know what I should ask here. When I perform the search it is bringing up a record with a different value then what I searched for. Any ideas?

It was not the same question. That's why I made a new post. Kinda crappy! My first question was can you commit a user entered search with IWP without the status bar visible. I just found the answer, Create a button to preform find, I did not realize button's could be used in browse mode. So that's answered. My second question, which is different, is can you disable only certain functions of the status bar (specifically in IWP), rather then just hiding and locking the whole bar itself. Please read posts before deleting them. Thanks!

Is there any way to have a user commit a search in IWP if I have locked and hidden my status bar? I want to create a button that would allow them to put in some search criteria but when they submit the search it would include criteria I have added forcing them to only see data related to their company. What that best solution?

Thanks, Hope I did not have any of those in my database.

Not sure if your trying to be sarcastic. No, I don't think they are trying to mislead me. How ever their documentation does not state that it updates script references. It only emphatically states "When you change a field name, FileMaker Pro changes the name on each layout and any field references used in calculation or summary fields." I was not aware if the term "calculation" was referring to all scripts or calculations in calculated field. Anyway, To anyone who might be as stupid as me. I found they answer elsewhere... It is safe to update field names, FMP is smart enough to update all necessary references within your database. Thanks for the help.

I am working on a database that has fields named with bullet points in the names. I see that FMP will update "each layout and any field references used in calculation or summary fields" per this link Filemaker Help. I want to make sure I am not going to break any scripts if I update the field names. Can anyone assure me that FMP will update the field names in any scripts that may access or write to said fields? I could ask rather is there anything that is not updated when a field name is changed in the define database dialog? Thanks in advance!

Thanks, I'll have a look. I understand it is potentially dangerous. Thanks for the warning!

Is it possible to populate a field in every record that shows up in a portal with data from a different field. I don't know that I need to constrain to just the records showing in a portal but at least to just the associated records of the parent. Like a portal showing tasks in a todo list for a single user and you want to set a field on each record in the portal to complete. Not completely necessary at this point but I would also like to be able to use this same technique if I am viewing a portal that show a limited criteria say tasks created before 2 weeks ago. In this example I would want the functionality to only change the records being displayed in the portal. I am guessing I should try to accomplish the later so I am not stuck reworking the problem when I come to it later. Is this something anyone else has done or seen?

Does anyone know the precedence of the the OSX print dialog's saved print configuration settings (IE. "last used" or "custom saved print presets") vs. print setting in FMP print script step? I am setting up "print setup" and "print" script steps however it seems some settings are still followed by OSX setting such as two sided. Anyone have any experience with this? Thanks,<redacted>

Webko and Aussie John, Thanks for the help!

I am not sure what this feature is called. I don't know how I ever found it to begin with. If I use the normal text tool on a layout and enter // I get a date when I print the layout. If I enter ## I get a page number. Is there a list of these functions? And specifically is there a time stamp like the date stamp? Thanks in advance, May the Lord Jesus Christ bless you unto salvation through faith in his work on the cross, Greg!