Hi I'm new to SmartSuite just trying to move from FileMaker to here. I'm having a problem when I'm trying to migrate my database over.
In FileMaker, for instance, after I've pulled the price of item from the Inventory table to the Invoice table, I am able to edit the price manually without changing the price in in Inventory table. In other words, the price is only copied from Inventory to Invoice, then it is no longer attached to the original table.
Because SmartSuite does not allow for use of lookup value in a formula yet, I cannot even copy the price to a dummy field for editing.
Did I miss anything and is it possible to do that in SmartSuite? Thanks very much!