Create Child Record, Save and then Edit button
When I press this URL button it just hangs. Any ideas? I am getting this code from Magic Buttons The button: URLRoot()&"db/"&AppID()&"?a=dbpage&pagename=createchildsaveandedit.html&targetdbid="&[_DBID_Estimator]& "&referencefield=11"& "&rid="&[Record ID#]& "&apptoken=xxx" The code page: <!DOCTYPE HTML> <html> <body> <script> const urlParams = new URLSearchParams(window.location.search); const rid = urlParams.get('rid'); const apptoken = urlParams.get('apptoken'); const targetdbid = urlParams.get('targetdbid'); const referencefield = urlParams.get('referencefield'); const xhttp = new XMLHttpRequest(); xhttp.onreadystatechange = function() { if(this.readyState == 4 && this.status == 200) { const response = this.responseXML; const redirectUrl = "https://" + window.location.hostname + "/db/" + targetdbid + "?a=er&rid=" + response.getElementsByTagName("rid")[0].textContent + "&rl=bbv"; location.href = redirectUrl; } }; xhttp.open("GET", "https://" + window.location.hostname + "/db/" + targetdbid + "?a=API_AddRecord&_fid_" + referencefield + "=" + rid + "&apptoken=" + apptoken, true); xhttp.send(); </script> </body> </html>
Checkbox Formula - only pertinent records
Hello all, trying to have a checkbox formula that will look to see if all checkboxes are checked for a section, which I have working. But I need to limit it by project, so it doesn't think they are all the same, since each project will have its own checklist. How do I alter the syntax to correctly only associate the checkboxes on the same project? If( ([Yes] = true and [Section] = "Lorem Ipsum") or ([No] = true and [Section] = "Lorem Ipsum" ) or ([N/A] = true and [Section] = "Lorem Ipsum"), AND <I need to limit this to only items on the same project> Ive tried to put in and GetRecords("{16.EX."&[Project - Record ID#]&"}",[_DBID_CHECKLISTS]) But it returns the error "The operator 'and' cant be returned on types 'bool' and 'recordlist' What syntax am I missing to limit the IF check to only items that are part of the same project?
Date to show as MMM YY
I have a due month formula field that needs to be sorted and reported by date and not by text. I'm trying to have it show as MMMYY (JAN24, FEB24, etc) since it's just a due month and not a specific date. I have a "dummy" date field that's the first day of the month, and I am using a formula text field to get the right formatting I need. I have the date field formatted as the abbreviated month, but it still includes the day. I'm using the formula below, but it says the first Month (red and bolded below) can't be used as a variable name. I copied this from another thread that worked for everyone who responded in it. What should I put there instead to get the date to change to the text month? Am I missing a step somewhere? Is this even the right way to go about this? var date DateWords = [My Date Field]; var text Month = Case(Month($DateWords), 1, "JAN", 2, "FEB", 3, "MAR", 4, "APR", 5, "MAY", 6, "JUN", 7, "JUL", 8,"AUG", 9,"SEP", 10,"OCT", 11,"NOV", 12,"DEC"); $Month & "" & ToText(Year($DateWords))
Formula using Contain
Hello, I'm trying to count how many records I have that have for Field "Account Name" that contains the work "Wire" and the Field Name "Funding Indicator Name" that contains ASC. I'm not getting an error for the way I did the formula but its not counting when the two fields on a record have the "contains" word. If((Contains([Account Name],"Wire" & Contains([Funding Indicator Name],"ASC"))),1,0) Appreciate any suggestions. Thank youImpact to existing data by changing a field from a radio button selection to a formula?
This is probably common knowledge but I'm having trouble finding the answer. If I change an existing field entry on a form from a radio button selection to an auto-populated field based on a formula, will only new entries be affected or are there other considerations I should be aware of to ensure I don't lose historical data?Formula to populate a field based on another field that contains a specific text string?
I'd like to have a field on a form automatically populate based on if a specific text string exists inside of another field. Let say field 2 will be populate with the text "red squadron" if field 1 contains the text "red". Can I do this with a formula using contains or would I need to create a table where all possible combinations that contain the text "red" would align to being in red squadron?Summary Table
I am having difficulty getting my mind around this to even begin. I need to summarize the Revenue for a project: The Revenue Date can be a single, or multiple dates, and the Revenue Amounts can vary. Upper management wants to see this on a single form, which is no issue as I have the following: Revenue Start 1, Revenue 1, Revenue Start 2, Revenue 2, and so on. The issue is how do I create a Summary Table that combines all the Revenue Start Dates in the correct month column and the Revenue Amounts? The Summary example below is when we had one record (form) for each Revenue Start, and Revenue Amount. I need the same thing when all of these dates and amounts are on a single record (form)...
