Search the Community

Using a self-joining table to enter part numbers and quantity required to view description, pricing, discount structure etc. When entering a part number that doesn't correspond with any part number on the stock list (part number and quantity table self-joining to stock list) it will obviously not show any other detail as there is no data to match, but I would like to set a default value for the description field when no match is found to display 'Invalid Part Number'. I've had some ideas on how to get it done but keep getting stuck as I also want to display this in the Table View with HTML. Only way I've managed to get near to what I want was to add a cascading autocomplete text field, but I can't hide this field from the table view where the part number and quantities are entered. I can't think anymore, surely there is an easier way. I don't know enough of JavaScript, but thought that could be an answer to use an HTML block with javascript to display what I need. Any suggestions?

Hello guys, How can I use the timestamp as a default or initial value of my DateTime field in a Details page? I set the Form Type to Text Field, but I can't see the On Load option in the Advanced Tab. If I set the field as Hidden, I get that On Load option, but at the expense of not being able to edit it. Please help. -dspolyglot