Currently I have a table of leads. I would want to count the number of new leads/total leads/etc based on weekly, monthly, quarterly, etc. Or ideally even a custom date range.
Any ideas on how to implement this within AirTable?
I’m wondering if anyone has found a good way to do this. I’d like to import data from a spreadsheet. Then have a way to transform that data and populate existing tables within a base.
In my existing spreadsheet I would have columns that go to diffe...
I am creating a new base. Taking information from Excel and putting it into a table. Then I use Zapier to push the data into two different tables. Both tables have a column named “LocName”. I am trying to get Airtable to link the two based on th...
I think I have it working now. I loaded the table off a view. I added an import flag to RawData and created a view filtering from it.
I ran the zap and it worked!
Thanks for the help!
Correct. I have setup the Zap with a record in one table called RawData. It’s setup to populate a table named Leads when RawData gets new records. I tested and it worked. Then I pasted ~ 1K worth of records into RawData. Leads is not populating....
The problem I seem to have in Zapier is getting it to do this with existing data. I can create a Zap that will take the data from a table into another table when new records are created. However this doesn’t solve the issue.
I can’t import data int...