madman411 Posted July 23, 2021 Posted July 23, 2021 Hi all I've worked myself into a "i don't know what I'm doing now" situation. I'm trying to use a briandunning.com custom function found here however I'm lost at the script tigger remarks. I am unable to add the "one line" script onto OnObjectModify: Quote It is used in conjunction with an OnObjectModify script trigger attached to the numeric field. The script called by the trigger consists of only one line: AutoCurrency ( Filter ( table::field ; "0123456789" ) ) The demo file link no longer works. Can anyone advise on what - if any, and how to make - the script is?
comment Posted July 23, 2021 Posted July 23, 2021 (edited) I would guess the script uses the Set Field [] script step to set the field to the calculation you show. Are you sure you really need this? You can easily format the field to display the entered value as currency. Do you really need this extra work just to keep the field formatted while it's being edited? -- P.S. I don't think a one-line script is going to cut it here. After setting the field, the cursor will be placed at the end of the field's data. That's fine when the user is only entering digits in order from left to right. But it's going to be very inconvenient when they try to edit an entry. Edited July 23, 2021 by comment
madman411 Posted July 23, 2021 Author Posted July 23, 2021 29 minutes ago, comment said: I would guess the script uses the Set Field [] script step to set the field to the calculation you show. Are you sure you really need this? You can easily format the field to display the entered value as currency. Do you really need this extra work just to keep the field formatted while it's being edited? -- Comment - Set Field [] worked. Thank you! To answer your question - no. I don't really need this. I'm just playing with some methods of pre-formatting certain fields and was interested in possibly implementing this into my solution.
comment Posted July 23, 2021 Posted July 23, 2021 You replied while I was editing my answer. Make sure to read the added note.
Recommended Posts
This topic is 1287 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