How to enable Javascript

Latest Posts

Re: Prevent old record editing for users with limited access rights @Paul Chappell I could not make use of that field in formula. It does not work. Will better post a new question about that, for easier access for others.
- Agassi
- Agassi
- 2 mths ago
- Get help
- Reported - view
Re: Prevent old record editing for users with limited access rights @Paul Chappell Paul, can it be accessed in formulas or "Writable if" field?
- Agassi
- Agassi
- 2 mths ago
- Get help
- Reported - view
Re: Prevent old record editing for users with limited access rights @John Halls Thank you very much! I will try it and report back!
- Agassi
- Agassi
- 2 mths ago
- Get help
- Reported - view
Prevent old record editing for users with limited access rights
Hello! I have 2 access rights levels in my db - admin and manager, where manager has less rights. How can i prevent a manager to change anything in an old record,…
- Agassi
- Agassi
- 2 mths ago
- 7replies
- 60
- 1
- Get help
List filter does not work without updating the webpage
Hello! In my appointments list i have a formula column with this formula: date(start('date')) = today(), which i filter by Yes value to see only today's appointments.…
- Agassi
- Agassi
- 7 mths ago
- 71
- Get help
Re: How to use text from textfield in a formula Alain, thank you very much! It works perfect! So both solutions are good for differrent situations! Thank you Fred and Alain!!
- Agassi
- Agassi
- 11 mths ago
- Get help
- Reported - view
Re: How to use text from textfield in a formula Hello again! Im still thinking if its possible to do calculation of any math string? I mean - if I put a string 100+40/3 in a formula field, that would be calculated.…
- Agassi
- Agassi
- 11 mths ago
- Get help
- Reported - view
Re: How to use text from textfield in a formula Hello, Fred! Thanks a lot for such a helpful and quick reply!!! It works perfectly. I used a line break instead of a comma. Its so much easier now with your solution. Thanjs again!!!
- Agassi
- Agassi
- 11 mths ago
- Get help
- Reported - view
How to use text from textfield in a formula
Hello! I need to calculate a sum of various numbers (ex. sum of electricity bills of a trimester). It would be convenient to have a field where i just put the amount of every bill in a string like…
- Agassi
- Agassi
- 11 mths ago
- 5replies
- 266
- Get help
Re: Icon and Colour field types @Mr. K. The link does not show icons ((
- Agassi
- Agassi
- 11 mths ago
- Get help
- Reported - view
Re: Help with SELECT query needed! Hello Alain! I did not think that "Update multiple records…" will work that way - very useful to know!!! Your db is very helpful, and the tabular view is cool - we can see in a glance what treatments…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! Alain, hello! Sorry for late reply, i was seek several days. Many thanks for your last solution, it works very well!!! And again, special thanks for such an explanation!!…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: How to limit user to fill the fields in the form, but not see the list of records in that table More details and thoughts: All records created on the tablet are created by Client user. So if i put 'Created by' = user() in Readable if field, all recoreds created on the tab will be shown.…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
How to limit user to fill the fields in the form, but not see the list of records in that table
Hello! I searched for the solution, but cant find it. I have a tablet that i give to a client so he can fill the form in the table Clients. But i dont want him to be able to see other records in that…
- Agassi
- Agassi
- 1 yr ago
- 1reply
- 345
- Get help
Re: Help with SELECT query needed! @Alain I used the Choice, not multi choice. But the reference field suits me well, its ok! Using the query already for a little while, i wonder can it be improved a little more?…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! Alain, thanks for the explanation!!!! I played with both versions - with "contains" and with "cnt". First works perfectly - the view is filled with correct records.…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! Alain, this is incrediblee! Not only that you're solving my problem, but the way you explain things - thank you very much! The only thing i still dont get is comparing the handle with the Id...…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! John, thank you!!! i'll do!
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! Alain, Thank you so much for your help!! I modified the query to my field names, but to be sure i used correct fields, i'll ask: 1) in the first line the word Treatment is a field or i should put a…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! Steven, Mel - you are right - this forum is amasing! The will to help, the curiosity, the interest in the matter is impressive!!! Thanks to all of you!!!
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! John, now i understand that i should tell that i have a table Treatmentlist in the beginning ...That table is 1:N with Treatments table. When i create a Visit for a patient,…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! Wow, John!It seems so complicated for me, that i easily imagine that this script can do THE treatments by itself, leaving me without job )). Im going to try this now...…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! Fred, good idea! May be it will even help me in creating some kind of alert system, that will notify me about due treatments. But in this case I'm not sure it will work.…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! John, thank you for suggesting another approach! You mean another relational table, or how? Could you please tell a little more?
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view
Re: Help with SELECT query needed! Alaine, Fred - thank you for your answers! I tried not to write a lot in my question to not bore the reader, but now I see I missed important part of my task.…
- Agassi
- Agassi
- 1 yr ago
- Get help
- Reported - view

1 2 3 4 Next

Agassi

Agassi

87
1
0

Joined: 01 Oct 2019

Follow