Jump to content

Calculations


Recommended Posts

Guest Sam

I'm a Filemaker beginner and I can't do any calculations, could you please help.

The first calculation was to add one. (dot) the middle letter.
The field is called middle_name

The second calculation was to change the date to DD-MM-YYYY, by importing the data it is MM-DD-YYYY

Thank you all :)

Link to post
Share on other sites
  • Replies 9
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted (edited)
18 minutes ago, Guest Sam said:

The second calculation was to change the date to DD-MM-YYYY, by importing the data it is MM-DD-YYYY

If you have a Text field containing imported dates in MM-DD-YYYY format, and you want to convert them to valid dates in the format used by your file, then use a calculation field (result is Date) =

Let ( 
v = Substitute ( ImportedDate ; "-" ; ¶ )
;
Date ( GetValue ( v ; 1 ) ; GetValue ( v ; 2 ) ; GetValue ( v ; 3 ) ) 
)

 

18 minutes ago, Guest Sam said:

The first calculation was to add one. (dot) the middle letter.

Sorry, no clue what you mean by that.

 

---
P.S. Please update your profile to reflect your version and OS so that we know what you can use.

Edited by comment
Link to post
Share on other sites
Guest Sam

Thank you very much for the answers!

When a person enters a letter in the field (middle_name) he automatically adds one.

Ex:
R.
S.
P.
K.
L.

I'm using Filemaker 19 and the windows version

Link to post
Share on other sites
11 minutes ago, Guest Sam said:

When a person enters a letter in the field (middle_name) he automatically adds one.

Do you want this to happen only if they enter a single letter, or every time?

 

8 minutes ago, Guest Sam said:

The date form is giving an error (?), What can I do?

I don't know. Why don't you post a simple file showing the problem (and nothing else).

 

Link to post
Share on other sites
Guest Trevor

In English:

Whenever they type a letter.
I will post

thank you

PS: I can't attach to the file

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.