Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Filemaker format field
I'm looking to fin how to automaticcaly delete the space and the "Enter" Key at the end of a field when a user enter those caracters ?
For example :
I would like "THE PRODUCT", without space and enter at the end
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Tanks it works perfectly
I have 2000 existing entries that I would like to modify with this function.
To script, that I just activate the record and then go to the next one, or is there an easier solution ?
Use the "Replace" function to change all the records.
First, Show All records, then click in the field you want to update. Select "Replace Field Contents…" from the Records menu and then in the "Replace…" dialog click "Specify Calculation" and enter the Auto-enter calculation. This will apply the function to all records.
A word of caution: The Replace function is fast and effective but it has NO "Undo". Make sure you have a backup of your data in case you make a mistake.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent