mfl

That worked Comment. Thank you.

According to the error message I am not permitted to upload this kind of file. Tried using the advanced and basic uploader but neither will let me. Tried uploading a screen shot but that fails also.

Hey all, I am trying to export FM data to an excel or CSV file but the result isn't coming out like I would like it to. The data is Program/Style/Color, a program can have multiple styles, styles can have multiple colors. What I want is to have an excel or csv list of the above but what i am getting is... ProgramA - Style1 - Color1 BLANK - Style2 - Color2 BLANK - BLANK - Color2,2 ProgramB - Style1 - Color1 BLANK - BLANK - Color2 The export function is not filling up all the cells. Can this be corrected or is this a FM fail? Thanks Michael

We have a table "Fabric Library" which contains all the fabrics we use and their associated details like Content, Properties, Mill and Coding info. This detail info is specific to each entry in the library and is not supposed to be changed if it is being used in a style. Despite the fact that we have a portal that shows if the fabric is being used and which style it is being used in we are running into situations where data is being changed. I can lock down the field if the user is not an authorized user but this means that I have to do it field by field but I would rather lock a layout.

Hope this is possible. I have a layout with a bunch of fields and I need to be able to lock the fields so they can't be modified. Can this be done with the script trigger OnLayoutEnter using a field from the table that if > than blank lock the fields, or do I have to do this field by field. Thanks

Thanks comment worked like a charm.

Sorry, probably should have worded that differently. What I need for this value list to show is all records from the MeasurementChart_Defaults_List_Gender_Customer except any charts that are designated "Retired" in the default list regardless of relationship to MeasurementChart.

No its give me everything from MeasurementChart_Defaults_List_Gender_Customer except any charts that are designated "Retired" in the default list regardless of relationship to MeasurementChart. I've already been pointed to the ExecuteSQL as a solution and I am looking into this but I don't have the time slice right now to implement this.

I have a table relationship between..... MeasurementChart and (TO) MeasurementChart_Defaults_List_Gender_Customer MC_STYLE_GENDER = MCDL_GENDER and MC_ID_CUSTOMER = MCDL_CUSTOMER_CODE and MC_WORD_RETIRED != MCDL_USAGE MC_WORD_RETIRED will always have "Retired" as a value, automatically entered when user creates a measurement chart. MCDL_USAGE can either have "Retired", "Current", or be blank. My drop down value list is located on 2 layouts which are based on MeasurementChart. The value list itself is based on the Defaults list and is set to "Include all Values" and "Show only values from second field". My question is does the "Include all Values" override the relationship because currently the drop down brings in all records from the default list regardless of what MCDL_USAGE has for a value. My other question is how do I make the value list display only the non-retired records? Thanks

Well you were correct about the explanation part. I get the SQL part, it's when I get to the Filemaker part thats where I get lost. What gets setup where etc. Unfortunately time being what it is I'm not going to be able to work through this. Thanks for the suggestion will have to take some time to work on it.

No they want to see all the records in the default table except for the ones that are designated "Retired". Right now the drop down value list is bringing in everything including "Retired".

Matty, Sorry should have clarified a bit more. There is a field in the Default table called MCDL_Usage. Normally its set to Current when the chart is created but the user can set to Retired. Now when a user creates a new measurement chart it puts "Retired" in a field called MC_Word_Retired in the MeasurementChart table right away. In the relationship between MeasurementChart and the MeasurementChart_Defaults_list..... it "sorts" out where MC_WORD_RETIRED != MCDL_USAGE. Seems that this relationship doesn't play a roll in the drop down value list which is set to include all values.

Environment MAC 10.6 with FMPA 12.0v2 I have a situation that works but needs to be refined because its not doing what the user requires. It starts out at style development where a user creates measurement charts for various stages of garment development. The layout(Enter New Chart Name) to create a new chart has 2 drop downs where the user selects a default measurement chart depending on size range and gender. The CUSTOMER drop down should display customer specific charts and the ALL CHARTS needs to display all charts minus ones that are designated RETIRED in the default chart. The default measurement chart table is actually a TO from another DB. Both MeasurementChart and MeasurementChart_Defaults_List_Gender_Customer(TO) exist in the STYLES_MAIN DB. The ALL Charts is tied to a value list which is set to include all values from the default list and this is where the problem is. Obviously I can't make the value list only select non retired records. My other thought was to create a small layout with a portal filtering out any retired records. Is there any other way that I can display all records except retired ones for the user to select. I have included screen shots of the overall relationship between STYLE_MAIN, MeasurementChart, MeasurementChart Default..... The Value list setup and the Enter New Chart name layout. Hope someone can decipher what I trying to fix here. Thanks

Thanks dansmith65 worked like a charm

Hello, Would like to know if it is possible to copy the conditional formatting of one field and apply it to another field or do I have to do each field separately? The situation is I have a layout that has 4 columns of portals each having 12 rows. The same type of info is displayed in each column/row. One field has conditional formatting applied to it which changes the color depending on the content of the field. I would like not to have to manually apply the CF to each column field as there are 7 tabs that need to be modified and there are 16 CF conditions that need to be applied. Thank you Michael

Comment, Works, thank you.

Comment, What I am trying to achieve is that if the ReviseDate set is within 7 days prior to reaching PlanDate and less than PlanDate the field goes yellow, alerting the user. I have another conditional formatting calc that turns the field red when plan date is reached and/or passed. All fields are defined as date.

I have this conditional formating calc. (ProcessTracking::P10ReviseDate >= ProcessTracking::P10PlanDate &#8211; 7) and (ProcessTracking::P10ReviseDate < ProcessTracking::P10PlanDate) The complaint is with the "P10PlanDate - 7", how do I subtract days from a field. In a previous iteration which was doing the wrong thing but worked was...... (ProcessTracking::P10ReviseDate > Get ( CurrentDate )) and (ProcessTracking::P10ReviseDate &#8804; Get ( CurrentDate ) + 7) Thanks Michael

I'm stuck. I am trying to parse part of a field into another field via calculation. I used Position() which gave me the position of first blank which is correct, but now I want to place everything after that into my second field. First field "Product_CodeDesc" contains - "MCD01234 some description" The first 7 chars will never change in length. Second field is my calc field that should hold the description part. What function do I put the Position() statement in to retrieve the description section. Thanks Michael

Vaughan, No its not just a regular DB.

Hello, I need some clarification on layout search option. We have a layout where the user has an option to search all fields on the layout by the click of a button except for one. All the fields have a value list behind it referencing the field itself. The user would like this option for the one field that isn't search enabled. The only difference between this field and the other ones is that it is Indexed, Unique. Is it not possible to setup a value list on this field for search purposes. I have already tried, it let me setup the value list on the field but when I go back to browser and then search its like no change was made.

Well the table contains 124 fields. That being said of those 38 are repeating at "50" In my defense I didn't design this system. Should add that the reason for this is that I am trying to setup SyncDek and I am having field validation errors when it tries to update my test side. I need to look at all fields and see if there are issues with data. Creating multiple layouts would be the only other way I can think of to display all fields.

Is there a max number of columns that a table view will display. Thanks Michael

I have this script which currently performs finds and downloads an excel report for the user. My question is in the Perform find can I send it a variable as the user now wants to select specific Vendors. Or is there another way of doing this. Allow User Abort [ Off ] Set Error Capture [ On ] Freeze Window If [ Purchase Orders::PO_ExcelCount = "" ] Set Field [ Purchase Orders::PO_ExcelCount; Purchase Orders::PO_ExcelCount + 1 ] End If If [ Get ( ScriptParameter ) = "Exit Open Production" ] Set Variable [ $desktop; Value:"filemac:" & Get ( DesktopPath ) & "PO Exit Date Report" & Purchase Orders::PO_ExcelCount & ".xls" ] Perform Find [ Specified Find Requests: Find Records; Criteria: Purchase Orders::PO_Type: “Production” Omit Records; Criteria: Purchase Orders::PO_Open_Closed: “Closed” Omit Records; Criteria: Purchase Orders::PO_Status_Req_Or_PO: “DELETED” ] [ Restore ] Sort Records [ Specified Sort Order: Purchase Orders::PO_Date_Exit_Beginning; ascending ] [ Restore; No dialog ] Export Records [ File Name: “$desktop”; Use field names as column names; Character Set: “Unicode (UTF-16)”; Field Order: Programs::Program_ID_ProgramNumberWithName Programs::Program_Date_Event Programs::Program_Contact_Mondetta_Customer_Service Purchase Orders::PO_Supplier Programs::Program_Contact_Mondetta_Salesman Programs::Program_Contact_Mondetta_Merchandiser PO Data Per PO::POD_MondettaOr# PO Data Per PO::POD_ClientPo# PO Data Per PO::POD_Style_Num PO Data Per PO::POD_Description PO Data Per PO::POD_Cut_Ticket_Number PO Data Per PO::POD_Quantity Purchase Orders::PO_Ship_To_Address_Used Purchase Orders::PO_FOBorLDP Purchase Orders::PO_Ship_Via Purchase Orders::PO_Airing Purchase Orders::PO_Consignee Purchase Orders::PO_FreightForwarder Purchase Orders::PO_Broker Purchase Orders::PO_PortOfLoading Purchase Orders::PO_Date_Exit_Beginning Purchase Orders::PO_Date_Exit_End Purchase Orders::PO_Date_Exit_Cancel Purchase Orders::PO_DischargePort Purchase Orders::PO_Date_DelProposed PO Data Per PO::POD_PickTick# PO Data Per PO::POD_Invoice# PO Data Per PO::POD_SupInv# PO Data Per PO::POD_InvUnits Purchase Orders::PO_StatusDescription Purchase Orders::PO_StatusModDate Purchase Orders::PO_ID_Purchase_Order_Number_Production Production_Vendors_Bill_To::PV_Company_Name ] [ No dialog ] End If If [ Get ( ScriptParameter ) = "Del Open Production" ] Set Variable [ $desktop; Value:"filemac:" & Get ( DesktopPath ) & "PO Delivery Date Report" & Purchase Orders::PO_ExcelCount & ".xls" ] Perform Find [ Specified Find Requests: Find Records; Criteria: Purchase Orders::PO_Type: “Production” Omit Records; Criteria: Purchase Orders::PO_Open_Closed: “Closed” Omit Records; Criteria: Purchase Orders::PO_Status_Req_Or_PO: “DELETED” ] [ Restore ] Sort Records [ Specified Sort Order: Purchase Orders::PO_Date_DelProposed; ascending ] [ Restore; No dialog ] Export Records [ File Name: “$desktop”; Use field names as column names; Character Set: “Unicode (UTF-16)”; Field Order: Programs::Program_ID_ProgramNumberWithName Programs::Program_Date_Event Programs::Program_Contact_Mondetta_Customer_Service Purchase Orders::PO_Supplier Programs::Program_Contact_Mondetta_Salesman Programs::Program_Contact_Mondetta_Merchandiser PO Data Per PO::POD_MondettaOr# PO Data Per PO::POD_ClientPo# PO Data Per PO::POD_Style_Num DecemberP2O0,D2a0t1a0P1e5r:P33O::2:P5OD_DescrPiputricohnase Orders.fp7 - E:020 > UpLoad Open Production -1- PO Data Per PO::POD_Cut_Ticket_Number PO Data Per PO::POD_Quantity Purchase Orders::PO_Ship_To_Address_Used Purchase Orders::PO_FOBorLDP Purchase Orders::PO_Ship_Via Programs::Program_Date_Event Programs::Program_Contact_Mondetta_Customer_Service Purchase Orders::PO_Supplier Programs::Program_Contact_Mondetta_Salesman Programs::Program_Contact_Mondetta_Merchandiser E: Import / Export: E:020 > UpLoad Open Production PO Data Per PO::POD_MondettaOr# PO Data Per PO::POD_ClientPo# PO Data Per PO::POD_Style_Num PO Data Per PO::POD_Description PO Data Per PO::POD_Cut_Ticket_Number PO Data Per PO::POD_Quantity Purchase Orders::PO_Ship_To_Address_Used Purchase Orders::PO_FOBorLDP Purchase Orders::PO_Ship_Via Purchase Orders::PO_Airing Purchase Orders::PO_Consignee Purchase Orders::PO_FreightForwarder Purchase Orders::PO_Broker Purchase Orders::PO_PortOfLoading Purchase Orders::PO_Date_Exit_Beginning Purchase Orders::PO_Date_Exit_End Purchase Orders::PO_Date_Exit_Cancel Purchase Orders::PO_DischargePort Purchase Orders::PO_Date_DelProposed PO Data Per PO::POD_PickTick# PO Data Per PO::POD_Invoice# PO Data Per PO::POD_SupInv# PO Data Per PO::POD_InvUnits Purchase Orders::PO_StatusDescription Purchase Orders::PO_StatusModDate Purchase Orders::PO_ID_Purchase_Order_Number_Production ] [ No dialog ] End If Set Field [ Purchase Orders::PO_ExcelCount; Purchase Orders::PO_ExcelCount + 1 ] Show Custom Dialog [ Message: "Your Download is complete and located on your desktop."; Buttons: “OK”, “Cancel” ] Thanks Michael

DOH. Man do I need some sleep. Thanks bcooney, Vaughn.