My Rocket and Launch-tracking "app", as implemented in Airtable

The Rocketry Forum

Help Support The Rocketry Forum:

neil_w

Ennui poster child
TRF Supporter
Joined
Jul 14, 2015
Messages
11,834
Reaction score
4,643
Location
Northern NJ
That's a bummer. I may have to do some research on offline options.
Indeed. I wish I had checked this out more thoroughly at the start; it might not have changed my own decision to use Airtable but I could at least have avoided misleading others.

Please keep us updated if you find something better that handles the offline case. There are a lot of database apps out there; unfortunately most of them are pay-to-download, and I wanted something that I could at least try out for free before committing. I'm going to do some research on this too.
 
Last edited:

neil_w

Ennui poster child
TRF Supporter
Joined
Jul 14, 2015
Messages
11,834
Reaction score
4,643
Location
Northern NJ
Also important: for those who want to try this, please check out this page describing the limitations of the free version: .

For me, 1200 records should comfortably last me the rest of my life, but for those who fly a *lot* and/or have hundreds of rockets to keep track of, that might not be enough. The Plus plan is such a jump in price (free -> $120/year) that I'm guessing most folks won't want to go there. So make sure you're comfortable with the limitations before diving in.

As for me, I'm going to try out Mobi DB, which lacks some of the flexibility of Airtable (i.e., no web client, no Mac client) but has some benefits (only $10/year for basic license, off-line operation, what seems to be tighter layout on forms). I'll keep reporting back here with whatever I learn.
 

Budro0

Well-Known Member
TRF Supporter
Joined
Aug 30, 2020
Messages
85
Reaction score
60
Just a quick update on my endeavors (and a prod to see how Mobi is working out). I went back to Memento and paid the couple dollars to get full functionality on my computer. I'm not sure I really needed it, but it was a lot easier building the database and inputting data. I think the free version has a fair amount of usability for me - https://wiki.mementodatabase.com/index.php/Feature_Comparison

At this point, I've built decently functioning rocket and motors table. I think the next step will be a launch table and launch site table. Launches will pull in info from the launch site, rockets, and motors tables and should have the ability to add notes, pictures, and (hopefully) flight data.

I *think* that once I have built everything, I can stop paying the $6 for the full desktop version and still have functionality of the PC and Android apps, with edits to the structure being more difficult.

That said, I will publish the templates on Memento so you all can give it a try. And to give Neil his thread back, I'll start a new one with that information when I get it all done.
 

neil_w

Ennui poster child
TRF Supporter
Joined
Jul 14, 2015
Messages
11,834
Reaction score
4,643
Location
Northern NJ
@Budro0 built something in Mememto DB: https://www.rocketryforum.com/threads/memento-db-better-than-a-notebook.165299/

I think the takeaway from this thread should not be to go use Airtable, or to use exactly what I've done here, although if you can work within the 1200 record limit for the free version and are OK with being tethered to the internet then it works great.

Rather, go play with available DB apps. It's really easy to put something together that organizes your data in a useful way, without needing any particular database expertise (you won't need to be writing SQL queries or anything if you don't want to).
 

jqavins

Helpful Smartass
TRF Supporter
Joined
Sep 29, 2011
Messages
5,636
Reaction score
2,728
Location
Howard, NY
3. Launches: This is a list of "launches", each of which is a single date. That's a bit limiting, but I couldn't figure out a straightforward way to enter a multi-day launch as an entity. It's just as well, probably; I really want a single date attached to each flight.​
It might work to make an Events table. Each record consists of an event name and links to one or more launches. For myself, I'd then name the launches "<Event> Day 1", "<Event> Day 2", etc. If one wants to (I don't think I would" one could break launch days down, say "<Event> Morning" or "<Event> Day 2 Night".

Also, I think you should add a Time field to the Flight table. One of the main reasons to have a database of flight data is to look for trends. "Hey, look at this; I've got more lost rockets between 2:00 and 4:00 than all other times of day combined! Guess I should lay off launching in the early afternoon."

Anyway, I'd like to give it a try. email address in PM to come in a moment.
 

neil_w

Ennui poster child
TRF Supporter
Joined
Jul 14, 2015
Messages
11,834
Reaction score
4,643
Location
Northern NJ
It might work to make an Events table. Each record consists of an event name and links to one or more launches. For myself, I'd then name the launches "<Event> Day 1", "<Event> Day 2", etc. If one wants to (I don't think I would" one could break launch days down, say "<Event> Morning" or "<Event> Day 2 Night".
Good idea, at least for those who attend multi-day launches... for me, so far, the number of multi-day launches I've attended is zero, and there are none in the foreseeable future. So I don't need that extra layer of hierarchy.

But you'll find that it's super-duper easy to add, once you start playing with it.
Also, I think you should add a Time field to the Flight table. One of the main reasons to have a database of flight data is to look for trends. "Hey, look at this; I've got more lost rockets between 2:00 and 4:00 than all other times of day combined! Guess I should lay off launching in the early afternoon."
That's a pretty good idea, and easy to add. [Not so easy after all. There doesn't seem to be a field type for "time" that you can enter yourself. It's either attached to a date, or auto-created (create time for the record, or modify time, or whatever) Could do it with a plain old text field, but then hard to do searches. Joe you can let us know how you solve this. :)]
 
Last edited:

jqavins

Helpful Smartass
TRF Supporter
Joined
Sep 29, 2011
Messages
5,636
Reaction score
2,728
Location
Howard, NY
Simple: I'll just hack the Airtable code behind the scenes to create a time data type, and make it available through the phone app and the web interface. They'll never know what hit them.

Or maybe not.

I'll give it a realistic shot and let you know what I come up with.
 

William Dieckmann

Machinedr
Joined
Jul 10, 2019
Messages
18
Reaction score
3
Just sign up for Airtable, send me your email address and I'll share it and you can try it out. It's all free, so no commitment.


I took the Estes values from their motor chart... A mistake I guess. I'll go fetch better values from Thruscurve.org.

Still need to think of a good solution to dealing with clusters and multi-stagers, with regard to Total impulse summation.

UPDATE: I repopulated with values from Thruscurve. Look better?
View attachment 455413
Wdieckm@gmail.com
 
Top