snow

Hi Ugo, Thanks for your help. Your attached file really works well but I don't know why I did exactly as you did for my old file, it still doesn't work. I attach it now so that you can see the same file you corrected but it didn't work. I wonder where I made a mistake?? Thanks again Snow sample.zip

Hi Ugo, I put "set capture on" at start my script and it found all of names. I used the complicated way and it also showed all of names, not only the name I want. Is there something wrong in my script? Snow

I attach file now. It's another file but same fields and scripts. I couldn't search for Plant name and Title, only process type. I hope to get solution soon. Thanks again Snow sample.zip

Hi Ugo, It still appeared the eroor message "either can operator was omitted, this function cannot be found, or "(" was not expected here" and it marked the word 'is valid'so maybe something wrong there but I couldn't find out. I tried to space or changed something but it couldn't let me do it at all. As for that script I don't know why it works well that file but when I tried to do with the other one, it didn't work so I am confused a lot although they are same files but different time to make. I used the debug to check and I saw it appeared the name of Plant when performed enter find mode, set field ["name of he Plant", "search key name"] - New record/request. After that it disappeared when peroformed other set fields... then when it performed find [treplace found set], it said no records match this request. I am confused a lot although I checked the script, relationships and field names, types already. Do you know why I have this problem with another file again? Snow

Hi Ugo, Thanks for your help. It works now after I made 3 relationships. But I still don't know how to make 3 calculation. Could you explain it to me clearly? I made a field c_checkRel1Valididity then I copied Case(Is Valid(R1::Name of the Plant), "Valid","Not Valid")to put it into the box but it appeared the error message [either can operator was omitted, this function cannot be found, or "(" was not expected here]. How can I do that check now? This script worked well already but I like to learn about check calculation Could you show me how to do now? Snow

Thanks Paul and Ugo, "Name of the Plant", "Tiltle of Paper", and "Process type" are also text indexed fields. Yes, this produced any results when I do a search by hand after appeared the error message as I metioned above. I checked each field before using the script and it only worked with search key type. I also checked the field name but it didn't have any mistake. I don't use value list. Could you tell me why only one field can do this search? Thanks again. Snow

Hi everybody, I have a database and want to make a search layout with 3 global fields to search. - search key name - search key title - search key type They are global fields (text). I made a script to search: ------ Enter find mode [] Set field ["Name of the Plant", "search key name"] New record/request Set field ["Tiltle of Paper", "search key title"] New record/request Set field ["Process type", "search key type"] Perform find [replace found set] But I cannot find exactly name of the plant or title of paper I need when I typed in field "search key name" or in field "search key title". It showed the message "There are no valid criteria in this request. Type a valid request before clcking Find". I click continue and it showed other ones, not the name I wanted. For process type (search key type), it can show right name. My problem is I cannot search separately for name in 3 fields I want in the same file. Could you help me solve this problem? Thanks, Snow

Thanks for your help, Lee and Ugo. As for my problem, I need to make a record with some portals. These portals will depends on the field date (text). For exampple, A Water treatment plant has a database for their treatment. They want to update their database by new data every month or every running the treatment plant. Here is the description In Date field (text) I type: Run I, June 5, 2003 goes with 3 fields: Influent (location field) Effluent (location_1) Effluent_1 (location_2) I made 3 portals with different relationship to show separate record for each portal. In each portal, I put 3 related fields from their relationship portal_1 parameter value (text) unit portal_2 parameter_1 value_1 unit_1 (mg/l) portal_3 pararmeter_2 value_2 unit_2 What I need is to keep value of parameter for everytime I enter new data for every Effluent because it often has a same Influent but different Eflluent value. I also want to make a relationship between date field and new record for Eflluent so that I can enter new data for Effluent every month. How can I change or open a new empty effluent portal (portal_2 or portal_3) with empty place to enter value for parameter field and still keep the portal Influent by side with old value? I am sorry if I cannot write this clearly. Hope to get your help soon Snow

Thanks for your help, Ugo and Jager. I like all the answers because they help me solve the problem. I use field parameter as a popup menu including BOD, COD,....to choose the item for each parameter I have to enter the value. I don't need to write again their name on another portal for Eflluent. I can choose it then I only enter value. Unit is also linked with parameter by a list already. So I have to make a script like Jager said but I don't know how to make a script fot this case. Can you help me? I will meet my advisor tomorrow afternoon. Hope to hear from you soon Snow

Hi everybody, I would like to know how to link data I enter on a portal in a record with another record with the same fields and portal. For example: The first and second records have same: - 2 portals format with relationships water quality, water quality_1 - 2 Fields (parameter) format with popup menu using same value list (including some parameters like BOD, COD...) - 2 fields (value) using relationship water quality, water quality_1 - 2 fields (unit) using relationship water quality, water quality_1 These fields will distribute into 2 portals: Influent portal Effluent portal parameter value unit parameter value1 unit1 BOD BOD COD COD I want to link Influent portal with another record because I don't have to enter other data for it. I only change Effluent data like BOD, COD because they have different parameters for every experiment. I have to make other records for every experiment with same Influent but different Effluent so I want to keep Influent data and only enter data for Effluent. Could you help me solve this problem? Hope to get your help soon Snow

Ciao Ugo, I will do it again with a key then let you see if it works. So we have to put the field in the portal. I thought I only use the relationship in portalformat and it will show records from this relationship, no need to put field in the portal?? Thanks again and I will do it now Snow

Ciao Ugo, My portal will list a few related records from related databases but it depends on the popup menu of the field process type, too. I attach my files now so that you can understand what I need to do. I made 3 fields with popup menu in the layout Process type of the main file and one portal to show the related records. I attach that file now and hope you can solve and understand my problem. I don't know how to explain it exactly at all Buona notte Snow Database.zip

Hi Ugo, The 01, 02 are the codes of fields which my advisor wants me to understand which field is related to another one. Thanks for showing me these threads. I read many threads in portal section last night but I really don't understand much because I am new to use portal. Can you explain to me how to make a new "temporary key" for a new relationship temporary key ::related key in my case? I tried to make a relationship like that but it didn't work. I used the relationship for format portal (process_type key ::process_type key) but it cannot represent the related record (explanation) on the portal at all. I still don't understand here. can you help me be clear now? Snow

Dear all, I have a problem with the portal now. I want to show the "explanation" of a process from "Process" file on a portal of main file and I also want to show "images" of selected process from "Process" file if I click on the field "process type" with field format is popup menu in a "Main file". Here is the detail of database Main file: 01 Field to select process type to show basic information of the process or to show images of the process 02 Field to select process type to jump to data_input/data_browsing pages for the selected process. Process file: Explanation of each treatment process (Activated sludge, trickling filter...) 01-Process type (to be linked with 01 in Main file) 02- Explanation 03- Schematic diagram (images) How can I show the related records of explanation or images of the selected process (Process file) on a portal from Main file seperately if I click on the process type field to selec a process? I am confused with it and hope to get your help now. Thanks for helping me Snow

Dear Ugo, These buttons will go to the layout theory or treatment plants in datasource file depends on the choice field. Besides that, these buttons will go to related records of these layouts. I wonder if I can make separeated records in a layout and it will appear whenever I want to show by a script? Thans for your help! Snow

Dear Ugo, It works well now after I followed what you said.: Another situation is how to make a relationship between process buttons (AS, RBC, UASB) which I put a script for every process and the choice field above so that if I click on the choice 'theory' then I click on those buttons, it will appear every process (reord) on layout Theory and vice versa (Treatment Plants) in case I don't use button (script) on the field choice as you showed me how to do above. Do I have to make a script like choice script for every process button? Thanks a lot and i feel happy now. I can meet my advisor this morning without fear. Snow

Dear Ugo, It still returned to main file after I put the refresh step in the external script. I can only put the step pause/resume/duration 5 sec after the step go to layout theory in the script theory in datasource but it's not convenient because I have to wait for 5 seconds then it returned to main file right away. It's only a temporary way Can you show me another way to do? Will die because of script Thanks again Snow

Dear Ugo, Thanks for your help. I put a Refresh(back to front) at the end of the script but it returned to the main file right away after opening the layout I need to see. How can I stop the return to main file? Could you help me solve the problem? Thanks Snow

Dear Lee and Tom, Thanks for your help. I made a choice script in ScriptMaker using the Perform Script [External] (datasource file) and I chose the local script in datasource file [Theory (go to layout theory) for subscipt if and Treatment Plants (go to layout treatment plants)] for subscript if but it returned to main file when I perform the choice script. I don't know why. I attach the file again with hope you help me solve this problem. I cannot sleep at all. Thanks again Snow file.zip

Dear Dreese, Thanks for your help. Could you send me your files you edited already? I need to solve the problem soon to submit my advisor this morning and I only have 5 hours to finish it. I cannot go to bed at all. I tried to do as you showed but my heard is heavy now because of staying up too late (4 am already). My email address is st027359@ait.ac.th or you can attach those files on this forum if you feel it's inconvenient to send me email. I really want your help now. Thanks again Snow

Dear all, I have a problem with doing a script to open a selected layout from another file. I can only open another file, not a layout I want to open. For example I have a choice field in main file, and I use custom list in this field including theory, plant name and I want to open the related layout from another file (datasource file). Data file has 2 layout theory and plant layouts. I can open the data file but not the related layout at all. Can you help me solve this problem? I attach 2 files which I made some scripts but they cannot perform what I need is opening the layout I want in another file. Thanks and wait for your help. Snow myfile.zip

Thank to Lee and Ugo, I tried to find out how to do icon buttons. I found another website which shows us how to do icon buttons and we can download these buttons as Lee helped me to go there to download (I couldn't download buttons from that website but I can download them on this site. I don't know why ) Here is the address: http://home.hiwaay.net/~cullman/tutorial.shtml I also attach that website for who wants to know. Thank Lee and Ugo helped me solve my problem. Snow

Thanks, Ugo. I don't know why I cannot download it at all although I do it exactly like Lee and you said. It always says "The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings." I tried again to download it this morning but it didn't work. Are there other websites to download those tips about how to make icon buttons? Snow

I can get a big file (about 9 MB) here because my school uses cable to connect the internet and they give me about 20 MB for my mailbox. But I also send a email to that website with hope they can solve my problem and I can get their files. I still wonder the way to make a button with the icon on it. Is it I insert an icon on the layout then I will make a button and send the button back so that the icon can be on the button like they did on Menu? Can you explain it to me? Thanks Snow

Oh, so you can download the 1000 Buttons file. Yes, it's the first file listed. I tried to dowload it again now but it didn't work. Maybe there is a problem with my ISP or my browser setup but I can download files on other websites. Can you send that file to my email st027359@ait.ac.th ? I need to read it to know how it works. Thanks again Snow