Incrementing a field values based off another field's content.

Question

Hello,I'm currently working on a project where many tables have relationships and require automation features. For instance, if a user selects an option from a lookup field, [Field X], in Table X, then in doing so, [Field Y] will increment in another separate table, Table Y.My design right now is built on a set of reference tables that can be utilized in an operations table. My goal is to "trigger" events such as the one described above to reduce clutter in the operations table. I can provide screenshots and table data/field info if the structure of my app is not sufficiently described. All of the data are just filler to work on functionality.Many thanks,Gabe

MarkShnierYou · Answer

In general you can use pipelines to automate functions but without knowing more about your app and it's purpose, on the surface I would have to question why you need to increment counters in another table.

For example if you wanted to know how many times a particular record was created where a certain look up field was chosen, you can easily run reports for that or create summary fields for that.

So I would just caution you that maybe you want to be using summary fields and not fancy automated processes using pipelines

Sign up

Login to the community