Recent Discussions
distance between two addresses
I am trying to calculate the distance between two addresses. I put the below formula in but came up with a distance of 5000 and it should be 3. var number OriginLat = [LatitudeVendor]; var number OriginLong = [LongitudeVendor]; var number DestLat = [LatitudePlant]; var number DestLong = [LongitudePlant]; var number Distance = Round(((69*($OriginLat - $DestLat))^2 + (53*($OriginLong - $DestLong))^2)^0.5); If($OriginLat =0 or $DestLat=0,0,$Distance) ------------------------------ Sarah Burres ------------------------------
Getting the DBID from an Alias
I want to be able to put a text field into a cell and it be the table alias, then another formula field that converts it to the DBID. Reason being when we copy an app, the tables stay the same, but the DBIDs all update and we have to go manually change all the juiced URLs.Limit Relationship Choices based on another field..
So I have a table, Purchase Orders. That table is a one to many child of Jobs. It's also a one to many relationship of Daily Reports. Daily Reports is also a child of Jobs. What I want is for user A to login, and enter 5 POs, and link them to Jobs. Then, user B logs in and clicks the "Related Daily Report" field and it's limited to ONLY the jobs selected by user A. Is this possible?
Only 10 Data Values
I'm creating a graph to show each of the 12 months (January, February,... December) data. I added the data values for January, February, etc. however, after October, I couldn't add November or December. The "+" is faded out on October data value. This happens whether I do a regular bar chart or horizontal bar chart. Is there a limit up to 10 choices of what to add for data values? The idea is to have each of the 12 months data show for each vendor I also want to create separate reports (for drill downs) for each vendor to show the 12 months of data. Is there a different way to set this up? Any is helpful. Thank you!API Button to edit record then redirect to external webpage
I have a button that was created to redirect the User to an external webpage that opens in a window that relates the quickbase record they are on. There is a variable in the URL formula that switches out a placeholder in weblink with the related record id for the external webpage based on the QB record. (Adding this piece of information in case that is my issue). This button as is works great. However, I want to now use this button as a trigger to start a pipeline by checking a box on the current record in addition to redirecting to the external webpage. I can get it to check the box but gives an error when trying to execute the next request to go the external site. I've used various methods I've seen on the forum, but it keeps giving me an error. Any help would be appreciated! Below is my latest attempt: var text URL="https://XXXXXXXXXXXX"; var text mPower=SearchAndReplace($URL,"mPower",ToText([License - Related mPower Location])); var text CheckFacilityNotify=URLRoot() & "db/" & [_DBID_RENEWALS_FEES] & "?act=API_EditRecord" & "&rid=" & URLEncode([Record ID#]) & "&_fid_184=true" & "&apptoken=xxxxxxxxxxxxxxxx"; $CheckFacilityNotify & "&rdr=" & URLEncode($mpower) Thank you, KellyHow to make a child form return to a specific step in the parent form
I have an application that the user creates child records in step 3 of the parent form. After the child records are created and saved it returns the user back to the parent form at step 1. Is it possible to change this so that when the child record is saved it returns the user back to step 3 of the parent form?
Copying data from a table to a seperate table on save/update
If I have a form that I am having a user fill out, what is the best way to copy that data (or specific fields) from that form to a new table? The form is for an approval and could be an "update" or a "new process" that needs to be approved. I'd like to copy all the requested updates to one table and the new requests to a separate table. Ideally, I'd like to send updates over from the main form as well (pending to approved/rejected, date modified, etc). I believe I could use a pipeline. Is that my best bet? and if so, is anyone aware of any decent posts that would provide a little guidance?
How to imitate Pipeline search results in text field?
Hey all, As the title says, I'm trying to replicate the format of what is returned from a pipeline search in text fields inside Base. Here's the scenario: I'm making invoices in QBO via a pipeline, but all of the information for the line items is on the same record as the header spread out over different fields. QBO requires I pass lines as a list, which is normally done via searching through the line items, but that's not possible in this case. I have anywhere from 5-10 fields on the invoice in Base that need to each become a different line item in QBO, so how do I make fields to mimic that list output to pass over?
