ContributionsMost RecentMost LikesSolutionsRe: Remove extra space when using a formula QuieryHello Prashant, That worked perfectly. Thank you ------------------------------ Jennifer Silberstein ------------------------------ Remove extra space when using a formula Quiery Hello everyone, I have a formula that brings in data from another table and it could have multiple results. When I do there is an extra space at the end before the ";". I have been trying to figure out how to get rid of the space but no luck. I either remove all spaces or I only get part of my results. Formula: ToText(GetFieldValues(GetRecords("{8.EX.'"&[Project]&"'}", [_DBID_X]), 286)) Result with extra space before the ; 1 % ; 1 % ; 1 % or 5 mg ; 10 mg Trying to get 1 %; 1 %; 1 % or 5 mg; 10 mg Any help is appreciated. Thanks ------------------------------ Jennifer Silberstein ------------------------------ Re: Already Populated Grid Edit optionHello Prashant, Thank you for the assistance! I totally forgot about copy master, I might try that before I do the API_Edit as I am not as familiar with the API calls. Thanks again. Jen ------------------------------ Jennifer Silberstein ------------------------------ Already Populated Grid Edit optionHelloAll, I am looking for a way to have an option, either a button, report or maybe a pipeline that is like a grid edit that already has come field filled out. If you were to use the button idea, you would hit the button and a grid edit report would come up. When it did it would have all 28 of my products filled out plus 2 other fields and allow the user to then fill out the remaining field on the report. They would hit save and all 28 product orders would then be added to our list. My list of products isin another app but I can easily add a sync table to the app where the orders are for ease of connection if needed. Basically when we get a new customer, we have to enter in orders for all 28 products and just looking for a way to save the team time as grid edit only has 5 rows to start and adding rows and the copy/paste gets tedious. Any help is appreciated. Jen ------------------------------ Jennifer Silberstein ------------------------------ Greater/less than with negative number formulaHello, I am having trouble figuring out why my formula doesn't work. I have tried several versions and none have worked so I need help. I have a field that is a % that could be negative or positive. I need to create a formula that says if that % is -3% or higher that is exceeding, if it is below -4 that is bad. So, -1% good, -18% bad, 25 % good, etc. This is where I ended up but still not working, it makes everything good or bad, there is no separation. I even tried separation, -1, -2, -3 out in the formula but still no luck. If([%]>=-3, "Exceeded", If([%]<=-4, "BAD")) or If([%]>=-3, "Exceeded", "Bad") Any help is greatly appreciated. ------------------------------ Jennifer Silberstein ------------------------------ Trying to alternate row colors based on creating a new row numberHello, I am trying to create a report that has alternating colors for the rows. I can't us the record Id because the Record ID is not in sequential order when filtered (as seen below). I have been searching on how to create a new record number or something for the report itself to help do an alternating number or even/odd to use with a formula for colorizing rows, but not luck yet. Hoping someone has encountered this problem and has a fix. Here is a sample of my report where I am trying to alternate colors. My report can change weekly so I need something that will change with the report. Name Record ID# Date Quarter Vixen 776 1/21/2022 Q1 Chicken 711 2/1/2022 Q1 Clothing 709 3/1/2022 Q1 Dip 721 3/1/2022 Q1 Mystery 750 3/1/2022 Q1 Mop 747 3/7/2022 Q1 Launch 736 3/17/2022 Q1 Launch Chicken 737 3/17/2022 Q1 Class 710 3/22/2022 Q1 Thanks ------------------------------ Jennifer Silberstein ------------------------------ Import multiple workbooks from one excel file to a single/multiple table?Hello All, I am looking for a way to bring in an excel file that has multiple workbooks in the file into one table or multiple table in a single app, is that possible? Thanks ------------------------------ Jennifer Silberstein ------------------------------ Re: Color part of the background in a fieldHello Jeremy, Thank you that worked perfectly. I have never seen the inline-block so I will have to remember that for next time. Jen ------------------------------ Jennifer Silberstein ------------------------------ Color part of the background in a fieldHello, I have a filed that I need to color part of the text and not another, example - 30%/30% I have gotten close, however there is an invisible line break with the color formula I can't figure out. Here is my formula: var text targetl=Left([Target], "/"); var text targetr=Right([Target], "/"); var text targetlc="<div style=\"background-color:yellow;\">"& $targetl &"</div>"; $targetlc & "/" & $targetr The formula leaves me with the below text and I am trying to get them to be on the same line. I have tried a few different variations but still I end of up with two separate lines. 30% /30% Any help is appreciated. Thank you ------------------------------ Jennifer Silberstein ------------------------------ Color part of the background in a fieldHello, I have a filed that I need to color part of the text and not another, example - 30%/30% I have gotten close, however there is an invisible line break with the color formula I can't figure out. Here is my formula: var text targetl=Left([Target], "/"); var text targetr=Right([Target], "/"); var text targetlc="<div style=\"background-color:yellow;\">"& $targetl &"</div>"; $targetlc & "/" & $targetr The formula leaves me with the below text and I am trying to get them to be on the same line. I have tried a few different variations but still I end of up with two separate lines. 30% /30% Any help is appreciated. Thank you ------------------------------ Jennifer Silberstein ------------------------------