Bones Posted March 23, 2005 Share Posted March 23, 2005 Thank you in advance for bearing with a few questions from this "Trial User" of Filemaker Pro. Thus far, the program is very impressive. I successfully transfered a few of my past databases over (from Paradox). I understand that with any program, you can't have everything, but here are my initial questions: -Copy/paste functions seem limited. I often like to append new records to the database by using Copy/Paste functions. Often this is just entered into the first column, transfered by Clipboard from another program. For example, select a column of data from say an Excel file and paste it into a column in Filemaker Pro. I cannot get Filemaker to append records to a database like this. Any thoughts. -I cannot find the Filemaker Pro equilavent of the Ctrl-D. command. In most programs, Ctrl-D copies the field above into the selected field below. Continued successions of Ctrl-D combined with the down arrow allows you to copy the same data field-to-field down the same column. Filemaker Pro seems to only respond (rather slowly) to drag and drop. Any thoughts? Thank you! Link to comment Share on other sites More sharing options...
Maarten Witberg Posted March 23, 2005 Share Posted March 23, 2005 Hi, Q1: this can be achieved using the import function. Q2: this can be scripted. Do you want to copy field values to another field in the same record, or from a field in one record to a corresponding field in the next record? kjoe Link to comment Share on other sites More sharing options...
Bones Posted March 23, 2005 Author Share Posted March 23, 2005 [ QUOTE ] Hi, Q2: this can be scripted. Do you want to copy field values to another field in the same record, or from a field in one record to a corresponding field in the next record? kjoe [/ QUOTE ] Yes...from a field in one record to the same field in the next record(s). Link to comment Share on other sites More sharing options...
Maarten Witberg Posted March 23, 2005 Share Posted March 23, 2005 Hi, see sample. the scripts are under button but also available from ctrl-1 and ctrl-2. kjoe Link to comment Share on other sites More sharing options...
Ender Posted March 23, 2005 Share Posted March 23, 2005 Hey kjoe, Happy 1000! Link to comment Share on other sites More sharing options...
Maarten Witberg Posted March 23, 2005 Share Posted March 23, 2005 Hi Ender, I just popped a cork to celebrate and toasted my computer screen...it just looked impassive untill I read your post....thanks And happy moderating to you sir! (that is recent isn't it?) kjoe Link to comment Share on other sites More sharing options...
Ender Posted March 23, 2005 Share Posted March 23, 2005 Yes, just had my coronation today. I suppose now I'll have to be 'polite' and 'responsible' in my posts. To set a good example. Link to comment Share on other sites More sharing options...
Maarten Witberg Posted March 23, 2005 Share Posted March 23, 2005 Have you ever been impolite and/or irresponsible? I think not! So you'll have no trouble is my guess... kjoe ps Bones: your answer is up there, in case you got lost! Link to comment Share on other sites More sharing options...
Bones Posted March 24, 2005 Author Share Posted March 24, 2005 Can someone send me a calculation formuila for a DATE field that will allow me to add 40 years to another date that is derived from another DATE field? Thanks. Link to comment Share on other sites More sharing options...
comment Posted March 24, 2005 Share Posted March 24, 2005 Date ( Month ( datefield ) ; Day ( datefield ) ; Year ( datefield ) + 40 ) Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.