Jump to content
Sign in to follow this  
Bones

Trial User - w/Database Exp/My intial questions

Recommended Posts

Bones

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!

Share this post


Link to post
Share on other sites
Maarten Witberg

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

Share this post


Link to post
Share on other sites
Bones

[ 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).

Share this post


Link to post
Share on other sites
Maarten Witberg

Hi,

 

see sample. the scripts are under button but also available from ctrl-1 and ctrl-2.

 

kjoe

Share this post


Link to post
Share on other sites
Ender

Hey kjoe,

 

Happy 1000!

Share this post


Link to post
Share on other sites
Maarten Witberg

Hi Ender,

 

I just popped a cork to celebrate and toasted my computer screen...it just looked impassive untill I read your post....thanks laugh.gif

 

And happy moderating to you sir! (that is recent isn't it?)

 

kjoe

Share this post


Link to post
Share on other sites
Ender

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. tongue.gif

Share this post


Link to post
Share on other sites
Maarten Witberg

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!

Share this post


Link to post
Share on other sites
Bones

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.

Share this post


Link to post
Share on other sites
comment

Date ( Month ( datefield ) ; Day ( datefield ) ; Year ( datefield ) + 40 )

Share this post


Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  



×
×
  • Create New...

Important Information

Terms of Use