Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
Web Server - Ask For Help / Re: Modify the lookup procedure?
« on: March 20, 2025, 04:33:10 AM »
Ron,
Thanks for the replies. I'll try your advice and get back to you.
Jeff
Thanks for the replies. I'll try your advice and get back to you.
Jeff
2
Web Server - Ask For Help / Re: Modify the lookup procedure?
« on: March 19, 2025, 10:41:33 AM »
Hello all,
I continue to work on this, now I'm taking a different route. I have a button next to a field that calls a memory form. See the attached image. The form has two date fields and a third numeric field. I want to enter the two dates and then populate the numeric field with the difference between the two dates. In the ValidateAll embed I have the following:
loc:DateInterval = loc:ReferenceDate - loc:TargetDate
For the ReferenceDate and TargetDate fields, I have set these to reset the loc:DateInterval field on the client-side tab. Still, the loc:DateInterval field is not filled in. I suspect my embed code is wrong and/or I'm using the wrong embed. Can anyone help with this?
Thanks,
Jeff King
I continue to work on this, now I'm taking a different route. I have a button next to a field that calls a memory form. See the attached image. The form has two date fields and a third numeric field. I want to enter the two dates and then populate the numeric field with the difference between the two dates. In the ValidateAll embed I have the following:
loc:DateInterval = loc:ReferenceDate - loc:TargetDate
For the ReferenceDate and TargetDate fields, I have set these to reset the loc:DateInterval field on the client-side tab. Still, the loc:DateInterval field is not filled in. I suspect my embed code is wrong and/or I'm using the wrong embed. Can anyone help with this?
Thanks,
Jeff King
3
Web Server - Ask For Help / Modify the lookup procedure?
« on: March 18, 2025, 12:03:09 PM »
Hello everyone,
I have a client that no longer wants to store dates in his app. Instead, he wants to store the number of days from a reference date. I thought I would set a new field to store the number of days and set it as a lookup. The lookup would call a procedure/memory form that allows the user to enter two dates and calculates the days between them. This new calculated value should drop into the lookup field. I use local variables on the memory form to store the dates and do the calculation.
I have the memory form called and it calculates the interval between the two dates. However, upon returning to the lookup field, the interval value is not dropped into the lookup field. I realize the lookup feature is meant to do a look up into a table but I thought I might be able to get it to do this by setting the lookup field in an embed, just before returning to the lookup field, but so far not able to do this. Any thoughts on how to make this work or an alternate way to do this? I prefer the lookup method over adding a button after each field and calling the memory form that way. That would be too many buttons to add as I have about 30 date fields to convert.
Thanks,
Jeff King
I have a client that no longer wants to store dates in his app. Instead, he wants to store the number of days from a reference date. I thought I would set a new field to store the number of days and set it as a lookup. The lookup would call a procedure/memory form that allows the user to enter two dates and calculates the days between them. This new calculated value should drop into the lookup field. I use local variables on the memory form to store the dates and do the calculation.
I have the memory form called and it calculates the interval between the two dates. However, upon returning to the lookup field, the interval value is not dropped into the lookup field. I realize the lookup feature is meant to do a look up into a table but I thought I might be able to get it to do this by setting the lookup field in an embed, just before returning to the lookup field, but so far not able to do this. Any thoughts on how to make this work or an alternate way to do this? I prefer the lookup method over adding a button after each field and calling the memory form that way. That would be too many buttons to add as I have about 30 date fields to convert.
Thanks,
Jeff King
4
Web Server - Ask For Help / Re: How to change name of output PDF report?
« on: October 19, 2024, 07:52:04 AM »
Hello everyone,
I think I found a solution, after looking at more posts here. In the PDF (PDFReportGenerator) Setup embed, I have the following:
p_web.HeaderDetails.ContentDisposition = 'filename="PREDICT2 Study ID Assignment_'&p_web.GSV('Enr:Study_ID')&'.pdf"'
The generated PDF displays in a new browser tab (have report set to use '_blank') and when I click to download the PDF, it now has a unique filename filled in for me. The filename no longer defaults to the procedure name. Next I'll test how this does with a few other browsers.
Thanks,
Jeff
I think I found a solution, after looking at more posts here. In the PDF (PDFReportGenerator) Setup embed, I have the following:
p_web.HeaderDetails.ContentDisposition = 'filename="PREDICT2 Study ID Assignment_'&p_web.GSV('Enr:Study_ID')&'.pdf"'
The generated PDF displays in a new browser tab (have report set to use '_blank') and when I click to download the PDF, it now has a unique filename filled in for me. The filename no longer defaults to the procedure name. Next I'll test how this does with a few other browsers.
Thanks,
Jeff
5
Web Server - Ask For Help / How to change name of output PDF report?
« on: October 18, 2024, 03:51:06 PM »
Hello all,
I have setup a simple Clarion report to output as a PDF using the Clarion Report to PDF template. I do get the report generated in a new browser tab but when I try to save it to the local drive, it defaults to the name of the report procedure. I have tried the following code in numerous report procedure embeds without success:
loc:PDFName = '.\PREDICT2 Study ID Assignment_'&p_web.GSV('Enr:Study_ID')&'.pdf'
Some of the embeds I have tried:
PDF (PDFReportGenerator), Setup, after parent call
Previewer (PrintPreviewClass), OnSaveAs
Prime Report Options when run in web mode
Can anyone tell me how this should be done?
Thanks,
Jeff King
I have setup a simple Clarion report to output as a PDF using the Clarion Report to PDF template. I do get the report generated in a new browser tab but when I try to save it to the local drive, it defaults to the name of the report procedure. I have tried the following code in numerous report procedure embeds without success:
loc:PDFName = '.\PREDICT2 Study ID Assignment_'&p_web.GSV('Enr:Study_ID')&'.pdf'
Some of the embeds I have tried:
PDF (PDFReportGenerator), Setup, after parent call
Previewer (PrintPreviewClass), OnSaveAs
Prime Report Options when run in web mode
Can anyone tell me how this should be done?
Thanks,
Jeff King
6
Web Server - Ask For Help / Re: Change background color of entire app
« on: October 15, 2024, 05:45:50 PM »
Hello all,
I think I found the mistake. I forgot the hash mark (#) in the hex of the color! Here is the working code now:
.nt-body{
background-color: #e6e6fa;
}
Thanks,
Jeff
I think I found the mistake. I forgot the hash mark (#) in the hex of the color! Here is the working code now:
.nt-body{
background-color: #e6e6fa;
}
Thanks,
Jeff
7
Web Server - Ask For Help / Change background color of entire app
« on: October 15, 2024, 04:14:17 PM »
Hello all,
For a current client, I maintain three versions of an app: one for training, one for testing and one for production. They want me to set the background color of the test and training versions to a lighter pastel color. I thought about adding the following to my custom.css file:
--site-background:e6e6fa;
.nt-body{
background-color:var(--site-background);
}
After running the GzipAll.bat, and doing a CTRL-F5, the background color is not changed. Any thoughts as to where I went wrong?
Thanks,
Jeff King
For a current client, I maintain three versions of an app: one for training, one for testing and one for production. They want me to set the background color of the test and training versions to a lighter pastel color. I thought about adding the following to my custom.css file:
--site-background:e6e6fa;
.nt-body{
background-color:var(--site-background);
}
After running the GzipAll.bat, and doing a CTRL-F5, the background color is not changed. Any thoughts as to where I went wrong?
Thanks,
Jeff King
8
Web Server - Ask For Help / Re: How to call a "secondary" form after saving main update form?
« on: October 15, 2024, 04:08:36 PM »
Hi Ron,
After looking at a few other posts here, I came to the same conclusion, use an in-row button on the browse. I can call a test report from this button now. This is not as "automatic" as the user wants but it should do.
Thanks!
Jeff
After looking at a few other posts here, I came to the same conclusion, use an in-row button on the browse. I can call a test report from this button now. This is not as "automatic" as the user wants but it should do.
Thanks!
Jeff
9
Web Server - Ask For Help / Re: How to call a "secondary" form after saving main update form?
« on: October 14, 2024, 04:34:25 PM »
Hi Ron,
I have tried your suggestion. In the Post Insert embed I have:
NewStudyIDForm(p_web) !!Call Memory Form
This does not seem to work as the memory form does not appear when inserting a new record. Am I calling the memory form correctly?
Thanks,
Jeff
I have tried your suggestion. In the Post Insert embed I have:
NewStudyIDForm(p_web) !!Call Memory Form
This does not seem to work as the memory form does not appear when inserting a new record. Am I calling the memory form correctly?
Thanks,
Jeff
10
Web Server - Ask For Help / Re: How to call a "secondary" form after saving main update form?
« on: October 14, 2024, 03:59:46 PM »
Hi Alberto,
Your suggestion is interesting. The normal process is to open a browse, do an insert and then return to the browse after a save or cancel. With your suggestion I think the user would be taken from the form to the secondary form and no longer be returned to the browse. Is this correct? If so this would not be what the client wants.
Thanks,
Jeff
Your suggestion is interesting. The normal process is to open a browse, do an insert and then return to the browse after a save or cancel. With your suggestion I think the user would be taken from the form to the secondary form and no longer be returned to the browse. Is this correct? If so this would not be what the client wants.
Thanks,
Jeff
11
Web Server - Ask For Help / How to call a "secondary" form after saving main update form?
« on: October 14, 2024, 12:24:42 PM »
Hello all,
I'm working on a NT 14.20 app. I call a NetWebForm procedure to do an insert and a Study_ID field is created and saved. Upon saving I want to pop up a second form that shows the newly created Study_ID and has a print button. The print button should call a report that has the new Study_ID and some instructional text. If the user does not click the print button, they can just close the second form and continue.
I have tried to adapt the Adding a Report section of the NetTalk Book, 4th edition, but have not been able to get this to work. Anyone have suggestions on how to do this?
Thank you,
Jeff King
I'm working on a NT 14.20 app. I call a NetWebForm procedure to do an insert and a Study_ID field is created and saved. Upon saving I want to pop up a second form that shows the newly created Study_ID and has a print button. The print button should call a report that has the new Study_ID and some instructional text. If the user does not click the print button, they can just close the second form and continue.
I have tried to adapt the Adding a Report section of the NetTalk Book, 4th edition, but have not been able to get this to work. Anyone have suggestions on how to do this?
Thank you,
Jeff King
12
Web Server - Ask For Help / Re: NT 14.20 API error
« on: September 03, 2024, 09:44:37 AM »
Hello all,
I think this is a prefix issue, like I had in April this year. In that case Bruce suggested setting jsonParameter.SetMaxPrefixLength(4) to something less than 4, the default. I'll experiment with this more later. But for now the workaround was to check Include Field Prefixes in the Options tab of the Parameters tab in the NetWebServiceMethod template.
Thanks,
Jeff
I think this is a prefix issue, like I had in April this year. In that case Bruce suggested setting jsonParameter.SetMaxPrefixLength(4) to something less than 4, the default. I'll experiment with this more later. But for now the workaround was to check Include Field Prefixes in the Options tab of the Parameters tab in the NetWebServiceMethod template.
Thanks,
Jeff
13
Web Server - Ask For Help / NT 14.20 API error
« on: August 31, 2024, 04:10:02 PM »
Hello all,
I'm getting an error 40 when trying to use an API to delete a record. I'm trying from the JSON Post example created in the API documentation in my app.
Please see attached image JSONPOST.png. I'm confused by the error definition as it indicates trying to save a record when I'm trying to delete a record.
Interestingly, the HTTPGET method does delete the record as expected. See image HTTPGET.png
I cannot see where the issue is in the JSONPOST. Can anyone help?
Thanks,
Jeff
I'm getting an error 40 when trying to use an API to delete a record. I'm trying from the JSON Post example created in the API documentation in my app.
Please see attached image JSONPOST.png. I'm confused by the error definition as it indicates trying to save a record when I'm trying to delete a record.
Interestingly, the HTTPGET method does delete the record as expected. See image HTTPGET.png
I cannot see where the issue is in the JSONPOST. Can anyone help?
Thanks,
Jeff
14
Web Server - Ask For Help / Media field type question, part 4
« on: August 26, 2024, 12:10:04 PM »
Hi Bruce,
I'm still working on my app with the Media field type on a form. One thing I have noticed is the Media field stays at the width and height set in the template...that is it is not responsive to resizing the containing form. Please see the attached image. Can you suggest a way to make the Media field width be bound to the right margin and the height to be bound to the bottom margin? I'm looking for some CSS to add to my custom.css file but have not found anything yet.
Thanks,
Jeff King
I'm still working on my app with the Media field type on a form. One thing I have noticed is the Media field stays at the width and height set in the template...that is it is not responsive to resizing the containing form. Please see the attached image. Can you suggest a way to make the Media field width be bound to the right margin and the height to be bound to the bottom margin? I'm looking for some CSS to add to my custom.css file but have not found anything yet.
Thanks,
Jeff King
15
Web Server - Ask For Help / Re: Media field type question, part 3
« on: August 23, 2024, 05:59:29 AM »
Hi Bruce,
I have searched Google but no answers yet. Another issue has arisen. The menu bar/tool bar has an icon for doing text annotations and highlighting of the displayed PDF. This shows in Edge browser but not in Chrome. Any thoughts on why? I'll keep searching.
Thanks,
Jeff
I have searched Google but no answers yet. Another issue has arisen. The menu bar/tool bar has an icon for doing text annotations and highlighting of the displayed PDF. This shows in Edge browser but not in Chrome. Any thoughts on why? I'll keep searching.
Thanks,
Jeff