FMAsker Posted April 6, 2003 Share Posted April 6, 2003 Hello everybody who read this message. I would like to ask when I make a new record can FileMaker transfer the data from the first two fields to another layout which have a table like excel tables and put it on the correct row and column??? Furthermore how can I make a table or imports a table from excel and FileMaker Link to comment Share on other sites More sharing options...
CobaltSky Posted April 6, 2003 Share Posted April 6, 2003 If both the layouts you want to display the data on are in the same file, then one solution may be to simply include the two fields at the appropriate locations on both layouts. However if your solution requires that the data be moved to a different location in order to appear on the table layout, two other options you might consider would be: 1. Setting up the fields which are to receive the data as auto-entry (by calcultation) fields to copy the contents of the two fields in the new record, or 2. Establishing a script which writes the contents of the two fields to the alternative location. And as regards the data from Excel, you will find that FMP has an import option especially designed for importing data directly from Excel files. However there is an even easier option - you can simply open an excel file using FMP and it will be converted straight away into a FileMaker table. Each of the worksheets in an excel file can be opened separately, so that multiple worksheets can be efficiently converted into multiple FMP files. Once the files are in FMP format, it should not be too difficult to set up relationhss between them in the noremal way, using the FM Define Relationships command from the File menu. Link to comment Share on other sites More sharing options...
FMAsker Posted April 7, 2003 Author Share Posted April 7, 2003 I am sorry but i am begginer so my questions seem childish.Can you explain me "to display the data on are in the same file"? You mean to display the data to the same database or a new database ? In addition when you say the "data moved to a different location" what did you mean ? Can you give an example ? I must write a script to make all this ? I would be greteful if you give me your solution. Link to comment Share on other sites More sharing options...
danjacoby Posted April 7, 2003 Share Posted April 7, 2003 when I make a new record can FileMaker transfer the data from the first two fields to another layout YES. Fields are fields, and they will display the same information regardless of which layout you are in. You can create separate layouts to display different information, or the same information in a different way. which have a table like excel tables and put it on the correct row and column You can view any layout as a Table, or you can set up a Columnar List layout, which is usually more flexible. As far as importing Excel tables, just drag the icon for the Excel document over the icon for Filemaker Pro, and it will create a new Filemaker document for you. Link to comment Share on other sites More sharing options...
CobaltSky Posted April 7, 2003 Share Posted April 7, 2003 Hi, In your original question, you asked about "transfering data from the first two fields to another layout". In FileMaker, a file can have many layouts, and each may have a selection of fields from the database on it. However FileMaker is also relational, and that means that you can have several files, with data from each being shared with the others. In your original question, you did not clarify whether the layout you wanted to transfer data to was another layout in the same file, or a layout within another FileMaker file. If it was in the same file, then the answer is simple - you can include fields on more than one layout in the same file, so when the data is entered in one it will automatically appear in the other also. However if you want the data moved to different fields (whether in the same file or another file) then that could be achieved in a different way. One way to do that would be with a script. However I can't 'give you a solution' without knowing exactly what it is you are trying to do. Link to comment Share on other sites More sharing options...
FMAsker Posted April 8, 2003 Author Share Posted April 8, 2003 Layout #1 Name:_____________________| Last Name:________________| Work as :|X| Employer (Check box) Complete these fields for example John B... and after these must transfer to layout #2 to the right column and row Layout #2 ___________|Unemployed_____|Employer_____|_______________ Name:______|_______________|John_________|_______________| Last Name:_|_______________|B..._________|_______________| Do you understand what i tried to make ? I tried to express my opinion with pictures to understand me... Can you give me a solution ? Thank you very much Link to comment Share on other sites More sharing options...
danjacoby Posted April 8, 2003 Share Posted April 8, 2003 Nope. No clue. Oh, wait! Do you want to create a table in another layout showing which "column" a person belongs in? Yeah, you can, but you can only show one person in the table. That's silly. A simple list layout, showing FirstName, LastName, WorkAs, and any other fields you want, will allow you to see all the data for all records. Then you can sort by, say, the "WorkAs" field to combine all the "Unemployed", "Employer", etc. Link to comment Share on other sites More sharing options...
CobaltSky Posted April 9, 2003 Share Posted April 9, 2003 Hi FMAsker, If I understand you correctly, you want to display the names in columns, with the name for each record appearing in the column(s) which corresponds to the selection(s) in the 'Word as:' field? If that is correct then you can achieve it relatively easily by creating a calculating key field which concatenates the Work As field values with the recordID plus a corresponding unstored calc for each column, then establishing a self-join relationship for each column which matches its unstored calc to the Work As key field. The fields in each column would then have to be sourced via the appropriate relationship in order to ensure that the names in the list report appear in the correct places. It sounds a bit more complex than it is. To show you what I mean I have attached a small demo file which has a working model of the technique. NameLists.zip Link to comment Share on other sites More sharing options...
FMAsker Posted April 14, 2003 Author Share Posted April 14, 2003 I will work with this solution and i will tell you my news. Maybe this way make my job easily. Thank you very much about all. I appreciate that. Link to comment Share on other sites More sharing options...
FMAsker Posted April 18, 2003 Author Share Posted April 18, 2003 Hello guys, GobaltSky your attachment is wonderful but can i ask you something. I want to work with that way but i want to have more fields not only employed and unemployed. But when i put some more there problems like the check boxes are not work property and list layout do not appear correctly. Also when i make a new record the listlayout appears a new table so can we make table when i make a new record do not appear a new one following the previous one but make bigger all the changes in one table. Do you understand me ? Maybe it is more difficult but anyway thank you in advance and appreciate your try. Link to comment Share on other sites More sharing options...
CobaltSky Posted April 18, 2003 Share Posted April 18, 2003 Attached is a new example. If I understand you correctly, perhaps it is closer to what you are looking for? columns2.zip Link to comment Share on other sites More sharing options...
FMAsker Posted April 19, 2003 Author Share Posted April 19, 2003 Yes exacly but my problem is not in collumns but in the rows. So i want to have many collumns like your last attachment but and rows. So the database go the data from the fields to the right column and row. Furthermore when i try to put more the names appear in more than one column. Do you understand ? thank you Link to comment Share on other sites More sharing options...
CobaltSky Posted April 19, 2003 Share Posted April 19, 2003 I'm afraid your question remains unclear. like your last attachment but and rows. Like this for instance. Phrases such as 'but and rows' are rather difficult to interpret... So the database go the data from the fields to the right column and row. I gather that the data must be displayed in the correct column and row, but you haven't said anything to indicate how the appropriate row can be determined. Furthermore when i try to put more the names appear in more than one column. With the sample I posted, the only way to make the names appear in more than one column, is to select more than one checkbox for a particular name - or to enter the name on more than one record. If you want names to appear in only one column, then only one checkbox should be selected - in which case, it would make more sense to use radio-buttons rather than checkboxes. Moreover, if you only wnat names to appear once, why enter them more than once - it doesn't seem to make sense?! The reason the samples are set up with checkboxes, however, is because you explicitly said that you required checkboxes in your original post. I daresay that whatever it is you are trying to do can be done with FileMaker - perhaps without too much difficulty - FileMaker is that sort of application. But if you want more precise answers from the forum, you may have to take the time to properly explain what it is you want. Link to comment Share on other sites More sharing options...
Lee Smith Posted April 19, 2003 Share Posted April 19, 2003 I daresay that whatever it is you are trying to do can be done with FileMaker - perhaps without too much difficulty - FileMaker is that sort of application. But if you want more precise answers from the forum, you may have to take the time to properly explain what it is you want. Boy is this an understatement. Congratulations Bob for your patients and thanks for the file. Link to comment Share on other sites More sharing options...
FMAsker Posted April 20, 2003 Author Share Posted April 20, 2003 Thank you, I will tell you my answer soon Thanks everybody for help. Link to comment Share on other sites More sharing options...
FMAsker Posted April 24, 2003 Author Share Posted April 24, 2003 Thank you guys, your example is great. But can i ask you something else. I have a StartDate and EndDate so I want to make a field and every time who open my database this tell me who i am waiting today. So make a compare the current date with one of my booking dates. Is it possible? Thank you very much for all. Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 24, 2003 Share Posted April 24, 2003 Hi FMAsker, It seems to me you should add a link to the post where you already asked for that solution, if you want Ray (and all of us) to keep patient and give an eye. Again, congratulations for your attachement Ray By curiosity, I would also love to have an answer on this one, so here is the link thread unsolved I'll ask another kind remark. If you want anybody to help you out, please provide your real problem at first. I don't see any "relation" from the employed/unemployed sample you asked for here and your Hotel Rooms reservation (if it's finally a Room reservation you're looking for ...) Link to comment Share on other sites More sharing options...
CobaltSky Posted April 25, 2003 Share Posted April 25, 2003 As Ugo has noted, this question has a lot in common with a question you've already had a couple of dozen responses to on another thread: A Little Help About Dates...Please? Because it seems to relate to the booking system issue discussed on that thread, I have placed a response there for you. It is at the above link. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7835 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now