Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 10, 2024 09:10 PM
Hello,
Im am trying to find a way to automatically populate a list of linked records in a field. Without it I would have to manually add them one at a time which takes forever. I added photos below for reference
Sep 11, 2024 05:03 AM
Hi,
it should be easy, but I don't get your design. Why do you use such unusual self-linking in 'Link Location'?
About links to Revenue Ledger - I guess amount of records there must be near twice of Location table records and they should be linked here. How do you know which records to choose, and what fields do you have in Revenue Ledger table?
Sep 11, 2024 07:26 PM
So to explain the structure, which is probably inefficient.
My company offloads data for cellular carriers, we partner with companies that have properties where we can install cellular radios. These companies get a revenue share based on how much data each radio is passing. We Payout for each location but the location can have multiple radios. So I have the following tables in order of ownership
Users -> Clients (company) -> Locations -> Access Points (Wireless radios) -> Revenue Ledger.
The "Revenue Ledger" is a CSV I have to manually import, which shows how much data each radio has passed each week. I have linked the "Access Points" to the revenue ledger but what im struggling with is how to have another sheet that shows how much all the radios have earned each week at the location they are at. Thats what this "Location Revenue" sheet is for.
Sep 12, 2024 03:32 AM
Got it, you have link to Location table. I suppose it has some linking to AP table and you can add lookup representing a list of APs in each location? the same that you are trying to achieve in link field, but, in a format of simple text, not links.