-
Create an appointment for next week
Hi All, I have a button in a Dashboard to create an appointment and popup the new record. The new Appointment record has the date field set for Today as the default. It works fine.…
- Answered
-
Sort json?
Hi everyone - I'm trying to create an HTML table but want to be able to sort it, probably by using a choice field that would modify the order. I can't just sort the select because one of the fields…
- Answered
-
Remove the repeated values from CutOff
Hi all again Starting from CutOff Date I need to remove the repeated values, In the picture the case, as CutOff Date 31/March/2023, eliminate the values of Real and Cumulative Cost down from…
- Answered
-
Start with date in a multi line test field
Good evening and greetings to all. I need that every time I enter a new text in a multi line text field, it automatically inserts the date before I start writing.…
- Answered
-
Show "1" instead UNDEFINED
Good morning everyone, I am writing because I need "Field1" to show the result "1" when the result of the formula is "undefined". Otherwise it must show the correct number, extracted by the formula.…
- Answered
-
Image size in fx field
IMAGES SIZE: I have a table, containing images, to be used as headers in other places of my database I have made the images to fit the size of the header space - a fx field : (select HEADERS).…
- Answered
-
Payment of several unpaid invoices
Hello everyone, I have something difficult (for me at least), but I'm not afraid of you, I trust you :-) I have built a database of my finances. All good so far,…
- Answered
-
Prohibit Deletion
I Heve a task that will prohibit deleting tables and records, APP mac. Found how to hide the delete icon in the bar html(" <style>" + if not HUD then ".i-setting-print{display:none;}" end + " .…
- Answered
-
Button to open a PAGE
Hello Ninox Brain Trust, Has anyone been able to open a PAGE with a button?
- Answered
-
Jump
There any way when I select Year 2024 Go to the first record of 2024 ? year is a Choice field.
- Answered
-
Create sequential row numbers in invoice print form
I've modified the Invoice Template to make invoices and "line sheets" for a jewelry company; see screen shots of Invoice tab and the printed form. However, the Record #'s are fixed,…
- Answered
-
Sum service amounts from three tables based on dates
Hello. I pay my employees weekly based on how much they bring in for services, products and off-site events (three separate tables) throughout the week. I am using a date field.…
- Answered
-
stop users changing view sort order!
How can I disable a "view' table that is on a form? I hve a view in place to show the cild table (subform) for line items of a quotes (parent table). This view is sorted into ID number (ascending)…
- Answered
-
Display a maximum number of data
Hi! I use a formula field to display text data which is itself from another formula field which contacts data. I would like to find a solution to display only the last 5 lines and not all of them as…
- Answered
-
Duration chart
Hi ! Is it possible to calculate a duration to display it on a graph? I would like to have a graph that displays the time worked each month. This calculation is based on the "Durée" field of the…
- Answered
-
Calc Dynamic problems
@Fred Hi Fred, 1- I have a problem in the Show_Week_Hours, the selection of Choice_Weeks is not ordered correctly. 2- Now is for one year there are possible a script for works on weeks for years.…
- Answered
-
Hide button if selection in Multiple Choice
I need to make the button "ESENZIONE BOLLA" appear only if the flag is active on DAF FF 058 PS 2600KG in the dynamic multiple choice field. Otherwise I need to hide it.…
- Answered
-
Check if 7 fields have been filled
Hi! In a table there are 7 fields to fill and 1 button. The button serves to create a record in a linked table, on this I have no problems. I would like the button script first to verify that all 7…
- Answered
-
Filter Choice (Dynamic)
@RoSoft_Steven @Fred Hi I have the table with 5 field Choice Dynamic each for one Level of the WBS. All 5 field are Choice Dynamic , each deliverable an Budget is associated with your Level I need…
- Answered
-
SUM COST By CUTOFF_DATE
@Fred Hi Fred I hope help with that. On the EVM Table I have the KPI' Activities Form in that form have the Field Actual_Cost here I charge the accumulated cost Week by Week in each activitie (need…
- Answered
-
Other formula problem
Hi again with another problem with formula. if Actividades.Disciplinas.Discilina = "Civil" then sum('Horas Ganadas Plan') = " Civil" end Don't give me anything
- Answered
-
Labels in different languages
Well there it is. I now have the need to present views and forms in two different languages to a customer. This is a go or no go thing for him. I cannot see any other solution than to have to…
- Answered
-
This code works erratically sometimes it works and other times it doesn't
This code works erratically sometimes it works and other times it doesn't. delete (select 'Evaluation table'); let myY := year('Evaluation Date'); let myYM := yearmonth('Evaluation Date');…
- Answered
Answer questions and share your knowledge