Jump to content

Change Row Color?


AngelArs
 Share

This topic is 2334 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am working on a pre-inventory form. The form will basically be listed by product SKU numbers.

Each line (row) of the form will contain a different product SKU number, for example;

Product #101010

Product #111111

Product #123456

 

The stores database automatically keeps track of each product amount in stock, BUT, because of theft and misplaced items, we count each item every morning and night, and then compare it to what the stores database says. 

I'd like to make a conditional, where when the amount counted equals the amount the database says we have, the entire row turns green. If it doesn't equal the same number, then the row turns red.

How would I do this?

 

Link to comment
Share on other sites

Thanks webko.

Wondering if it's possible to have the conditional formatting for a set amount of time, and then have it revert to normal.

For example, it turns the field red for 10 seconds - and then it turns back to the previous background color again.

Is this possible?

Link to comment
Share on other sites

2 minutes ago, AngelArs said:

...when it first changes to red.

Assuming you mean when the field is modified: it is sort of possible, but you would have to script it, it would take a lot of work, and you probably wouldn't like the result because of too much flashing. I would suggest you stick to built-in features, such as conditional formatting (permanent for as long as the condition is true), or a script trigger to pop up a message.

Link to comment
Share on other sites

6 hours ago, AngelArs said:

...when it first changes to red.

This could be fairly easy to do by installing an on script timer set to run in ten seconds. I would keep it as light as possible, like setting a global variable and refreshing an object in the window. That could work regardless of context if your user navigates away to another layout. You can also put a script trigger on the layout to handle if they leave the layout as well.

Link to comment
Share on other sites

I'd query why this is thought necessary - you either have the correct amount of stock on hand, or you don't. If the numbers are different, then a visual marker for that isn't a bad thing...

You could vary based on time modified compared to now - which would re-check the conditional formatting on window refresh, so coming back later in the day might change the visual effect on the relevant records.

Link to comment
Share on other sites

 

23 hours ago, webko said:

You could vary based on time modified compared to now - which would re-check the conditional formatting on window refresh, so coming back later in the day might change the visual effect on the relevant records.

Counts are performed twice a day (before store opens, and after store closes) but not during the day. 

 

 

22 hours ago, Lee Smith said:

I’m a little confused, are you looking for something along these lines?

Change Row Color.fmp12

Hi Lee, when I opened up the file all I saw was a dark header and a blank page. 

Link to comment
Share on other sites

13 minutes ago, webko said:

Go to the Change Row Color 2 layout....

Thank you :)

23 hours ago, Lee Smith said:

I’m a little confused, are you looking for something along these lines?

Change Row Color.fmp12

Not exactly.

As the person is entering in the data I was looking to change the entire row (background) red to immediately alert them of a problem. Would be great if there was a "reset" button to undo the red background (could be reset for entire form if making it for individual row is to hard to make). Having said that your example would work in a pinch. 

Link to comment
Share on other sites

OK, try this one...

No row will be coloured to start with - if there is data entry that results in an issue, the row turns red. It will stay red for at least 15 seconds, and then will change if:

1. The layout is navigated away from and then back (to simulate, go to Layout Mode and then back to Browse mode)

2. The record is touched again (placing a cursor in a field after the 15 seconds is up)

The field zzBlank is underneath the data fields, and has the conditional formatting applied to it 

Change Row Color 15sec.fmp12.zip

Link to comment
Share on other sites

I made a couple of changes to @Lee Smith version.

I added a ModifiedTimestamp - Timestamp field that auto-enters the Modified Timestamp

Then I made the conditional formatting attached to the zzBlank field check the current time vs the Modified TimeStamp as well as whether the count is out.

It will only evaluate again if the screen is refreshed, or the row is updated. 

It's the practical version of what I suggested earlier.

Link to comment
Share on other sites

2 hours ago, AngelArs said:

the file all I saw was a dark header and a blank page.

Sorry about that, i should have made a open script and removed the layout from view. It was just a proof of concept to see if we were all on the same page.

@webko Nice modification of the file to move this forward.

Lee

Link to comment
Share on other sites

This topic is 2334 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.