Search the Community

Unfortunately, this cannot be done with a table trigger because this table is updated by other datapages as well. I have a report that searches training dates, lists providers, and sets an indicator based on the fact that the provider took a training. The indicator can be set to yes for each provider with a bulk edit. An indicator date needs to be added when the indicator is set to yes. If this date is not added, I want it to default to the training date. It seems like it would be easy but I can't get the indicator date to save the training date value in the bulk edit if it is blank. There should be a way to take the training date from the results page, set the indicator date equal to that, and then if the user doesn't change that when setting the indicator in the bulk edit to yes/checked, it would save that training date in that indicator date field. I looked into doing this with a trigger, loading the training date into the indicator date field on load, using a placeholder, and JavaScript, but I can't get the value to save. If anyone has advice on how to do this, I would appreciate knowing about it. Thanks.

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

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?