Order List by more than 1 field in HTML Page
Hello, I have a HTML Page that I am using to generate a report FOR EACH record in my database that match the specified. Everything works fine however I am trying to order the list in by "input.Department " AND "input.Last_Name" Please see below Thank you PaymentList = PaymentDetails[(((Payroll_Period = input.PeriodID.toLong() && Employee.Type = input.Type) && Employee.Work_Location = input.Location) && Employee.Department = input.Department)].distinct(Employee); <-------- this is what I need to
Hide field No working :(
Hi :) I want to hide field when lookup equal specific option. in my case when Account lookup = "Assets" hide "Amount Code in "Account" on user input : if ((input.Account).toString() == "Assets") { hide Amount; } The surprise is No Working
Summary View layout helps resources
Hi Im trying to create an invoice using a summary template. The user help shows a very nicely laid out invoice template but not matter how much i try I am struggling to get things to lay out correctly. Are there alternative sources of help/support that might delve into the layout methods in a bit more detail? Also trying to work out how to create a calculated field so that I can show a invoice total, VAT etc. Thanks
Sub Form Insert code
Hi, I need some support adding subform records through script. would this be the way? motherform_record = motherform [ID=<record_ID to add subform row to>]; insert into moderform_record.subform_name [ Added_User = zoho.loginuser field_1=<field_1> field_2=<field_2> ]
Sub-grouping?
Hello, I would like to make a two level hierarchy with grouping, involving two different fields (one contained in another). Like this: - Project ABC - Clients (reports) - Employers (reports) - ... - Project XYZ - ... - ... Is there any way this is doable? Thanks in advance, António Caetano
Display Today's date in record summary?
Hi, Is it possible to get Today's date in a record summary? Using ${zoho.currentdate} to achieve this would be awesome. ** Workaround would be to have a hidden field and update it using the scheduler. Damien Cregan Hire an Expert
Fetch record and update same record without creating duplicate record.
Hi zoho users and employees, Ive created a timekeeping app for employees (users) to log hours during a specified pay period. In this application, I am working towards creating a dropdown that would act as lookup to the same forms records. Once the pay period is selected, a fetch command would be used to autofill the subform "Tasks and Hours" based on the criteria that zoho.currentuser = input.Name and payperiod = input.pay period ie.(fetchx = Timesheet [(Name == input.Name && Pay_Period == input.Pay_Period)];)
print/view the form (view) - structure view of report entry
Hi, I'm really new using zoho and don't have much time to study the programming of zoho. Therefore I have a simple question. Is it possible to have the same print layout for a particular report entry as the layout of some form you add the data to? I know that it is possible to print an entry using the "normal view" via the print option in a report but in my case the given layout is really unstructured compared to the form layout, where you can at least add fields like "add notes" to structure the
How to pass referer in heading from HTTPS?
I set up some bucket policy in Amazon S3 to restrict access from specific website, in my case from my application in Zoho Creator. I understood that the policy can work properly only from HTTP sites, since the referee cannot be sent from HTTPS as normal behaviour of the browsers. However I'd like to force to open those files at S3 from my links in my App in Creator. Can I pass these info somehow? The below scripts is working if I use my terminal window, so I can say the only thing which is missing
Printed form
I need to create a form to print with fields positioned in specific order. Basically I need to create a purchase order based on a table (or form in ZOHO) so I can print it or email it. I haven't found a way to do this. All reports I see are list or grids that show the information in a report style form. Thanks
zoho creator - can not export to a PDF
I am able to export any of my tabs (form views) to PDF except for one...instead of linknig to an open PDF option, it links to a blank html page....am i only allowed to export only so many pages to pdfs?? (i honestly doubt that is the case)..what am i doing wrong? or is there some kind of error on your end in which it should not be doing that?? i have tried everything: logging out and back in, restarting my computer, save as.., etc... please help ASAP? adam
Cannot add field to form
Hello, I have tried two days ago to contact support with the request marked as URGENT and no response. When I am in my form and drag SINGLE LINE as example across it will not create a new field just stuck on the default adding item message. Can anybody help? YES I have tried multiple browsers YES I have cleared cach/cookies history on mutliple browsers and tried YES I have tried another form and able to do so there but just not on this one.
how to take first N characters in each line of MultiLine?
hi there is MultiLine in form for automatic correction of manual input need to check entries how to take from each line first 8 characters? in characters will be text, numbers and " ". these 8 characters will be using in list manipulations - search for duplicates, to correct input data
Mobile Creator
I've been using mobile creator since Pleasanton Zoholics and have a lot of feedback to offer. Where would be best to share with you all my findings?
view filtered by a URL passed paramter
Hi, Is it possible to filter a view with a url paramter for a speciffic field without that field actually being displayerd? for instance, think of a view containing Employee group, Name and Last Name. Say I want to display all the names belonging to certain employee group selected by the user. It is easy to create a URL with the parameter of employee group desired and this way only those names in the desired employee group will show up. The issue is that the employee group has to be displayed for
Change name of choices in a multi-select field without losing data
Hi, I have a multi-select field that I want to change the name of the list of choices, but without losing all of the data associated with the current name. It should just be a "rename" process rather than a "delete and add new" process. Previously, when I changed the names of the choices, any boxes that were checked immediately lost their value. To give you an example, say I have three choices: low, med, high I want to change the names of these choices to: 1, 2, 3 (respectively) But I want all
Problem with subform and ui:add values
Dear All, Let me describe my problem which I have with my subform. As you can see from the image below I have two fields. The first is a lookup field (Excursion_Name) and the second is a dropdown (Optional_Rates1). In the on user input of the lookup field I wrote the following: if (row.Excursion_Name == "Included Excursion Land & People") { row.Optional_Rates1:ui.add("Bus Transfer"); row.Optional_Rates1:ui.add("Guide"); } With that it fills the Optional Rates field with two values. Lets
how to detect duplicates in text lines?
hi need make script which can find duplicates in text lines see example of text in attach there are numbers with dots "344.213.34" and without dots "34421324" at same time and there is about maximum 50 lines in text field using which function can we detect duplicates on validate?
Subform
If customer creates 5 lines in subform (1,2,3,4,5) and then delete line in the middle (#3) In this case new numbering would be 1,2,4,5 have to update numbers for all rows before submit to arrange 1,2,3,4
User permissions customer portal
Hello, I'm using the customer portal and created a new profile. This user should be able to use a form, but for one field he should not have the permission. How can I make sure the user with the profile I created isn't able to input that certain field? for example: When a public user is using the application I can user the following if rule: if (zoho.loginuser == "Public") How can I script this for a certain profile I created? Greatings, Erwin
How to pouplate sub-form records from another sub-form
Hi, I am facing a following problem, please help. I want to populate the data in a sub-form from a data in another sub-form based on a condition in the main form. There is only one main form record and several sub-form records. If anyone has a source code or script to do that, please share it with me. I tried out several alternatives but it only loads the first record and beyond that it does not work. I am facing a challenge to get the IDs of sub-form records as I get the main ID but not the sub-form.
Include subform info in an email?
In the on Validate section I want to send an email that includes information from a subform. It shows the field as a collection but will not save the email script. Herb Wexler
Backup Bug (In Progress Already)
I use the backup feature in Zoho Creator on a regular basic. They have made some changes recently and it looks much better but there is a bug in it. Once you have a full page of the backup logs (8 entries) then when I try to backup an application it states that there is already one in progress. When all have been completed. Please advise. P.S. Zoho should add more frequencies options. Currently only "Right Away!" No others.
Using get from CRM fuction in a subform
Hi I am struggling to get code to work in a subform. I want to use grab data from our CRM system to populale a Subform. I have built a form populated it with this code crmresp = zoho.crm.getRecordById("Invoices", input.Invoice_ID); input.Total = (crmresp.get("Grand Total")).toDecimal(); When I test it in the main form it works but when I use it in a subform it does nothing. Is this a error/limitation in the system? Cheers Dan
Where do I see the audit log? I don't have data management under setup
I need to see all audit activity on my tables (forms), but I don't know where to access that. Thanks!
what happen? i Can't edit my app suddenly
is this a error? i cant edit it and some links disappear
App Account Problem
I have a problem with my account, when I execute the Edit On Success for the following form https://creator.zoho.com/appbuilder/czambrano1/compraseinventario/form/Shipping/Auto_Id/workflow/edit#OnUserInput Appears the following advice without executing the code, I try log-off and login again but the problem continue. If you need support access is allowed
On Input - Avoiding Infinite Loop
I have a nice routine to validate a UK phone number, but I want to update the field with the reformatted number (spaces removed) as part of the routine, which just sends me in an 'on input' infinite loop ? Any suggestions ? Thanks Neil // Set RegEx Variable Match Strings UK_Phone_RX = ("^(((\+44\s?\d{4}|\(?0\d{4}\)?)\s?\d{3}\s?\d{3})|((\+44\s?\d{3}|\(?0\d{3}\)?)\s?\d{3}\s?\d{4})|((\+44\s?\d{2}|\(?0\d{2}\)?)\s?\d{4}\s?\d{4}))(\s?\#(\d{4}|\d{3}))?$"); UK_Mobile_RX = ("^(\+44\s?7\d{3}|\(?07\d{3}\)?)\s?\d{3}\s?\d{3}$");
quickbooks & zoho
my goal is to have a form / database for sales reps to submit sales orders directly to me - once submitted i would love to import them into my quickbooks db is this something that is doable without extensive development and programming knowledge
Blank Dashboard / Can't access creator
I was using my Creator trial, did something (granted access to someone or something like that) and now my dashboard is blank and I can't do anything. How can I reset everything to zero? I had nothing of importance there but I can't use it anymore.
How to avoid an endless loop between two fields where their On User Input affects the other?
Is there a way to avoid an endless loop in this situation? Fields Transaction_Date is standard date field Transaction_QTR is dropdown with choices such as "2015-Q1", "2015-Q2", etc. If user supplies the Date: we supply the proper QTR. I have a nice OnUserInput that calculates and supplies the proper Transaction_QTR choice. This works nicely by itself. If user supplies the QTR: we supply the approximate Date. Unfortunately, with this in place, the result in an endless loop between the two (sorry!).
Calling a function - can someone please tell me where I'm going wrong?
Hi I currently have a problem calling a function from another application and getting it to set a variable value in a second application. Any guidance would be much appreciated. Here's the scenario... 'dbs' is my lookup application. I have created a function in the 'dbs' application, called 'ClientID', to fetch the 'Client_Name' field from the 'clients' form - used the following code: string ClientID(string ClientName) { rec = clients [ID != 0]; return rec.Client_Name; } 'submissions'
Page can't be edited. Please help
would you please tell me why this page can't be edited? https://creator.zoho.com/appbuilder/yaxche/catalogo/page/Productos_Pagina/edit I was working on it, everything fine. Pusblished it, used the URL for my webpage system. Came back and tried to make an adjustment and the page code simply can't be seen. I don't want to lose the code I made.... Could it be related to the fact that I published the page? please help... Thanks Luis
Function Generating HTML Problem
Good day, Im trying to edit a function that create a HTML page, but when I change something I need and I try to save, it shows me the following Error, Error at line number : 28 'Proyecto' is a lookup field and child fields cannot be accessed The issue is that I am editing other line, and the function is working already with that existing code. If I open the function and click save script with any modification always error appears. Support is available in the application and the function name is
Calculate due date
Hello, I have a date field which is the invoice date. Now I a user must have selected the amount of days before payment. I would like the due date to be based on: input.Due_date = input.Invoice_date + days; This doesn't work. Does anyone has a solution?
Zoho CRM create Task
Hi, I am trying to add a new record in Contact Module of Zoho CRM on Success action of a form but I am getting an error on submit action of form crmMrk = Market[ID == input.Add_Market].Market_Name.toString(); crmBr = Broadcast_Management [ID == input.Add_BM1].BM.toString(); myFieldMap = map(); myFieldMap = map(); myFieldMap.put("Company", Add_TVStation_Name); myFieldMap.put("Last Name", "Contact"); myFieldMap.put("First Name", "Creator"); myFieldMap.put("Email", "noemail@noemail.com"); myFieldMap.put("Market"
Disable Field not working from a Report
I am trying to disable certain fields from being edited, but when I access the record via the Edit button on a List Report, the disable function is not applied ? Any thoughts for each REC in Access [User_ID == zoho.loginuser] { alert("Level : " + REC.Access_Level); if (REC.Access_Level.toLong() < 5) { disable Site_Name; disable Seaware_Code; disable Seaware_Detail; disable Floor; disable Location; } }
Who can I call to get information?
I'm looking to develop a platform to manage a cloud based electronic medical records, for doctors, we want to include services such as mail, calendar, directory, etc.. But I'm finding hard to understand the license, pricing and would like to get in touch with some one on the sales department that can help me> Thanks....
mCreator and geolocation (geofence) feature
Hello, I am wondering what the geofence restriction feature in mCreator uses to capture a potential submitter's location when determining if they are within a geofence or outside of the geofence. I would like to use a query to the mobile device's GPS software stack instead of using the IP address of the submitter when determining what their location is. This is a feature found in a few other mobile form building software platforms that I find lacking in ZoHo Creator. Having this feature would allow
How to separate output data
Hi, I need help to provide me simple script to get the input data from a source "single line" data and output separate into two different "single line" Example : input data = '"2015-04-29 18:00:00" Target A = "2015-04-29" Target B = "18:00" Please refer to the photo attached.
Next Page