ContributionsMost RecentMost LikesSolutionsRe: Pipeline and Google Sheet: Append a Row IssueUnfortunately in Step A the only thing I do is pick which Quick Base fields that I will want to bring into Step B. I don't see an option then in Step B to remove / exclude those columns (fields) in the Google Sheet I don't want the Pipeline to touch. It seemed like the only option was to leave those columns blank and not map over a field from Quick Base. ------------------------------ Ken D ------------------------------ Re: Pipeline and Google Sheet: Append a Row IssueSince nothing in mapped in the Pipeline for N and O there isn't anything to be shown in the Google Sheet. However, the formula and data validation requirement are cleared out after the other fields get populated. I was under the impression that the {{CLEAR}} was also needed to clear a field which is why I was confused by what was happening. In Step A I can select the fields from Quick Base that will be used in Step B, but I don't see a way in Step B to not bring in the columns from the Google Sheet that I don't want to be touched. Thank you for the comment. ------------------------------ Ken D ------------------------------ Re: Pipeline and Google Sheet: Append a Row Issue Hi - Not sure what is most helpful. Here is the general summary of the setup. Without providing client specific information here is where the fields stop being mapped and how the fields are then left blank (please note I have since added another field so that the original sequence is slightly off above but doesn't change issue). ------------------------------ Ken D ------------------------------ Pipeline and Google Sheet: Append a Row IssueHi - Looking at the new Google Sheet Pipeline we have been able to successfully use a Quick Base trigger on a record to append a row on a Google Sheet. However, the issue is that when we append a row any columns that have some type of pre-existing information in it is wiped out. This includes data validation requirements or/and formulas even when we do not specifically map over Quick Base fields to those columns. Example: Our Google Sheet action maps out fields to populate data from Quick Base into columns A - L. In Columns M - O we do not map any fields over from Quick Base and leave it blank. On the Google Sheet Column M is a Data Validation field showing a list of options our client completes (dropdown list showing Yes, No, NA) On the Google Sheet Column N is blank (for our client to provide their response) On the Google Sheet Column O is a formula field (an If statement based on information in Column A vs. what client places in Column N). After the Pipeline runs the dropdown and formula in Column M and O are now cleared. Looking at the Quick Base Pipelines Help page, About Jinja, I read it to indicate that if the field is empty it will not over-ride data. However I'm experiencing something different and was hoping there may have been something I missed to prevent clearing out fields in Column M and O. ------------------------------ Ken Ken ------------------------------ IP Address and LocationI am trying to match up IP addresses to determine the location of the IP address. I am primarily concerned with flagging IP addresses that are from outside the U.S. I was able to download a file that shows a range of IP addresses by Country. This file is >200K records. My thought was to just use the US IP ranges (19K records) and just flag any that came from outside the US. Belowis an example of 3 records for US IP Ranges: IP Address Range is 18332160 - 18332415 IP Address Range is 34603008 - 34603263 IP Address Range is 34607872 - 34608127 With the new Quick Base Audit records I can get the IP addresses for log-ins and use that in a table, but have not figured a way to take the IP address and cross-reference it against the list of 19K ranges. I tried a formula field with an If statement similiar to ([IP address] > 18332160 AND [IP Address]<18332415) OR([IP address] >34603008 AND [IP Address]<34603263)... repeat for 19K rows, but the formula is too large. I am trying this with not only the Quick Base audit log-in records, but for other systems we utilize which we'd like to verify log-ins are only from USIP addresses. Thank you in advance.Re: List - User field used to create child recordsHi Blake - Thank you for the response. I like the idea of child records and using grid edits. My only problem with that is my users have been adverse to grid edits before, but I just may need to give assurance it's okay and an issue they need to get over. I'll most likely move in this direction. Again, thank you. List - User field used to create child recordsI have a List - User field where I select personnel that need to attest to a specific training (parent record). The training table is related to an attestations table (child record). I'd like to have a way to automatically looks at the List - User field and create an attestation record for each personnel in that field. Is there a way to trigger a child record for each user in a List - User field?