How to verify if list of emails has correct domain?
Hello, I am working on an app where I set up a form where users provide different data. One field that I have is an email field called Notification Recipients. In this field users can provide multiple emails split with semicolon. For example: 'A.M@domain.com;A.M2@domain2.com;A.MM@domain.com'. I'd like the form to be accepting only the emails that have '@domain.com' and for others to provide an error message and not allow the form to be submitted. I tried to set up a formula field for that, but that failed for such list. I will be grateful for any hints or suggestions on how to solve my problem. ------------------------------ Arleta Maæka³a ------------------------------
Getting Report Formulas to follow Date Range filter rules
I have entered a report formula into my report to show all call types related to a user's ID # in the same column. For example, if user ID 123456 had one call on 5/1/22 for Call Type A and one call on 5/18/22 for Call Type B in the data table, the report would show only one line for user ID 123456 and in the Call Types column it would list both A and B showing that in the data user ID 123546 has had calls for both Call Types A and B. In my report I then added a filter to filter the report by a date range which would be selected by the user (Date of call is on or after <ask user> AND Date of call is on or before <ask user>). The report formula is not following the report filter I have added. For example: Expected Result - If the date range entered is 5/1/22 to 5/10/22, the report will show one line of date for user ID 123456 and only show the call type A that is in the data table for the call that came in on 5/1/22. Actual Result - If the date range entered is for 5/1/22 to 5/10/22, the report shows one line of data for user ID 123456 but in the call type column it still shows Call Types A and B even though Call Type B came in on 5/18/22 which was outside of the date range I selected for my filter. How do I get my report formula to only show results for the date range I have selected? ------------------------------ Brandi Sullivan ------------------------------
Create Child Report With Formula +
Create Child Record with Formula Hi everyone, I've just begun with quickbase and i need help with this problem: When creating a new sale record classified with a specific sale type, i would want to automatically create a new record containing the same values of the first one but with the amount multiplied by '-1'. Example: Record ID: Costumer Sale Type Inovice nº Amount 1 John CON 32 500$ Record ID: Costumer Sale Type Inovice nº Amount 2 John CON 32 -500$ It's possible?
Same button takes some one to a different URL based upon the state.
I am adding a Formula URL button to my form. When someone clicks on the button I would like it to take them a particular website based on the state. For Example: If someone is in the form for the state of Alabama, when they click the button, I want it to take them to the state of Alabama's website. If someone is in the form for the state of Arkansas, when they click the button, I want it to take them to the state of Arkansas's website. etc...... What would that formula look like? Thank you for your time. ------------------------------ Adam Ely ------------------------------
RIch text desktop vs mobile
Does anyone know why this doesnt display correctly on mobile? It works on desktop. On mobile, it shows the score and audit date, then stops. If i comment out the audit date line, then it shows score and domicile, then stops. Shows nothing else. It will only show one line after score. "<b>TO: field will include:<br></b>" & [UP Default To Email List Ver 1] & "<br><br><b>CC: field will include:<br></b>" & [CC Email List] & "<br><br><b>Score:</b> " & [Score Formula] & "<br><b>Audit Date:</b> " & [Audit Date] & //nothing displays after this. If I comment out this line, then the next line displays "<br><b>Domicile:</b> " & [Domicile - City and State] & "<br><b>Location:</b> " & [Location - Name] & "<br><b>Auditor:</b> " & [Employee - Preferred Name] & "<br><b>Vendor:</b> " & [Active Vendor Snapshot] & "<br><b>Driver:</b> " & [Driver's Name:] Near as I can tell there is a max number of lines it will show on mobile? If i add any lines up top, less and less shows from the bottom entries, and vice versa. ------------------------------ Mike Tamoush ------------------------------
Print Multiple Exact Forms
I know this has already been covered in a previous post quite a while back and just wanted to re open it in a separate post to see if I can get some help with my specific use case. Here is the old post: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=30308&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer For my situation, here is my setup at the moment: Work Requests>Poles>Field Work Work Requests have many poles and each pole has 1 field work record. I would've liked to put all field work info in the poles table but the field work table has over 500 fields in it and was a big endeavor at the time of creation so it was separated at the beginning and has a 1 to 1 relationship with poles. My exact form prints locate sheets in a particular format and is within the field work table and each pole will have 1 locate sheet. I want to be able to print all the field work locate sheets for the poles of a work request straight from the grandparent work request table via URL button. Some things I've tried-> I noticed on an ask the user report that "&nv=1&v0=75138760" was at the end of the URL after the qid and I tried combining the print URL with this to make: https://pike.quickbase.com/db/bpfpdy3bx?a=dbpage&sfid=497&pagename=Locate%20Sheet.html&clist=a&qid=23&nv=1&v0=75138760 ..to see if it would print multiple exact forms this way but it shows the exact form for a split second then just turns into a blank white screen, so I'm not sure what else I could do. I can't figure out a good way to make the report necessary to make the normal qid print method mentioned by Keith Jusas to work. Any suggestions? Thanks in advance, #Forms #Button #APIsandcustomcode #Formulaandfunctions ------------------------------ Jordan McAlister ------------------------------Formula-User field that shows value of another Nonempty user field
#field #Formulaandfunctions Hi. I have a formula user field FINAL USER that should show the User A if "User A" field is nonempty, else it should show User B, but if User B field is empty, it should show User C. If User C is empty, it should finally show User D. If I have this: If ( IsNull ([User A]), [User B],[User A]), then it works. However, I need to be able to have the conditions below in that FINAL USER field. Can you please help with the formula? If( IsNull([User A]), [User B],[User A], IsNull([User B]), [User C],[User B], IsNull([User C]), [User D],[User C] ) ------------------------------ Isabel Gumanid ------------------------------
Group and filter by "customized week"
#Formulaandfunctions #reportsandcharts #Formulasandfunctions Hello I would like to get assistance on how to group and filter records based on particular criteria: workweek from Wednesday to Tuesday. For example, on excel I can do it like this: so as you can see, I can count records if the date is between the range established in excel - from Wed to Tue. Basically the need is to group and count records based on customized date ranges. Each record has it own "Sent to 1st level Review date", I just need the count based on those ranges and then show them in Summary or Table reports. I hope it was clear enough. Thanks in advanced. Regards, ------------------------------ Sergio Sanchez ------------------------------
