Forum Discussion

SyaefulBahri1's avatar
SyaefulBahri1
Qrew Member
6 years ago

Solution to add data at certain amount to another table

I have a procurement table and asset table. There is price field on procurement table. The idea is if the price is more than 2000 USD, it will be included on asset table. Right now, I only have asset ...
App builders
Forms
Formulas and functions
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
6 years ago
You can do this very simply with a QBAction to create the Asset record when the Procurement table record is added; with the condition that the Price field is equal to or greater than 2,000.  You can populate the fields you need with the data values from the Procurement table.