I have a section in my database where i input a purchase price of a product then how much i want to mark it up, and then another field to show the total price. I have another feild where if you dont put the markup price it it says "no markup inputted" but if there is a markup price in there it remains blank

so basicly i want a field that tells me i left a field blank, how do i do that?

You don't need script nor do you need to waste creating a calculation. You can use conditional formatting such as:

MarkupPrice

This boolean will return true if the field has a number greater than 0. Then type words "no markup inputted" and attach this boolean calculation to it. In the conditional format, change the text to same color as background where it will reside. In this way, if MarkupPrice is blank or zero, it will produce the words in black; otherwise the words will disappear into the background thus indicating that there is indeed a markup price.

Edited April 2, 200916 yr by Guest