Notice: This site is now in read-only mode and will no longer be updated.
Please visit our new and improved Knowledge Base at https://kb.joget.org/ for the latest content and updates.
In a form , I have used date field (say:-"project start date") and one more date field in Spreadsheet(say: "revenue month"). If I choose the date(project start date) in form as Oct 1 2022, the date field in the spreadsheet(revenue month) should start from the date selected in the Project start date field(greater than Oct 1 2022), using date validation. I want to put date validation in spreadsheet.
Try Spreadsheet Deep Customizations as you can write your own Javascript. That would also means that you can read any field in the same form to perform your validations.
Hello Experts,
In a form , I have used date field (say:-"project start date") and one more date field in Spreadsheet(say: "revenue month").
If I choose the date(project start date) in form as Oct 1 2022, the date field in the spreadsheet(revenue month) should start from the date selected in the Project start date field(greater than Oct 1 2022), using date validation. I want to put date validation in spreadsheet.
Spreadsheet Custom Field Formats
Link:-
Spreadsheet Custom Field Formats
In this above link, I did not see the format logics to achieve the above points.
May I know what should be the solution?