$25 complaints tracking sheet

Hi All

i had a previous project here for a complaints tracking sheet where if you choose that a complaint is resolved the row is automatically copied to the resolved sheet and if it's still pending it's copied to the pending sheet, it was a basic sheet, this time it's a little more complex, it's not a normal table, it's an application form meaning that multiple rows have to be moved and copied to the resolved and pending sheet.

i want it to do the following:-

1- Move data from application form with a press of a button called Submit (next to it is a reset button that deletes all fields without moving data) and make that press to be conditional , when you choose resolved it moves all data to resolved sheet and when you choose pending it moves the data to pending sheet.

2. i also want the submit button to generate a serial number starting with 1001 (resolved and pending sheet have to be connected, for example if you start with resolved and it's 1001 and the next complaint is pending and you submit it it's number is 1002) (i don't know if this is possible please tell me if i am too ambitious) :poly:

3. in the complaint form sheet i want to lock the all cells and force user to type only in fields.

4. Finally there is a search button on top of the form i want it to be used to seach for complaints, for example if you type 1001 and click search it shows you the row which has this number (use the easiest way possible for you i don't it to be a troublesome feature for you guys, as long as the row is shown in a simple way like a prompt or text based or whatever :cul:)

10% is already paid

Re: $25 complaints tracking sheet

ok great i will be waiting

Re: $25 complaints tracking sheet

omg it's perfect :D, but there's tiny problem and it's my mistake that i didn't remind you sorry, date closed can only be used when a problem is resolved, i noticed that when i entered a date into it and pressed the submit button while choosing pending it moved the date to pending sheet where there is no 'date closed' column, isn't there like a rule where if you entered data into date closed and chose pending it wouldn't work and a prompt tells you there shouldn't be a date?
also the first complaint i submitted started with 1002 not 1001 i don't know why, again thank you for quick reply i honestly didn't expect it to be done so quickly

Re: $25 complaints tracking sheet

Thank you man, last fix i promise and i'll be out of your hair :p , can you also force a rule where if date closed isn't entered and you choose resolved to show a message that you have to enter a date, it's the opposite of the previous rule, and the first complain is still 1002 and not 1001

Re: $25 complaints tracking sheet

Done

Thank you very much again, i'll will give you feedback in the next 24 hours.

Re: $25 complaints tracking sheet

Hey man, there are a few problems

1- There is a problem with the range in Pending sheet which i don't face in the resolved one and that is that the serial number doesn't go to the S/R coulmn after the first complaint

2. in the locked cells in the complaint sheet there are 2 cells the are unlocked which arent part of the application form

3. even if i enter the details correctly and the data is moved it keeps showing the please try again message.

Thanks

Re: $25 complaints tracking sheet

Thank you so much, so far it's perfect and i hope i don't run into any problems

Re: $25 complaints tracking sheet

Hello yegarboy i don't know if they can be called minor tweaks but i hope they are, after these fixes i will open a new request for a dynamic chart in the coming days

1. i added a solution field in the application form and what i want is when i hit submit it goes to solution column in resolved sheet and of course an error message pops up when you select pending and type a solution.

2. i was reluctant to make this request but i hope it's simple and not time consuming, in the pending sheet i added a column called change status which has a button called (resolved?) when you press it cuts the row and moves it to resolved sheet along with the serial number.

Thank you for your patience

Re: $25 complaints tracking sheet

instead of a button i changed it to a drop down box it's more user friendly, sorry i know i am annoying please bear with me

Re: $25 complaints tracking sheet

Thanks

Now there are the following corrections:-

1. i want the complaint sheet to be locked and focused on the fields only like before (i noticed there are two 1000s below the form lol)

2. a resolved sheet can still be submitted even though there is no solution i want the solution to manadatory for a resolved complaint.

3. i want all the forms to be mandatory i can still submit a complaint without an account number for example

4. and finally the most important new feature a dynamic doughnut chart or pie in a newly created report sheet, what i want to do is show the percentages of complaint types from both sheets for example in resolved sheet there 5 type 1 complaints and 2 type 3
and in the pending sheet there 5 type 2 and 2 type 1 for example , i want that graph to represent the percentages of types and be dynamic when you add a new complaint with type 3 it reflects on the chart

Thank you

UPDATE: Raised to 30$