Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the sheet 1- We want to show closed ticket-(Status-Closed)
In the sheet 3 - we want to show all open ticket(status<> 'closed')
In the sheet 3- click on "oldest open case"- then detail records within 54 days will open
in the sheet 3- click on "open ticket"- then detail records will open
work with Triggers on your textobjects in sheet3
can you elaborate more what to do?
so there is no Detail records on sheet3, but a table ticket Details on sheet1
you write field Status, but in textfield you use field @_statu; please explain
Hi Suman,
Take a look at what I've done in the attached file
Regards,
Miguel
Appreciate your quick response.
As per the requirement sheet one should display closed record but sheet 3 other than closed on.
@Status- Contains information status of the ticket- closed/blank-open, awaiting confirmation
Please let me know if you need more information.
sheet3 should contains other than closed one(open/awaiting confirmation)
Thanks for helping me. I have checked your application.
You just called the sheet tha's ok but i need more information. Please help
What sort of information you need?
Miguel again appreciate your help-
Please find the attached file containg my application. It has 3 sheet.
In the sheet 1- We want to show closed ticket-(Status-Closed)
In the sheet 3 - we want to show all open ticket(status<> 'closed')
In the sheet 3- click on "oldest open case"- then detail records within 54 days will open
in the sheet 3- click on "open ticket"- then detail records will open
Hi,
Please let me know if you need more information.
Regards