ContributionsMost RecentMost LikesSolutionsRe: IRR and discounted payback period formulaHello Naveed, Did you ever get a solution to calculating the IRR in QuickBase? ------------------------------ Gabriel Figueroa ------------------------------ Re: Need help developing script to run NPV and IRR functionsHi Dustin, Did you ever get a resolution to this question of calculating IRR & NPV? Thanks, ------------------------------ Gabriel Figueroa ------------------------------ Formatted text file with .prn as file extensionNeed to generate a text file based off the QuickBase data. The file needs to look like the below with exact line/column spacing. It must be a text file but will have a .PRN file extension. Jinja s/b able to format the data as below using Pipeline but Pipeline only generates a .csv file. Any help would be highly appreciated even if recommending a Partner AddOn. One Partner can't produce a text file even though they can create formatted .pdf/.doc documents. Anything in italics (below) will have values from QuickBase fields. XXX1,SPECIAL PRF C02,0001, / / ,00:00,0001,1,0001,S,$PRICE XXXX XXX Pricesheet for COMPANY NAME. Attention: Pricing Terminal EFF Date Time Product Price River City Fresno KM 08/05/2021 19:00 CA2ULS 2.9850 River City Fresno KM 08/05/2021 19:00 CA2ULD 2.9900 River City Fresno KM 08/05/2021 19:00 U87C10 2.8500 River City Fresno KM 08/05/2021 19:00 U91C10 3.1525 <!--END OF FILE--> ------------------------------ Gabe Figueroa Miami FL 214-490-1719 ------------------------------Re: EOTI (Everyone On The Internet) URL Link opens to a Grid Edit Form of specific records.Post Note: Was able to resolve this by setting up a Report Link. Thanks to Stuart Gardner QuickBase Support Tech. This allowed the Grid Edit to be used & didn't allow the "Cancel" button to drop the customer back to the form that had the dropdowns where they could click & potentially see other customers data. ------------------------------ Gabe Figueroa Miami FL 214-490-1719 ------------------------------ Re: EOTI (Everyone On The Internet) URL Link opens to a Grid Edit Form of specific records.There will be some data pre-populated so that the customer can make decisions as to which records they will want to have their information recorded. The reason for the Grid Edit is because there can be potentially 5 to 360 (or more) records for each customer to input their data. These same records are sent out to multiple customers. The records are duplicated for each customer so they only see their data. The PIN is intended to allow the customer to only see their records. Many of the fields will be copied & Fill Down from the original while a few others will not. The customer will be able to edit each individual record if desired. ------------------------------ Gabe Figueroa Miami FL ------------------------------ EOTI (Everyone On The Internet) URL Link opens to a Grid Edit Form of specific records.The EOTI link is sent via email works by having an (8) digit pin appended to the URL link. The (8) digit pin will identify which records are to be displayed in Grid Edit form. After clicking the link in the email, all Grid Edit functions work fine as well as the "Apply Changes", "Save". When the "Cancel" button is clicked then the EOTI user is redirected back to a form that has a dropdown list of all the other "pins". They could start "browsing" all the other entries from the other customers. I've blocked out all reports to the EOTI group. First question, is there a better way to link the required records to be edited other than with a passed parameter such as shown below? https://company.quickbase.com/db/dbid?a=q&qid=21&nv=1&v0=21E402347. I read some other EOTI questions but they seemed related to adding/editing records then redirecting to a blank (or "Thank You") page after clicking Save. Thank you all for any help on this & especially for those who've been tremendous help on my earlier issues. ------------------------------ Gabe Figueroa Miami FL ------------------------------ Need value from table B to use in Table A's formula based on (2) fields in Table A.Each day Pricing is sent out to various entities & requires the latest pricing information. table B is updated once a night around 6 PM with the Index Date, Index Name & Mean Price. table B has a history of Mean Price records. each night the latest Mean Price for about (8) different Index Names are added. table A has many records that once various dropdown selections are made tend to stay set. table A needs Table B's most recent Mean Price value. the user will select (2) fields which will determine what table B's record Mean Price to use: 1) Same or Prior Day (this may change but extremely rare) 2) Index Name (once selected then will not change) Really do not want the User to have to click thru each of Table A's records to update the value manually. For the time being there are only (2) Index Names that would need to be used as the other (6) are not referenced (so far) in the formula that has been brought over from a highly evolved Excel macro workbook. I've attempted to setup a Summary record using the maximum Record ID# but it does not seem to work else I am (likely) confused. table B is currently setup as the parent table to table A. ------------------------------ Gabe Figueroa Miami FL 214-490-1719 ------------------------------ Re: Add Record then Add Child to Record with Button PushThe user will be on a new Add record. The new Add record form will have a dropdown of Solicitation records from another application whose data is maintained by another team. Once they select the Solicitation then if they could save the record & stay there that would be great. The reason to stay on the newly added record (in Edit now) is so that they can start selecting as many or as few transportation companies as required due to how large or small the Solicitation is. ------------------------------ Gabe Figueroa Miami FL 214-490-1719 ------------------------------ Re: Add Record then Add Child to Record with Button PushThank you, the issue was the apptoken. Honestly that had crossed my mind earlier but got distracted. The function works but it is adding a blank record &redirecting me to that record and not the one I intended. If I were to subtract 1 from the myrid then I would land on the record desired but the blank records would still get created. ------------------------------ Gabe Figueroa Miami FL 214-490-1719 ------------------------------ Re: Add Record then Add Child to Record with Button PushHello Sharon, I am getting the below message. The only difference was that instead of going to a Child record I wanted to stay (go to) the parent record just added. ------------------------------ Gabe Figueroa Contractor Miami FL 214-490-1719 ------------------------------