Jump to content

seancsn

Members
  • Content Count

    5
  • Joined

  • Last visited

  1. Thank you Xiang. That is really helpful. I hadnt seen the Switch option but had been advised to use else and if. Yours looks much simpler!
  2. Hi, I would like some help writing a JS code to calculate an item in submission form. For simplicity I have renamed the relevant items in my app: Form name: Actions_made Relevant fields: 1. "Actions" - dropdown with a number of options eg. Cancelled, Switched etc. 2. "Current Product name" - dropdown with product names that user currently uses 3. "Current Pack cost" - cascading text field that populates with the relevant pack cost once the Product above has been chosen 4. "Current Pack size" - cascading text field that populates with the relevant pack size once the Product above has been chosen 5. "Quantity per day" - populated with a default value of one but user can update with any quantity. 6. "Annual Saving of Current product" - needs to populate with the formula when "Cancelled" is selected from the dropdown "Actions" above and also if the "Quantity per day" field remains as one or is updated by the user: (Current Pack cost/Current Pack size)*Quantity per day*365 I have never written JS code before and would like some help to be pointed in the right direction. Thank you in advance and have a great Christmas! Sean
  3. I have a Date field in one of my data pages. I would like it to default to todays date without the time added. I can only see Timestamp as an option. Is there any other way to include todays date without the time? Thanks Sean
×
×
  • Create New...