Jump to content

auto enter calc in portal


falkaholic
 Share

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

Recommended Posts

I have invoicing database that contains a portal to items purchased. Since the store does US and Canadian dollars, each item has a price in both currency in the inventory database.

I have the user select which currency for the transaction in the invoice and the lineItems database has a field for the current price, which is auto entered calculated number (price depends if its on sale and its currency) from the inventory DB.

My problem is that, usually on the first portal row, since its a auto enter, the lineitem doesn't have the invoiceID to check for the currency or itemID, so it defaults.

How can a get around this? make a script that creates a new invoice record AND a lineitem record with the needed info entered?

Link to comment
Share on other sites

To avoid premature calculation in an auto-enter field, you need to test that all necessary fields contain valid data first. One way would be to enclose your calculation in a case statement:

Case(not IsValid(ParentFile::AnyField),"",

...the rest of your formula here...)

Link to comment
Share on other sites

This topic is 7177 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.