This topic is locked

Apply on Edit Page as Well

5/8/2009 5:27:57 PM
PHPRunner General questions
C
comlan author

I am trying to apply a default value to an "Add Page".
I do not want the default to be used on the "Edit Page."
Even though I have not checked the box "Apply on Edit Page as Well", my default values are being applied to the "Edit Page"
A change in default value is applied to both the "Add Page" and "Edit Page".
What do I need to be doing different to have independent control over the "Default Values"?
Thanks

lewisgr 5/8/2009

I had the same thing happen to me this week and here's what I did:

  1. Goto "Edit SQL query"
  2. Choose the table that has the field
  3. Choose the tab "SQL" it's the second tab
  4. Find your field in the SQL code

Select LastName,

FirstName,

City

from contacts;


Let's assume your field is "City" do the following:

Select LastName,

FirstName,

City,

City as 1_City // or any any name you want

from contacts;


Then you use the 1_city in place of city on the edit page. I went ahead and had both checked and deleted the row I didn't want. It works great! Thanks Jane for the suggestation early this week.

I am trying to apply a default value to an "Add Page".

I do not want the default to be used on the "Edit Page."
Even though I have not checked the box "Apply on Edit Page as Well", my default values are being applied to the "Edit Page"
A change in default value is applied to both the "Add Page" and "Edit Page".
What do I need to be doing different to have independent control over the "Default Values"?
Thanks

C
comlan author 5/9/2009

Thanks for the reply.
I want to use a default or lookup value on the "Add Page" only.

The "Edit Page" should show the value assigned on the "Add Page", but should be manually editable.
Isn't this what the "Apply on Edit Page as Well" should do, or just what is this checkbox used for?

lewisgr 5/9/2009

You can but there isn't a way the break the field apart like you want unless you want to use some coding on the page. I'm new to PHPR so I don't really know what the "Apply on Edit Page as Well" but I would think it would be just for those setting that in the box area. The solution I gave will allow you to do what you want. The only thing is which field do you want to create the lookup for and other should be a text box. Maybe I'm not understanding the use of the lookup. How do you have it setup?

Thanks for the reply.

I want to use a default or lookup value on the "Add Page" only.

The "Edit Page" should show the value assigned on the "Add Page", but should be manually editable.
Isn't this what the "Apply on Edit Page as Well" should do, or just what is this checkbox used for?

C
comlan author 5/11/2009

Okay, so just what is the "Apply on Edit Page as Well" checkbox for?

J
Jane 5/11/2009

comlan,
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.