Solution to add data at certain amount to another table

Question

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

laurathacker · Answer

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.&nbsp; You can populate the fields you need with the data values from the Procurement table.

vijaysingh · Answer

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..

Forum Discussion

Solution to add data at certain amount to another table

Related Content

Moving Fields from One Table to Another

Copy Single Table from One App to Another

Nesting API Button Help (Add record and update another)

Native/Alternative Solution for JavaScript

Qrew Group Update and Solution Spotlight Qrew Agenda