I doubt if the issue has been resolved as I get the error still. Until I specify a date, or do as suggested by inclusion in Before Edit the Null value couldn't be updated.
I just did now setting it to 2000px and even 100% at some other point, yet no changes. See list_page1.png attached.
For the dates that are null changing current date on List Page, It remains null if I clear FormatRecordField, which is suppose to define format for those with values. What is way to correct this? See list_page2.png attached. The BirthDate are all null in the database but displaying as current date.
Thanks for your response, but I am still far from solutions I desire.
1. Images not loading on my web server (recall you have connected to me on Teamviewer and you said it was access, my SP said no) 2. Resizing of field width on List page (refer to attached, I have tried to put even 100% but field is wrapped into 3 lines refer to attachments) 3. Reduction of Label font on the Page Design - this wasn't attended to) 4. How to update table field based on another field's current value ( It's actually not update but Before Update event to assign a value from a table based on current value on the page) 5. Custom code not published with new changes. For instance if I want the custom Edit page to be another page, I noticed this doesn't get changed once I closed the Custom view. (not attended to) 6. Null Date fields defaults to current date when viewing or List page. (not attended to)
I mean the users table showing the user name, login name, role, etc. You have to assign roles to users and set permission to the roles discretely. See attached. It worked for me.
1. Increase the ColumnWidthClass for a field on a List page. See attached page, I want to increase the width of ContactAddress. 2. For the Second attachment, when I click edit for a particular record, it opens always the first record, how do I get it to view/edit current or selected record? 3. Image/Photo not storing on my web server when are pages uploaded to the web 4. How to get currentuser() and current computer name as default to field values 5. How to update a field by selecting a value from a table based on the value of on the current page, before insert. The idea is to get a record like this onto the table: Dept UnitNo ACCT 1 ACCT 2 ACCT 3 ADMIN 1 ADMIN 2 SALES 1 SALES 2
So when a dept is entered, the unitno should be max(unitno)+1 where dept = current(dept) on the page.
Thanks for your reply, am using MySQL and I use auto increment well.
This is however different. The field unitid counts from 1 grouped by dept. That is, for each dept it starts from 1 so in the table you would have: DEPT, Unitid ADMIN, 1 ADMIN, 2 ACCT, 1 ACCT, 2 ACCT, 3 SALES, 1 SALES, 2 SALES, 3 etc.
Hello, I want to set a field value on a Page, Before Add, and it's not working well. I know am missing something.
The field 'unitid' on the page is to be set to max(unitid)+1 from table 'deptunits' where 'dept' in 'deptunits' = current 'dept' specified on the page. My current codes are:
$res = $db->rawQuery("SELECT * FROM deptunits WHERE dept='$dept' ORDER BY UnitID DESC LIMIT 1"); $modeldata['UnitID'] = $res['UnitID'] + 1;
I need current syntax that could help achieve this on the Before Add event.
