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 ------------------------------Adding an email hyperlink to body of formula-url
I have created an email button using the formula-url field. Within the body of my email, I would like to have a hyperlink to email for help. ex: &"If you see missing tests or errors in the upload process, please provide the error report to abc@abc.com for review and repair." I want abc@abc.com to be a hyperlink to open an email . How can I make this happen?
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?
