getUrl returns "internal exception"
I want to get a json list of items from a webservice: map Campaign.listSibCampaign() { mapheader = Map(); mapheader.put("api-key","Ab7XXXXXXXXXXXcaJ"); resp1 = getUrl("https://api.sendinblue.com/v2.0/list?page=1&page_limit=2", mapheader, false); return resp1; } This works fine with Postman I get this { "code": "success", "message": "Successfully retrieved list details", "data": { "lists": [ { "id": 689, "name":
Error message advanced email in Zoho Creator
I keep getting this error message. What I am doing wrong? Error at line number : 2 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression 1 sendmail 2 [ 3 from:zoho.adminuserid 4 to:Properties_20170822_200937[ID == input.Property Name].Email 5 subject:"Subject of the email" 8 message:"Your message" 9 content type:HTML ]
Validate multiple rows in subform
I currently have the following script in Form Actions > On Add > on validate: for each row in Order { inventoryamt = Promotional_Item_Input[ID = row.ItEm].Quantity_In_Stock; if(Order.Quantity > inventoryamt.toLong()) { rec = Promotional_Item_Input[ID = input.Order.ItEm]; alert "There are only " + inventoryamt + " left of " + rec.Item + ". Please adjust your order quantity."; cancel submit; } } It works to check the quantity of items ordered against quantity in stock for the first row in the subform,
Fetch criteria with "if" ?
Hi All, I have a function that gets two variables: Date (date) and SectionName (string), fetch entries from a form by criteria based on those variables, and than makes a change in the entries. The criteria always targets the "Date" field, and if "SectionName" var is not empty, it also targets "Section Name" field. Currently, I have the same syntax run twice - once if SectionName != "" (meaning it's not null, and than the function use it as a filter) and second time for SectionName = "" (meaning it's
Sharing permissions in lookup fields
Hi, I' trying to test sharing settings. I successfully managed to limit a user ability to see form A records not created by him. However, if in form B there is a lookup to form A he will see all records. Is this how it should work? How can I also limit the view permission in lookup fields? Thank you for your help. Bruno
Is anybody working in sand box environment
Hi Here is my story. I have to create assessment application with 43 forms. In first release, I've created 20 forms and moved to production environment. My client also started to working on it. I was supposed to create rest of the 23 forms on the same application and also need to test. When I approached zoho support, I was asked to use sandbox feature. But I could n't create sand box, as the application took too long time to create.Again support team helped to create sand box environment. I was
Images Broken on page?
hey all So I have a page that displays selected product information triggered via a custom function on a report. It shows the name of the product and price fine (also tried a bit of similar code for the image but just retruns a "True" string) Trying to get it to show the image that has been uploaded too, but keeps returning a broken image. here is the code im using at the moment: htmlpage ProductSample(empid) <%{%> <h2>Mood Board</h2><%prodLst = input.empid.toList(); for each prod in Add_Product
Disable row in subform
Why Can't I disable row in subform? Is there any way?
Combined Report - Setting report criteria with form fields
I have a Products Form (name, minimum stock) and Product Stock Form (product, current stock). I would like to display only the products with low stock. Like Product Stock Form->current stock < Products Form->minimum stock. It looks like the set criteria allows to enter values only. Is this possible?
Public sharing does NOT work anymore "Make public to all visitors over the web"
Dear Zoo Creator Support team, for our "werksviertel" Zoo Creator App we need public sharing of forms with the "Make public to all visitors over the web" feature. We use this feature already on several Zoo Creator applications and also within the "werksviertel" App, but this "Make public to all visitors over the web" feature is not available anymore. We use this public sharing option to request Zoo Creator data objects and image URL's via the JSON interface. I am an longtime Zoho Creator Enterprise
Uploading File via Restapi to Zoho Creator
Hi, I have developed an android application which sends image as a file to creator using the restapi put method. The request url is "https://creator.zoho.com/api/xml/fileupload/authtoken={authtoken}&scope=creatorapi&applinkname={applinkname}&formname={form_name}&fieldname={fieldname}&recordId={record_id}&filename=testingtestingtestingtestingtestingtestingtestingtestingtestingtestingtesting.jpg&sharedBy={adminname}" But it doesnt work if my file name is "testingtestingtestingtestingtestingtestingtestingtestingtestingtestingtesting".
How to show a lookup with dynamic filter
I have services form (Plumbing, Wiring etc). I have Resources form. Each resource will work for different services. The services are selected through Service Lookup with multi select field. booking2.png. I have a booking form where I need to select a service and assign the booking to a resource. I have resources look up. Now I need to show the look up based on the selected service. (booking.png).
Search button
Hi All, Is it possible to search every record on the main menu on zoho creator? Because now i have to go to the report first to search records and the search of the reports is not handy. Thanks
Events from another form in Record Summary.
I have two lists. The first one is a list of people with their basic information. The other list is a list of events, on which I classify certain events, tagging the people involved. What I need is that in the people report, each record summary shows, below the basic info, a report of the event on where each person was involved.
Managing master and reference data
Hi, Hope you are well. I have a number of apps on Creator and am finding that some of the forms that I am creating are quite similar across the apps. Up until recently, whenever this has been the case, I have just used a lookup to the form that already has the data that I need. I have been reflecting on this and thought that this is a messy way of doing things as the master data required in order to make the rest of my apps work is all over the place. FYI, the kinds of data that I am referring to
How to filter a report with a lookup field using URL parameter?
I have a booking report with bookings assigned to users. I would like to show bookings assigned to a user based on the url parameter. I open the url like this. https://creator.zoho.com/XXXXXXXX/booking/#View:Booking_Report?Assigned_To=3021232000000294010 But it shows all records. However url parameter seems to be working other field types. Any idea?
Help needed: HTML Creator
Hello, I am new in this forum and to Zoho Creator. I made my first steps with Creator and Deluge and everything is fine so far. But now I hit a wall: I like to make custom Dashboards / Pages apart form the standard Report ones. To do that I have to program in HTML, right? Could you recommend me programs in which I could build html pages via drag and drop in order to copy the html code and paste it into the Zoho Creator Workflow in order to build my custom Dashboards / Pages? Thank you :)
Formula
Hi guys, MY clients can pay in 2 terms when ordering something from me. I use formula to track how much they still have to pay me, but is missing the payment 2 What i need is: 17-8-17 Price = 10 Payment 1 = 5 Payment 2 = 0 Payment 2 day = Need to be paid = 5 (Formula) 20-8-17 Price = 10 Payment 1 = 5 Payment 2 = 5 Payment 2 day = 20-8-17 Need to be paid = 0 Can someone help me with this? because i already have price-payment1 and it works. but if i try to put payment 2.. it stops working.
Query String Parameters
I've looked up all the Forum posts on Query String Parameters and I can't seem to find a direct answer to this question (lots of work-arounds thought). In various web programming languages, there's a way to access incoming Query String Parameters. For example, in PHP, if someone follows a URL like this http://www.example.com/page?myVar=xyz You can reference $_REQUEST['myVar'] Is there a way to do this in Deluge? Currently, I'm using a work around, I'm passing in a value via Query String like this
[Question] Subform Total Calculation and Main form Total
Dear all, I was making an application for car repairs. I looked at the sample from Zoho about subform https://www.zoho.com/creator/newhelp/forms/creating-subforms.html and would like to do the same, which are: 1. The subform will have a total per subform line 2. There's a total in the main form to total all subform line Please help me how to do that in the formula field both in subform and main form. Thank you very much. Michael Dharmawan
Mismatch data type for function 'addAll' at argument index 1 expected data type LIST found data type STRING
Hi There, I am going mad trying the accomplish the following: I am trying to run an algorithm from a stateless Form. I have Two tables TABLE OFFICES ------- OfficeName (String) TABLE USERS --------- User (String) OfficeRights (This is a Multi-Entry Lookup that takes many "OfficeName" from Table OFFICES) email (Email) Im trying to obtain all "OfficeName" from each User in TABLE USERS and add them to a list called ListOfz ListOfz = List(); for each Usr in USERS { ListOfz.addAll(Usr.OfficeRights.OfficeName);
Data will not display on published Page
I am working on an app to allow users from a website to search for and display certificates that are created on the fly by entering a product number in a search page and then having all of those certificates display on the page. I have developed it and it works in my creator home but when I publish it its not finding any data to display. What am I missing here I am sure its a simple fix. I am new to Creator. Tom
Edit data on stateless connected forms
Hi, I have five forms connected using Stateless Master form. I am able to submit the data on all the forms and submit it. Now, how can i make the data submitted on Form 1 be editable if i navigate to Form 1 from Form 2 using the "Next" "Previous" functionality. Is there a way i can autopopulate the Form 1 using some ID? Also note that I have not yet completely submitted the entire application (from Form 5). Thank you.
Assign unique identifier from pool of identifiers across different forms
I'm setting up a title database for a publisher. It was originally set up in Filemaker. There's one form with information about each title (title, subtitle, series name, series number etc) and I need to assign multiple ISBNs (identification number) to each title depending on format (hardback, paperback, ebook, audio etc). I've got hundreds of ISBNs in a CSV to import, so I put these into one form. The title information is in another. I tried assigning them with a lookup, but have run into issues
App auto-refresh
i have created an App which i would like to share between 5 users. the thing is that i would like the dashboard to auto-refresh every 5 to 10 seconds to make sure that all users are synchronised with no delays. how can i do this ?
Share data on the web
Hi, I have a fairly simple database in Access that is for my family - total family members 200. It contains names, addresses, phone numbers, birthdates, divorced, etc.. I would like for family members to search the database - read only, but be able to edit their own record. Although there are 200 people I would doubt that more than 50 would ever use it to edit. I have also been learning Filemaker but I am not seeing how to do that without paying a lot of money. Is there a way to do this with with
Get Drop Down List From Zoho CRM with matching condition
Getting this option value based on matching condition from zoho crm account records Some thing like this <select> <option value="account_id1">account_name</option> <option value="account_id2">account_name</option> <option value="account_id3">account_name</option> </select> Here my code getSupplierRecords = zoho.crm.getRecords("Accounts"); for each getSupplierRecord in getSupplierRecords { if(getSupplierRecord.get("Tipo de Entidade") == "Fornecedor") { input.Select_Supplier:ui.add(getSupplierRecord.get("Account
if null use another field
Hello, I currently have a formula with the expression - ((Sale_Price - Estimated_UK_Price - Estimated_Cost_of_Work) / 1.2) What I would like to do is if 'Estimated_UK_Price' = NULL then use field 'UK_Landed_Cost' Is this possible? Thanks
add subtotal to currency
hey guys i have a form that i need a total box at thr bottom and need it to add each of the other currency boxes. what i have is all our denominations for instance $100 $50 $ 20 etc and when i type how much we need of each i want there to be a running total at the bottom how do i do this please
Unable to add fields in a form.
Hi. I evaluating Zoho Creator for our use and while trying to build a form I am unable to add more fields to the form. The editor stays stuck with just a message saying "Adding...". I doubled check my internet connection and everything on my end looks fine. I've attached the screenshot with this message here. it'd be really useful if someone can point me in the right direction. Thanks...
Multipage forms
Hi Guys, I'm try to make some multipage forms, but could really use an example. There is a sample app at: https://creator.zoho.com/sampleapps/next-previous/#View:All_Data Could you please share this app so that I can import it into my account and look at the backend scripting? Thank you so much!
How to create scheduled push notification?
Hi everyone, I want to get the number of new records every hour in the phone notification bar. But I can't find a way to do it. Can someone tell me how doing it? Thanks.
Please Help with add new formВ from lookup field in formA
I have bideraction lookup with FormA and FormB. And want to add new FormB from lookup field in formA. After saving (or when i creating it), i want to fill some field. I use script (in formB) on Add --> on Success: "docs = FormA [ FormB == input.ID ]; for each rec in docs { insert into addSprava [ promizhnuyRezult = rec.sender_field ] }" But it doesn't work. Please help me with this issue.
Temperature Probe Integration into Zoho Creator
As anyone used zoho creator to integrate temperature readings from a wireless temperature probe into a zoho creator application. I have developed a Food Safety reporting system and I am looking to use a wireless probe to check temperatures and display in the application
Graphs Based on zoho.loginuser
Hello all, Is zoho.loginuser available anywhere for graph reports. I know that it is possible to add a criteria for a regular report (list), but I don't see it anywhere for graphs. Again, I want all users to see graphs, but only for records assigned to them. Lastly, they are NOT record creators, but only record owners. Any help would be appreciated. Thank you. Cheers, David Bergaz
How to setup a document workflow that requires more than one validation?
Hello, I´m building an invoice validation app and i would like to to know what is the best practice to setup the system, that needs to support, for example, two users to validate the same invoice/record, because only when the two validate, the invoice status changes to payment ready. Any help? Thank you.
newbie help - Solved
Hi This is my first day trying to learn Zoho, I've got a good database going for our volunteer group for Search and Rescue but I'm beating my head against a wall with the Workflow Scripts. I can get Zoho to send a message on "update" with a single message such as "Test" but I want it to show the updated records in the email. I did the tutorial and I though i was suppose to use the 'info" expression but it always tells me I'm missing a ; or the expression is incomplete. Can anyone just give a pointer
Add a button in CRM/Case to create a new Work Order(my app in creator)
Maybe I am doing this wrong as I am new to doing this but this is what I am trying to accomplish. I want to create a Work Order (I have created it it Creator. Should I add it as a module in CRM?) We are a field service company and want need to have a customer Work Order. I want create the work order from a case. When it is created I would like the case number, account, contact and other fields that I may need. I would love to know how to do this and the best way to do so. Thank you so much in advance!!!!!
Adding multiple records - Zoho Creator
Hi, I want to give option to my user to add multiple records and the same to be printed which I am trying to achieve using Record Summary. I tried to add Sub-form and give option for user to add multiple records. When I tried to print it using record summary, it is merging the fields into one sub-form and print it than showing one block after another. Attached the sample fyr. Kindly let me know how to address this. Regards Janaki
How to create a consolidated stock report?
I have Product form with Product Name, SKU and Unit. I have Stock form with Product, Warehouse, Stock.The stock form will have stock for each warehouse like this. Product Warehouse Stock A W1 10 A W2 20 B W1 1 B W2 10 I need to generate a consolidated stock report showing the sum of all stocks for each product. Product Name Sku Stock Unit A AX1
Next Page