I am trying to learn to use automations to update 2 summary tables so I do not have to keep copying and pasting every time I update a table.Table for new record: Donations. Summary Table: Donation Totals Yearly Summary Report.The two table are link...
{Rate (from Contract LU)}/{Frequency (from Contract LU)}Rate is a currency field and Frequency is a number field. Both reside in the Contract LU table.I have been using the above simple formula in invoicing successfully for quite a while. I recently ...
I have a table of all USPS zip codes and their respective cites and states. It has over 33,000 records. I would like to be able to use it in another base without having to copy it into the other base which causes it to go over its record limit.Is the...
Hi, as a result of my trying to execute a solution from previous post, I created a formula to combine name fields. IT cannot figure out what aim doing wrong. IT seems perfectly logical to me. But it does not work. I have posted the formula and a scre...
I have a question about how to handle member data in a specific set of circumstances.I have a membership base. One table has the members' names and organizations they belong to, if any, in it. People join this organization. Sometimes they join as sin...
This is for a Rails to Trails that doesn't have money projects like this. I have a lot of years of experience with Access. But. find the formulas in Airtable different enough from Access Basic that I have trouble with them. There are a lot of things ...
Ok, again thanks. The error are gone but one last issue. The formula is putting an AND after all the First Name Last Name Results.Here is the formula as it stands now. TRIM(
{First Name} &
IF(
{Last Name} != {SP Last Name}, " " & {Last Name} & " and...
Hello and thanks. The formula still causes an error. Unfortunately, Airtable does not give you any clue as to what is wrong. So, I'm at a loss. The field names are correct and there are no red error marks in the formula itself. I just says it is an i...
Hi and thanks for the response.How do you link records within the same table to form relationships? I was thinking that I could enter each person individually then connect them somehow. But I had no ideas if or how to do that. if, as you say, I can l...
