Search the Community

Maybe the description of the problem is not what it should be but let me describe my problem. I want to add products to an order. I have an order table with customer_ID, product_ID , Quantity, Unit_Price fields I also have a product table with Product_ID, Product_Description, Unit_Price , and Stock_Quantity When I enter a Product_ID (combobox) in my order tabel I want to copy the Unit_Price from the product table into the Unit_Price field in the order table. What is the best way to do this ? Thanx

Hi all, I cannot seem to overcome an issue with the use of Javascript on a bulk edit screen. There is a basic little script I wrote to control when users should be notified about changes done in bulk. It should simply prevent notifications from being sent if the user did not alter the initial delivery status of a product. While the script itself executes just fine upon each change to the delivery status field, the value that gets inserted into the text field which toggles the actual notifications isn't being saved when I hit "Update". It works if I manually type in Yes or No, but not if it's done via the script. I suspect this has to do with Ajax in one way or another, about which I lack the necessary knowledge to troubleshoot, unfortunately. var pSDeliveryOld = document.getElementById("BulkEditParticipation_List_2016_Delivery_status").value; var dStatusChangeNotification = document.getElementById("BulkEditParticipation_List_2016_Notification_DStatusChange"); function statusCheck() { var pSDeliveryNew = document.getElementById("BulkEditParticipation_List_2016_Delivery_status").value; if(pSDeliveryOld !== pSDeliveryNew) { dStatusChangeNotification.value = "Yes"; } else { dStatusChangeNotification.value = "No"; } console.log("System to send notification: " + dStatusChangeNotification.value); } document.getElementById("BulkEditParticipation_List_2016_Delivery_status").onchange = statusCheck; Could one of you experts out there help me get the Yes/No value saved in the table? Many thanks in advance! Best, Kristof

I have created a page submission form with Estimated Value & Estimated Value 2 which displays like this on the details page: Estimated Value: $10,000.00 to $20,000.00. However to get both numbers to display in the table without being next to each other and making the table huge I have created an HTML block like this: [@Estimated Value] [@EstimatedValue2] The problem with that is then I can no longer sort the results table by estimated value. Is there any way to have the numbers display as $10K and $20K or something similar so the table doesn't end up so long? In addition I need to be able to search the table by Estimated Value so people still need to be able to search by $10,000.00. I currently have the search set to just search [@EstimatedValue] using the criteria options. Thanks for your help!

How to get the value of the selected radio button?

I want to be able to display 2 decimal places in my details page which is editable where the value in my table does not have decimal places. This field has a Form element of text in my details page. For example: Value in table is 25 I want to display: 25.00 in my DataPage which can be edited