I am facing problem, when it comes to upload data from the checklist (the form is pulling data from parent checklist). Although the checklist is linked with parent checklist but the fields which submitted as empty is input type select_one and date.
The issue is with some of the field. I have attached the form (with yellow highlighted fields/rows) for which the data is blank in server. Also attaching the downloaded excel for referance.
Sorry @aditya, could not understand your issue. Could you simplify them with some screenshots if possible so that the community could help you solve your issue?
I have rechecked the same from my own device/mobile, before posting in this platform.
All data field are not empty. Data is missing for the fields under group named ‘due_list’ (from Row36 to Row 238), where as the group rest fields are capturing and submitting data as expected. (Checklist - Form (Checklist).xlsx (36.1 KB)
Below is the screenshot of the fields for which there is data in table also.
Your field ${cal_age_days} does not return an integer but a date instead, as you may see in the note field ${age_week_note}. Because of this, all the “relevance” fields in your problematic fields are wrong.
This is because the calculation is a simple subtraction of two dates, which does not need to cast the dates into integers. I could make your form work by putting this into the calculation property of your ${cal_age_days} field: round(${info_date}-${C_Age})
The function round() will force the two operands to be cast into integers, and the result will therefore be an integer.
Thankyou for the response. The form is working fine without/with the function ‘round’. The problem is with data saving. My table is showing blank. I checked with round function also.
