Guest Sam Posted June 9, 2020 Share Posted June 9, 2020 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 comment Share on other sites More sharing options...
comment Posted June 9, 2020 Share Posted June 9, 2020 (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 June 9, 2020 by comment Link to comment Share on other sites More sharing options...
Guest Sam Posted June 9, 2020 Share Posted June 9, 2020 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 comment Share on other sites More sharing options...
Guest Sam Posted June 9, 2020 Share Posted June 9, 2020 The date form is giving an error (?), What can I do? Link to comment Share on other sites More sharing options...
comment Posted June 9, 2020 Share Posted June 9, 2020 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 comment Share on other sites More sharing options...
Guest Sam Posted June 9, 2020 Share Posted June 9, 2020 Whenever they type a letter. I will post thank yo PS: I can't attach to the file Link to comment Share on other sites More sharing options...
Guest Trevor Posted June 9, 2020 Share Posted June 9, 2020 In English: Whenever they type a letter. I will post thank you PS: I can't attach to the file Link to comment Share on other sites More sharing options...
comment Posted June 9, 2020 Share Posted June 9, 2020 Define the field to auto-enter a calculated value, replacing existing value = Self & If ( Length ( Self ) = 1 ; "." ) Link to comment Share on other sites More sharing options...
Guest Sam Posted June 9, 2020 Share Posted June 9, 2020 It works. Only the date is missing! Thanks for the patience Link to comment Share on other sites More sharing options...
Guest Sam Posted June 9, 2020 Share Posted June 9, 2020 I already discovered the error;) Thanks for everything Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1410 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