StevenNelson
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Time format in pipelines
I am trying to have a pipeline enter the current time and a time 2 minutes prior into two seperate fields. Below are the values I am using. It doesnt work because the format isnt allowed in a time of day field. How do I format the values properly? {{time.now}} {{time.now - time.delta(minutes=2)}}Customize report to only show certain records
I have an app where values get entered daily. I want to create a report that shows only the top 25 of all time and then a summary of how many of the top 25 were in each year. Not sure where to start? ------------------------------ Steven Nelson ------------------------------Re: Auto-Save
Here is some detail, Maybe you can tell me whats wrong with the code. Keep in mind I am a bit of a beginer at this. I have a parent table that users make an entry for requests. There are a few child tables associated with it that they may or may not need to add info into. I have a notification that is sent out once the entry is made, but I had issues with it including the child info or sending the notification everytime each piece of child info was entered (obviously dont want multiple notifications on one entry). So, I hid the save button, created a Submit button. When the user clicks the submit button after everything is entered, it redirects to a page that asks for one last piece of information and saves the entry and sends the notification. I had the notification look for that final piece of info before sending. Problem is that if no child info is needed, therefore the record hasnt been saved once already, for some reason it will not add the final piece of info. I guess I am telling it to edit when there is nothing to edit yet because the record hasnt been saved. Below is the submit button formula Attached is the Code Page. Submit Button // API URL to Add/Edit/etc. var text urlToExecute = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&_fid_11=" // Field to Popuplate with the user prompted input ; URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=3" // Open code page 3 & "&url=" & URLEncode($urlToExecute) // Pass in the URL to execute ------------------------------ Steven Nelson ------------------------------Auto-Save
Is there a way to trigger an auto-save event after a certain field on a form is filled and then have the same record stay open for continued edit. Kind of like how the autosave occurs for the parent when entering a child record. ------------------------------ Steven Nelson ------------------------------Re: URL button to edit then refresh page
I changed field 44 to a user field. I need to get rid of the "usertoname" part of the code but when I do it says "&" cannot be applied to a user field. What am I doing wrong? "&_fid_44="& User() ------------------------------ Steven Nelson ------------------------------Re: URL button to edit then refresh page
I figured it out URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&_fid_37=Completed" & "&_fid_39="&Now() & "&_fid_44="&UserToName(User(),"FF")& "&rdr=" & URLEncode(URLRoot() & "db/" & AppID()) ------------------------------ Steven Nelson ------------------------------URL button to edit then refresh page
I put the following code into a Formula URL field. The purpose is to change the status to completed by clicking the button. URLRoot() & "db/" & [_DBID_LOTO] & "?a=API_EditRecord&rid="&[Record ID#]&"&_fid_37=Completed" Works great, but it then goes to the response page below. Which I don't want. How do I modify the code above to simply change the status and refresh the page. ------------------------------ Steven Nelson ------------------------------Using Multi-Select field to chose related records
I have 2 tables, Tags and Temp Removal Requests. The tags table already has a few hundred existing tags. I want to be able to add a new removal request and reference multiple tags that already exist. There can be multiple removal requests for each tag and multiple tags on each removal request. I thought I had this figured out but I am having trouble with being able to select multiple existing entries. ------------------------------ Steve Nelson ------------------------------
