Is there a way to create a new view upon submission of data field using the same table?
I am new here, I have been a computer tech for years but have not done much programming since DOS and GWBASIC.
I working a new Zoho Project, my actual first attempt at this. What I have is a form to input some filed date into a table. I have one field that will generally be left blank, but if the field equals anything other than null, I want to create a new view for the same table. However, I want the view filtered to only show data from the table that correlates to another field that has a drop down selection which is a required field unless the first field is not null. Also on submit I want it to create a new option with the Field data as the name in the dropdown box.
Any ideas and suggestions would be helpful.
Thanks