Members - Omnis Forum

Obonye

Member

October 29, 2024 at 3:40 pm in reply to: Undefined datagrid customformat column

I have created an instance variable list with it’s subtyped assigned to a table class. Then I call a select statement from the table class to define the list. I right-click on the iList and yes, the columns are correctly defined. The datagrid is userdefined. The columns mode is defined as custom format. I also noticed that is I prefix the column names with the list eg iList.ColName, the undefined error goes away. But if I tab out of the column entry field, what I have entered becomes invisible.

Obonye

Member
October 29, 2024 at 5:56 pm in reply to: Undefined datagrid customformat column
I meant to say, if I prefix the $columndatacol with the variable list like this: iList.EmployeeFirstName, the undefined errors goes away. Though I’m not sure if this is the correct way of solving the problem. Now the issue, the data entered disappears in the column entry cell on event after.
- This reply was modified 9 months ago by Obonye Mato.

Obonye

Member

October 31, 2024 at 7:53 am in reply to: Undefined datagrid customformat column

the datagrid object has a $formatcell method:

Calculate lValue as iList.[pRow].[pCol]

If pCol<>1

Calculate lValue as jst(lValue,’n2′)

End If

# note, client executed method requires color parameter to be a string unless using a constant. Can alternativley be a HTML color string eg. ‘#FF0000’

If iList.[pRow].iTotal<0

# Calculate iHtml as styledtohtml(con(style(kEscColor,’#FF0000′),style(kEscStyle,kBold),lValue))

Calculate iHtml as styledtohtml(con(style(kEscColor,’rgba(255,0,0,1)’),style(kEscStyle,kBold),lValue))

Else

Calculate iHtml as styledtohtml(con(style(kEscColor,kDarkGreen),style(kEscStyle,kItalic),lValue))

End If

Quit method iHtml

Could this cause an issue with the command Do iList.$definefromsqlclass($tables.taPerson)

Obonye

Member

October 23, 2024 at 6:10 am in reply to: jsProgressBar Control – not really controlling progress…

Thank you for the generosity. I wish you would be kind enough to share same lib in version 10.22

Obonye

Member

October 10, 2024 at 9:21 am in reply to: File upload/download

Okay. I sure didn’t understand the sample FILE.LBS. I’ll try the file object instead.

Obonye

Member

October 10, 2024 at 9:10 am in reply to: File upload/download

Really, where are these files saved in Omnis before printing them over to the PDF folder location?

Obonye

Member

October 9, 2024 at 7:37 pm in reply to: File upload/download

Yes. I’m creating the PDF files in Omnis using the print to Omnis PDF device command. . To do this you must specify the path to save the PDF file. Meaning the file will be saved in a windows folder. But how can I email this PDF to a customer? 5,000 was just an example. It could be millions of customers or 50 customers. It could be a customer statement, bills, employee payslip etc. Still, I shouldn’t design the system to prompt a user to select which file to attach for each of the 50 customers then email.

Obonye

Member

October 9, 2024 at 12:24 pm in reply to: File upload/download

Hi Andreas,

Probably I’m approaching this the wrong way. This is the scenario: I’m thinking of generating customer statements as PDF files and saving them in a windows folder, then emailing them back to the customers. The reason I save them in PDF is to remain with a copy of the statement (with password encryption). So, if I have 5,000 customers, I will need to attach 5,000 pdf files to be emailed to different customers. The easier way would be to automate the file upload than the manual popup window prompt for the user to select each PDF file to attach to an email.

Regards

Martin O.

Obonye

Member

October 8, 2024 at 9:53 pm in reply to: File upload/download

I didn’t quite understand this explanation. Would this idea remove the user file attachment prompt to select the 5,000 files?

Obonye

Member

October 8, 2024 at 9:51 pm in reply to: File upload/download

Would that mean I create a loop, and the user selects the file to upload 5,000 times for each file?

Obonye

Member

October 8, 2024 at 11:59 am in reply to: Subform Set Panel

The CSS has worked like a charm. Love it! My week-long wait has finally paid off.

Obonye

Member

October 8, 2024 at 9:31 am in reply to: File upload/download

Imagine I have 5,000 account statements in PDF saved in my PC that I wish to upload into a list. Uploading these many files one by one would be an arduous task. Is there a way for Omnis to make this easier?

Obonye

Member

October 2, 2024 at 7:23 am in reply to: Subform Set Panel

Hi, the subform panelsset has $cinst.$title to define the name of the panelsset. Is there a way to assign the background color of the panelsset title?