Need views for automation
Use case: I want the data from Table A,B,C,D,E,F to flow into Table G. I want this table G have data whenever a new record gets created in the tables. Initally I created a relationship but that isn't...
Forum Discussion
How would I be able to get the report link for all the records which are being moved from table A to table G? Bulk pipeline is working well but it doesn't carry any sort of record link for the records in the primary table.--
MarkShnier__You
Qrew Legend
Qrew LegendJust have the pipeline write the table name and the [Record ID#] of the source table into fields in Table G. Then you can make a Report Link field in say Table A to match the Record ID# with the Table G [Record ID# of source record] and filter the report on only Table A sourced records.
Do similarly for each of the rest of the source tables.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks Marks. I am running a scheduled pipeline for this but somehow it is over writing the records from original table. Is there any solution for it?
------------------------------
XYZ
XYZ
------------------------------- MarkShnier__You
You would have to say in words what your pipeline is doing. You are saying it is over writing data in the consolidated G table? Or is it duplicating records there. Does your pipeline fire only when records are created or also when records are edited on the individual tables.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------I have created a bulk pipeline through which it searches record in table A and sends the data to table G.
1) Prepare bulk upsert
2) Search Records
3) for each Add a bulk upsert Row
4) Commit Upsert
But somehow duplicate records show up
------------------------------
XYZ
XYZ
------------------------------
