Hi everyone. This is my first time I post something here. I have search for a bit but couldn’t find my answer. I’m trying to build a form use validation criteria that cross the other records base on a link .as the picture below, I would like to build a form that date2 should be later than date1. Is there any possible way to do that. Thank you all.
Hi @Kal_Lam, Thank you for your quick response. But the discussion you shared was for the same record. I would like to know if we can check the validation cross several records base on a . In my example, NB1, NB2, NB3 are different records. In another word, I would like to check cross the lines in my line list data. I’m sorry if I could not explain it more clear.
Thank you for being patient with my question. But can’t we link 2 records in the same project and check the validation criteria for the new submit? I have 1 project form, data for NB1, NB2 submitted already, then i’m filling the form for NB3 and the date 2 should be later than date1, if i’m enter date 2 earlier than date 1 an error message should be shown.
Thanks @hakan_cetinkaya, I thought there would be an easy way to solve my issue as i just want to validate the entry value like in the validation criteria option (constraint date) but cross different records in the same project. I take a screenshot of my table data that i want to have. For the NB3 the infected date should be 20/6/2021. so when i fill the form for NB3 if I fill to infected date as 15/06/2021 or earlier should be an error because NB2 contracted from NB1 on 15/6/2021 and cannot transmit to NB3 on the earlier date.