I am trying to adopt Retool to build a data entry for Geology logging. I need a validation that will check the From and To columns in my query/table in Retool. So the idea is to prepare a Validate button that will check if there are nay From and To rows that are overlap each other or if there is gap.
Thanks for your reply. I already added some validation to my form, similar to what you suggest.
But I still cannot figure out the easy way to stop or at least notify users not to enter the data which will cause gap or overlap with previous data they already entered previously (let say the day before).
For now, I still can enter the data for example KTD001, from: 10, to: 12, which is overlap with the first record in the image attached.