How to assign an empty field using Update/Calculate field condition?

  • pgctreasdisbursements
    Asked on May 9, 2024 at 10:19 PM

    Requesting for the following:

    1. Possibility to modify the content of the "Start filling" welcome page when enabling Show PDF thumbnail on the welcome page
    2. Uploading of Excel as the source data of calculation of drop-down field/dynamic drop-down widget.
    3. Availability of date format to format in "Word" not in number e.g. January 1, 2024 (can be used in writing formal letter template) or removal of day name (e.g. Monday Jan 30 2024) in the using calculation datestring and substring.
    4. Add additional action to "Clear or leave blank a fields" if a certain condition is needed aside from copy field value.
    5. Add a "Disable Multiple" option similar to "Don't require Multiple" in the conditions.

  • Mary_Ed JotForm Support
    Replied on May 9, 2024 at 11:52 PM

    Hello Pgctreasdisbursements,

    Thanks for reaching out to Jotform Support. I understand your request, but I'll need some time to look into each of the possibilities and will address them in separate threads. I’ll get back to you as soon as I can.

    Thanks for your patience and understanding, we appreciate it.


  • Mary_Ed JotForm Support
    Replied on May 10, 2024 at 5:02 AM

    Hello Pgctreasdisbursements,

    Thanks for your patiently waiting. I’m sorry, I couldn’t understand exactly what you want to do with your 4th question. Can you give us more details on what you would like to achieve exactly so we can check if it's possible? As for your other questions, I answered them in separate threads, check out the links below:

    How to upload an Excel File as the source data for the Dropdown or Dynamic Dropdown Widget?

    How to display the Day and Date format using the Form Calculation Widget?

    How to disable multiple fields?

    Modify the Start Filling button in Smart PDF forms

    Thanks for your patience and understanding, we appreciate it.

  • pgctreasdisbursements
    Replied on May 10, 2024 at 6:12 AM

    For the 4th question:

    Add action in "Do" to clear the field or leave the field blank.

    Add: "Clear Field Value" action

    How to assign an empty field using Update/Calculate field condition? Image 1 Screenshot 20

  • Lara JotForm Support
    Replied on May 10, 2024 at 6:35 AM

    Hello Pgctreasdisbursements,

    Thanks for getting back to us. You can achieve this by assigning an empty value to the field when using the Update/Calculate Field condition option. Let me show you how:

    1. In your Form Builder, click Settings from the orange tabs.
    2. Click Conditions from the left panel.
    3. Select Update/Calculate Field condition.

    How to assign an empty field using Update/Calculate field condition? Image 1 Screenshot 50

    1. Enter the condition as shown below.
    2. Use your space bar to assign an empty value to the field
    3. Then, click the value to change it from number to string. Click Save.

    How to assign an empty field using Update/Calculate field condition? Image 2 Screenshot 61 How to assign an empty field using Update/Calculate field condition? Image 3 Screenshot 72 You can test my demo form here or clone it to copy the changes made. Or, you can check out the screencast below to see my results:

    How to assign an empty field using Update/Calculate field condition? Image 4 Screenshot 83 Give it a try and let us know how it goes.

  • pgctreasdisbursements
    Replied on May 11, 2024 at 2:52 AM

    Okay will try again, before the last time I tried using it had no effect. Will let you know. Thank you again.

 
Your Answer