Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jul 30, 2022 12:10 PM
In Table A, I am trying to create three columns whereby each column would automatically and randomly select a person listed in Table B (same column), whenever a new record is created in Table A.
However, these are the additional requirements:
Here’s an example.
TABLE B (the list of persons that would be randomly selected from in Table A)
TABLE A (what would be a correct random selection given the parameters)
Table A meets the requirements, because it:
Aug 01, 2022 12:35 AM
Hey man, given these requirements (especially the need for it to be random), the simplest way to handle this is probably with a script. There’s no easy way to do random selections in Airtable as far as I know
If you end up going down the script road, I’m available to be hired to do it too; this seems like a big enough project that I can’t throw something together quickly, sorry
Best of luck man, sorry I couldn’t help more