I am using AirTable for a Customer Service Inquiry tracking database.
I want to be able to enter each “Case” (a record or row) into an AirTable base and for it to be given a “Case #” that is +1 from the highest number listed in the Primary Field colu...
Thanks @Csaba_Vass
Let me know if you see anything when you look at it later.
I think I follow you… when you add a new date to the table ‘electricity’ will it automatically add the date to the ‘calculation’ table or do you need to keep adding dates t...
@Csaba_Vass no worries on the late response. My question is how did you create the shift in the data such that you have a single row with two different dates on it such that you could calculate the difference. It seems that once I can get the data ...
Thanks… this method works!
Now the only problem I have is if someone makes a mistake and deletes a record, a new record will be created with a gap in between the case #'s.
I don’t suppose you have any ideas on how to prevent this from happening, do y...
How did you create the shift in the “last date” and “Check date” columns of the electricity calculation table?
It looks like these two columns are sent to this table using the Link To field type in another table…or am I wrong?
you have the primary fi...
Unfortunately, no.
I do not want to change anything in the list of existing numbers in the primary field as these are historical cases where the numbers shown are records that cannot change.
I need to have the list continue from this point forward in...
