Hello! I am pulling stats for an interface dashboard and I am trying to make sure I know what some of the terms mean exactly and have searched for term definitions but can't find a list. Does anyone know if one exists? Here are a couple of examples o...
I have a column that fills in the State Abbreviation from Jot Form. The form is a drop-down selection that is the same as my single select column in Airtable. Somewhere new duplicate selections are being generated with new submissions. I am trying to...
Hello all,We have an automation set up through Zapier that searches for a record and updates the record if it finds it and creates a new one if it doesn't. The problem I am having is that duplicate records are being created that match the search crit...
Hi everyone. I am trying to set up an automation where when a diagnosis field for a trip in one table is updated it finds the corresponding person (that is connected) in another table and updates a diagnosis field in that table where only different d...
Hi. I am creating a version of an automation that I didn't create. I have duplicated it, added a trigger and updated some copy in the code but I have a configuration error. I can't figure out how to get the custom script into the message. Screen grab...
There were 2 more instances today and there is a space being added. Because all of the instances are still coming from a dropdown list and I couldn't find an extra space anywhere. I did notice that both are passenger 3. There is a patient, a passenge...
That seems reasonable but the selection in the Jot Form is a drop-down and the answer to the drop-down is what gets pulled into Zapier then Airtable. Where would there be an opportunity to put a space in it? And when I fixed the duped States in Air...
TheTimeSavingCoI think I was wrong about that one not duping. I resolved all of the dupes this morning and just went in and all new files that came through today were duplicated. You seem to think you may have an idea if this was the case.
Hi Russell,This is the solution that I am looking for but it isn't returning the right number, I think because the values I'm trying to count have a comma in them. Would this be why and would you suggest how to fix? I am not a coder so modifying your...
Thats right. I'm not sure how a look-up field would solve it. We want to add the trip diagnosis to whatever is in the patient diagnosis field—if it is different. That field is connected to the diagnosis directory which I fear is the issue.
