skyflare1

Update - Issue fixed! I had inserted the code into the footer of "Configure Results Page Fields" but not the "Configure Search Fields" footer. Problem solved and it is now working beautifully.

I hate to bump this but am running into a dead end on this fix. Any ideas?

I have been working on this more. Here is the status, again, help would be greatly appreciated. The way the DataPage is set up is the client logs in. After this, they see a Search Form asking for the phone number. The hyphens are NOT being automatically inserted and must be inserted manually. However, once you have searched, the results populate below the Search Form. After this, if you search again, the hyphens ARE being automatically inserted. So the code is working, partially. Note: Search Form is marked as Required. Any ideas? Thank you!

Thank you! I figured out that the Table DataType for that column is set to Text (255), not Number. Unfortunately, if I try to switch it out, it says I will lose the data already entered.

Thank you. I inserted this into the footer and it doesn't seem to be having any effect. Could it be because the clients have to log in and then use the Search Form? [I could PM you the link to the form if that works with test login info.]

I am new to this, so please forgive me initial ignorance. I have a Tabular Report DataPage that uses Phone Numbers as the Search Form. The phone numbers are entered in via a CSV sheet in the format 555-555-5555. Some of the clients using this are not realizing they need to add the hyphens manually when searching using the Search Form, leading to confusion. Is there a way to code it so the hyphens are automatically inserted when they search the DataPage? Thank you!