I'm trying to build and farm data app and maybe it's a very silly problem, but I'm stuck with it. I have a table where i can add every new mum that we have in a herd (other table), and I need if possible that they can recognize this new data (same cow number in two table) and delete the row (herd table), leaving me with no cow numbers repetitions.
Appreciate the help
Thanks
Instead duplicate the new record, what I would do an action group that moves the record from the herd table to the mum table.
https://support.google.com/appsheet/answer/10107706
Thanks I'll try!!
Also consider the option of working with only one table and in an enum type field, it includes two options;
- herd
- mum
User | Count |
---|---|
16 | |
11 | |
9 | |
8 | |
4 |