Skip to main content

Hi! I created a base and interface for a game I have been playing, Schedule 1. Yes, it is a game where you create drugs based on different combinations and then sell those drugs 😛. I have included a public view of it below.

 

I have it basically how I want it, but I need a way, anyway, to

  1. From the drugs table, have a view that pulls the Teir 1 drug from any drug that isn’t a T1 drug.
  2. And then display in each row, the T1 drug, the different mixed supplies, and the drug effects.

The challange is, in the game, when you make the drugs, they randomize the names after mixing. So, what for me, mixing ‘Aspen Grool’ which is a T3 drug, might be called something different for another user. It would be rather daughting to dig through each drug combo and source it back to the T1 drug, so I was hoping there was a way to do it in a formula or view or something. Thoughts?

 

https://airtable.com/appXdxs1ShjFgTxFE/shrbWwxkofvHeaHNr

I don’t think you can do this with a formula I’m afraid.  You’re going to need to use a combination of lookup fields and an automation to link stuff up so that each tier of drug is linked to all of the lower tiers that were used for it

I vaguely remember doing this before but don’t have the time to get into it right now, sorry; hopefully someone else knows what I’m talking about and can guide you on it!

Reply


Terms & Conditions