I know this has been raised before as a feature request but is there a way to add a default value to a date field through automations or some other mechanism other than pleading airtable to implement or a third party add-on? Thanks in advance
This is probably a stupid question but when designing a table, should the primary key (first column) be unique or not?
In my case, I have Projects and Tasks like
Projects (Fix House, Fix car)
Tasks (Repair bathroom sink, buy new steering wheel, repla...
Running into a problem creating an order tracking form.
I have 4 tables
Customer Info - name, address, etc…
Product List - products and prices
Orders - each row has customer name and product and product quantity purchased. Primary field is a formula ...
Looking to dynamically pull a specific record from Table 1 to Table 2 based on date. In other words
Table 1 has a list of names and dates.
Table 2 has the daily meal; what we’re eating everyday.
I want to pull what we’re eating everyday (Table 2) int...
I can’t thank the community enough for answering my questions! My next question is how to add a record from interface designer.
I have 2 tables; Names and Attendance. Names has all metadata associated with an individual person. Attendance table is go...
@Ben_Young1 Makes sense; how do I set the date field to today? I can only choose static or dynamic and neither option gives me a choice for a formula like always set to today. Thanks
@kuovonne Thank you. I should have clarified field vs key so thank you for that. What is the advantage to doing a two table system over a one table system? I always thought you’d want fewer tables where possible especially if the (in this case) tasks...
@Nathaniel_Granor Thanks, that template is great. I’m a bit confused and maybe you can unconfuse me. There appears to be a bit of circular logic between the Client Orders table and Order line items table where in the Order line items table, you assi...
@Nathaniel_Granor I should step back for a sec. What I’m trying to create is a database to take store customer information, store products and associated prices, take orders by customer by date, calculate totals and determine whether the customer has...
Here’s my Orders table, I think I figured out why I can’t pull the Quantity field because the Quantity is not unique to each Customer in the lookup; can you confirm that’s correct?
