Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Quick Base University
Skip main navigation (Press Enter).
on this day
between these dates
Back to discussions
sort by most recent
sort by thread
IP Address and Location
I am trying to match up IP addresses to determine the location of the IP address. I am primarily co...
IP addresses come in two varieties IPv4 and IPv6 . You are expressing your IP addresses as ...
IP Address and Location
Posted 04-26-2018 13:23
I 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.
Below is 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 US IP addresses.
Thank you in advance.
RE: IP Address and Location
Posted 04-26-2018 18:59
come in two varieties
. You are expressing your
numbers which is
. So I don't think your
blacklist / whitelist
technique is going to work based on saving the IP addresses in a table and using a formula to test for inclusion or exclusion. Moreover,
don't map cleanly to location and can easily be defeated by using a
If you want to prevent access from specific
information you probably have to use
and access a
I do use a
service in my
database to record where users are located. If you want to pursue a
solution fee free to contact me off-world using the information in my profile:
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Powered by Higher Logic