One of my tables is “Accounts” and it has gotten really wide (40+ fields) and growing.
(Name, ID, Address Complete, Address1, Address2, City, State, Zip, Phone, Fax, Comments, Attachments, COD status, Credit Terms, Tax Exempt, Tax Exempt Number…)
I’v...
If I wanted to show a chart (in a block) of my orders from the last week, is there some way to filter by most recent X days in the chart block?
Otherwise, I think I will create a new formula field which would only populate the most recent week with d...
I’d like to use a form to enter data into multiple tables as discussed here:
https://community.airtable.com/t/form-edit-multiple-tables/5454/4
(separately discussed, I’d also need to enter data into multiple records as discussed here: Multiple Record...
Does anyone use an external tool for viewing/creating/editing complex formulas? Is there a tool that you like to copy and paste your complicated formulas into? Notepad++, Visual Studio? I know you would lose the linking to existing fields and the ...
Fundamental architecture question:
I want to try creating quotes, work orders, and pricing with Airtable.
A quote would have normal data (like linked customer names, date, and valid-until date…) but it would also have line-item descriptions plus unit...
Thanks for all of the thoughtful responses.
3 follow-ups that I haven’t quite grasped:
If one of my main concerns in data corruption, is there a difference between:
a) making a new table (with US States, for example) and linking it
b) a single-selec...
That’s similar to the advice I’ve seen from online searches, but what am I risking (performance, corruption, visual organization…) by keeping all of my fields within one record within one table? It seems like from a users perspective things are easi...
Same here. We track jobs by job name and sometimes people will refer to a job by slightly different names. When we realize the jobs are the same I would like to combine the records.
Please update/fix this. As discussed, the longer it goes the more formulas I have that include a *.01 calculation will need to be fixed. Just to be clear, it’s worth the short-term pain to fix as soon as you can.
Alternatively, if the delay is fear...
I’d like to see this too. I link an account (required) and a contact (optional) to an opportunity. I’d like to only see contacts from the previously selected account when entering the contact.
