Ok, I don't think this can be done with writing a code or macro and if not, I accept that.
I have a form for a database with drop down options tasks. The dropdown database table is used for many different job requirements.
i.e. Not Needed, Needed, Pending, Done
I would like to have each of the options a different color so when looking at the form I can see instantly each by color. Such as Not Needed might be cyan, Needed = yellow, Pending = pink and Done = light green. The words would be there but also having the colors might make it wash to scan for all yellow and know these are action items.
Again, can this be done with the table format without a macro? If no - no problem, just thought I would ask.
I am new to openoffice base so still learning.
Thanks in advance.
John
[Solved] Base table with different background colors
-
- Posts: 4
- Joined: Mon Sep 13, 2021 6:25 am
[Solved] Base table with different background colors
Last edited by MrProgrammer on Sat Oct 02, 2021 4:07 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
John Carter
Office Ver 4.1.10
Windows 10
Office Ver 4.1.10
Windows 10
Re: OO base table with different background colors
No, there is no way to do this with a form. [Tutorial] Using registered datasources in Calc describes how you can create a simple report on a Calc sheet where the data are linked to a cell range. With the right template and with cell styles, it is easy to apply conditional formatting.
I use the attached template for such reports.
I use the attached template for such reports.
- Attachments
-
- Report.ots
- (21.73 KiB) Downloaded 357 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 4
- Joined: Mon Sep 13, 2021 6:25 am
Re: OO base table with different background colors
Thanks for the information and the confirmation that I will need to be much more advanced in database programming. LOL
Have a wonderful day.
Have a wonderful day.
John Carter
Office Ver 4.1.10
Windows 10
Office Ver 4.1.10
Windows 10
Re: OO base table with different background colors
No programming at all. No macro can colorize rows in a table control because every row is an instance of the same set of data conrols. If a column of a table control is a text box, all rows are instances of the same text box.
Just prepare a spreadsheet document, drag a query from the data source window into the sheet and apply conditional formatting.
Just prepare a spreadsheet document, drag a query from the data source window into the sheet and apply conditional formatting.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice