Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
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
6 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
6 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
6 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
6 mths ago
7
replies
63
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
11 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
1 yr 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
1 yr 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
1 yr 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
1 yr ago
5
replies
306
Get help
Re: Icon and Colour field types
@Mr. K. The link does not show icons ((
Agassi
Agassi
1 yr 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
1
reply
347
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
Home
Learn & Share
Get help
Webinars
View all topics
Tags