How is SC with dates? Due dates and highlighting rows.

I’m waiting for SC staff to re-instate my trial, evidently it expired. I installed it, and moved onto something else.

My question: How is SC with dates? I have an app that I need to create that has a test date and due date. If the due date is approaching (say 7 days or less away) the row will turn yellow, if the due date is here or past due the row will turn red. Is this possible with SC?

Yes. You need to use some sc macro’s to turn the background of fields into any colour. There’s a onload event that allows you to treat each and every row. One issue though, you need to colour each field, there is no macro that turns the complete row with all fields into another colour.

@aducom, but you can turn the cell with the date a color? Is that correct or am I misunderstanding?

Yes, you can change field colors,fonts, background etc. in a grid depending on a condition.

Thank you aducom. I’m evaluating SC, but am also looking at phprunner, phpmaker, sqlmaestro’s php generator, xojo web edition, etc. I like SC so far, although it doesn’t seem as feature rich as the others, it does run on mac though. It could be that I’m still a newb though and haven’t discovered the features yet.

This is not the place to discuss the different options. I don’t think that other generators are as feature rich as SC. But all have their strong and weak points. You need to pick a tool that fits you most.

Adding to what Albert said. Dive into the forums, explore with projects, and try try try try.

SC is a good tool. I can say you good things, and bad things, but is better to not condition your opinion. Talk about others tools, obviously, is not well seen. Try it, and think if it fits your needs. Try with difficult tasks. For easy tasks, all IDE works perfectly. And if you are not developer, think you have to learn PHP and Javascript. SC don’t gives you the job done.

The more I use SC, the more impressed I am.