Help

Re: Entering data into one table that automatically appears on another

918 0
cancel
Showing results for 
Search instead for 
Did you mean: 
boston_barker
4 - Data Explorer
4 - Data Explorer

Hello

I am trying to create a database where when i enter a payment for a customer on one for it automatically puts that payment onto another form. How do i do it.

Thank you

3 Replies 3

To automatically create a record in another table then you will probably need to use Zapier or a similar service.

However, are you certain you need the second table? Why can this data not remain stored in the first table? In general, duplication of records across tables is unnecessary and problems llike this can be solved by adjusting your database structure.

And, it creates other issues sustaining authoritative data. For example, what if there’s an error and you correct it in the first table. Now you have a crisis of data truth because it’s very difficult to instrument partial duplicative processes.

Perhaps you really need another “view”. Same data, just rendered or presented slightly differently.