Page 1 of 1

Drop Down Categories.

Posted: 2021-01-05 16:38
by mqley
Hi, is it possible to have Admin group enter some categories in a drop down 'Computer, TV, Phone' etc.

Then when lets say a new group General is setup, they can see these Drop downs. But add new ones to it for their personal use only? And not have their personal use only one's be available to other users in the same General group?

It seems how I've set this up works as I thought but then as a General group member I add a cateogory and it shows up to the Admin and other General group users.

Whereas I want the General group to see 'Admin' categories as default but the ability to add their own. Not have their own shared with others if that makes sense. Possible or not? Thanks.

Re: Drop Down Categories.

Posted: 2021-01-06 09:03
by mqley
Hi, I understand its not a clear message after reading back. I'll change the way I'm thinking about this maybe. Thanks.

Re: Drop Down Categories.

Posted: 2021-01-06 12:49
by mqley
Hi, in the Options list where you can populate:

i.e
January;;February;;March;;April;;May;;June;;July;;August;;September;;October;;November;;December

Is there a way to code this into the app code somehow?

Thanks.

Re: Drop Down Categories.

Posted: 2021-01-06 14:41
by pbottcher
Hi,

you can use this

https://bigprof.com/appgini/help/advanc ... agic-files ->tablename.fieldname.csv

Re: Drop Down Categories.

Posted: 2021-01-06 15:29
by mqley
Hi, thats great. Thanks for ref link. Regards

Re: Drop Down Categories.

Posted: 2021-01-07 14:07
by mqley
Hi, ok this works thanks. But there does appear to be an issue to flag up.

It works great for adding in as a new item, but as soon as its saved it goes into the screen where you can Save Changes/Delete/Save a copy etc. At this point it reverts to the first one in the list. So if I did save it would save with the wrong category choice (i.e first option).

In the Table View it looks correct, so saved with correct drop down selection.

But again if I edit from there it shows drop down at the first option. Is this a bug or will I need to edit some other files?

Regards

Re: Drop Down Categories.

Posted: 2021-01-07 15:58
by pbottcher
Hi,
I did not get you issue, maybe you can post a screenshot and the code how you implemented it.

Re: Drop Down Categories.

Posted: 2021-01-07 16:22
by mqley
Hi, so looking at the attached - see the Category? When you edit it goes to the first option in the tablename.category_name.csv file 'Miscellaneous'

So the question is - why isn't the option being remembered when it the other modes - edit etc? Thanks.

This is what is contained in the csv file. I've tried without line spaces but the same issue.

Miscellaneous;;
Charities;;
Clothing;;
Eating Out;;
Education;;
Entertainment;;
Food;;
Fuel;;
Gambling;;
General;;
Gifts;;
Health & Fitness;;
Holidays;;
Housing;;
Insurance;;
Kids;;
Luxuries;;
Miscellaneous;;
Pets;;
Savings;;
Shopping;;
Standing Order;;
Travel;;
Utilities;;

Re: Drop Down Categories.

Posted: 2021-01-07 20:13
by pbottcher
Hi,

do you have linebreaks in the csv file? You shall not put linebreaks or blanks at the beginning or the end of the option. That will break the logic.

Just put everything in one line

Miscellaneous;;Charities;;Clothing;;Eating Out;;Education;;Entertainment;;Food;;Fuel;;Gambling;;General;;Gifts;;Health & Fitness;;Holidays;;Housing;;Insurance;;Kids;;Luxuries;;Miscellaneous;;Pets;;Savings;;Shopping;;Standing Order;;Travel;;Utilities

Re: Drop Down Categories.

Posted: 2021-01-07 20:21
by mqley
Ahh thanks - you've nailed it! Cheers