davitabile

Hi Peter,
maybe I have solved but don’t know whether this is the right solution. I have just duplicated the page in data project. Now I have two different department pages, one with administrator privilege where I can see everithing and one with contributor privilege where people with this profile can access only to their records. My question now is. Do I have to add the column dep_manager_user_ID in each table of the data project or there is an easier solution to limit the acces to the entire data app?

Thanks a lot for you support

Hi Peter,
1) I have this issue in the backend, I did not try in the front end

2) Well… let’s say I’m not so skilled, but I’ll try to find out. Actually I need to send a very simple and generic email like “Project ‘name of the project’ has been updated”
Can I use code manger to insert the JavaScript function?
Thanks

Hi Perter thanks a lot,
problem solved but I needed to switch to a different web host.
Thanks again
Daniele

Hi Peter thanks a lot for your kind reply

The form solution looks very interesting as well as other functions such as the possibility to export or copy data from tables. I’m close to convince my boss to get the premium version!
In the meanwhile I have found a solution that could work form me:
I inserted the topic # in the issue table using a lookup. Decision Table is a child table of “issues” one to many
To display data correctly I would need to create a View, however I really don’t understand why import function is not working to me
I have created an Sql query that works for sure since I have tested it with another system.
I have tryed also a very simple script with no success:

CREATE VIEW ‘Vrb_argomenti’ AS
SELECT
Vrb_Id AS Arg#
FROM
Vrb_2;

I always get the following

ERROR: Import sqltest.sql failed [check import file]

Could you help me to understand where am I wrong?

Thanks a lot in advance

Daniele

WoW! Just amazing!
this was excacty what I needed
thanks a lot!
Daniele

Hi Eli thanks a lot for your quick reply

this [sqlgetvar]sqlvartest[/sqlgetvar] effectively works!

Daniele

Hi Jack and Peter I have solved!
There were several error. Here is the correct statement

CREATE VIEW vrb_summary AS select vrb_new_verb.vrb_titolo AS TitoloVerbale,vrb_new_arg.arg_titolo AS TitoloArgomento from (vrb_new_verb left join vrb_new_arg on ((vrb_new_verb.vrb_ID = vrb_new_arg.vrb_ID)));

Thanks

Daniele

Hi Jack,
thanks for your suggetion.
I have fixed it, however it still does not work…
I’m working on it anyway
thanks again
Daniele