Hi all, I just can't make my validation form behaviour to behave correctly. I need to validate a numeric input field so that the user enter: VALID VALUES: 1,1 10,01 1000,01 1,0001 NOT VALID VALUES: 1as 1.01 1.000,01 But I cannot find a way to create a mask or regular expression to do this. Basically...

Hi all, still having problem with validation. sorry. All I wanto to do seems easy: I would like to throw an error if 5 fields are left to default. Example: field1: [0_______] field2: [0_______] field3: [0_______] field4: [0_______] field5: [0_______] name: [_______] this form should show an error if...

Additional info: I found an interakt tutorial that seems to do this but I'm not sure it working ok. The tutorial says simply to add another validation form that will validate one filed based on another field. Once I add this to the page I don't see anymore the asterisk for all required fields. All r...

Hi all, I have a custom transaction with few input fields. I need to validate a field, based on another field. Example: Here is the form: 'quantity1' [__________________] - Category1(dropdown menu - static) 'quantity2' [__________________] - Category2(dropdown menu - static) The field category shoul...

Hi all, I have a custom transaction on a page that is driving me crazy. I have a dropdown menu(1) that allow you to select a record from a table (mysql). Then I have 5 additional fields that get populated once I select something from the main drop-down menu(1). I used multi-field drop-down to do thi...

Hi all, I'm using ADDT here, but I think this is the same in Kollection 3 pro. I need to create a form with a X number of fields. Something similar to: --------- MYFORM field1 field2 field3 --------- [submit] [add field(button)] After clicking the add field button the field4 is created. So the form ...

Hi all/Fred ;) , I would like to build a dynamic form that acts differently based on user actions. Example: I have a form with a dropdown menu where the user can select item 1 and item 2. The form contains other 2 fields: - item 1 details - item 2 details I would like to make the field "Item de...

Hi Fred, Thanks for your reply. I can easily link the two table with the same query you posted. My problem is retrieving the USER data while inserting data in another table. I have an Insert Record Form server behaviour on my page. The IRF will insert data in the order table. In the same table I hav...

Hi all, I need a little advice on how to develop a simple procedure. I have 2 tables: 1- users (complete anagraphical data) 2- orders I have a page where the user can login and go to the insert order page. In the order page I have a form that will be filled and sent by email to a fixed specified add...

SOLVED: I have put
as default in the dynamic form and set the field in phpmyadmin as INT (10).

I changed the update transaction too, just to update the unix timestamp when updating the record, so I've put as default of the date field even to the update transaction

HTH

tony