Solution to add data at certain amount to another table | Discussions

Expand all | Collapse all

Solution to add data at certain amount to another table

  • 1.  Solution to add data at certain amount to another table

    Posted 07-17-2019 07:16
    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 table but still thinking about what field for the asset table since the idea is just to put item with price more than 2000 USD on the table

    Many thanks, really appreciated


  • 2.  RE: Solution to add data at certain amount to another table

    Posted 07-17-2019 12:35
    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.


  • 3.  RE: Solution to add data at certain amount to another table

    Posted 07-17-2019 13:01
    I agree with Laura above..In case you don't need to insert entire record in the Asset table, you can use automated action to update a certain field with the USD amount for a particular record..