Add a related record using deluge?
Hi, I would like to add records using deluge so they appear in a subform. For example, if I have a company form with a subform relating to a contacts form, I would like to programmatically create contact records so they show up in the correct parent record's subform. I can create records with deluge OK, but can't work out how to create the relationship. I saw a similar post to this from 2013, but nothing since. Thanks, Andrew
Select a random record
I'm trying to set up a web page (view) where I can select a random record from a report and display that record only. I want the record selected to change randomly each time the page is loaded. Can anyone think of a way to accomplish this?
Creating a SMS Sender ID for zoho messaging.
We are looking at using sms to notifiy external users on the progress of their on-line application forms. I have created a test function which can send an sms to a designated phone. In real live I will take the phone number off a form and pass that to the SMS send function. However we would like a sender ID to appear instead of the default sender phone number with the sms message so the recipient knows it's from our company. Is this possible with the ZOHO Creator default sms facility? if so where
Pick List
I have created a form with City as a field. I have it as a dropdown with imported cities. If a city is not in the list, how can I add it without editing the app list? Can I script it such as the "+" plus sign?
Fetch Records from a form using a multiselect
Hi, Looking to see if anyone can help. I have Form1 that has a multiselect on it I have some records in Form 1 that have options added to the multiselect (say a mix of option1, option2, option3, option4 etc) I have Form2 that has a dropdown populated with option1, option2, option3, option4 etc When I select an option from the dropdown I would like to get into a collection the records that contain that dropdown selection. Currently I was trying to work with: <variable> = <form> [ <field> <opr> <expression>
Auto Populate a lookup field based on a User input
HI I have a form "Despatch" with fields 1. Despatch_ID 2. A lookup field named WH_ID (Linked with a form named Warehouse) 3. A lookup field named Material_ID (Linked with a form named Material) and some other fields I have another form for taking arrivals of material in Warehouse. The form named "Arrival" with the fields 1. A lookup field named Despatch_ID 2. A lookup field named Warehouse 3. A lookup field named Material_ID and some other fields. When i enter Despatch_ID in the "Arrival" form, I
How to consume api data in zoho creator work flow
I have an rest API with user name and password I want to consume that data in zoho creator but i am not able to do so. any video would be preparable? please help me out.
dropdown selection for zoho page (simple html code write selection to zoho variable.)
Since scripting is not working properly in zoho pages We need simple code simple dropdown selection writes selection in a zoho variable. Zoho_Variable = "null" //Here dropdown lis code will come Select a value dowpdownselection1 dowpdownselection2 dowpdownselection3 Selection_var = "One of user selection" //if user select 1 and Zoho_Variable =Selection_var; I try to describe very basic way hope you will get what I mean. can you give us a proper working coding of this small
How can I remove unused custom Functions I've declared?
Hi all, I declare all my business logic in custom Functions, then I have 1 point to change if the logic needs to change. Anyway, I've built up a lot of these functions, and some I no longer need and they are cluttering up my lists... This being said, how the heck do you delete custom Functions you no longer need? Thanks kinly Check out my Android apps, they're free - http://goo.gl/ludism
How to Efficiently Enforce Unique Values but With a Filtered Context? Good Ex: Parent 1: AB, Parent 2: AC, Disallowed Ex: Parent 1: AA, Parent 2: CC
I'm looking for the most efficient route to script in a validation which requires all tag numbers for a Parent record to be unique, however, the tag numbers can be reused among different Parent records. Example of good logic: Parent 1: Tag #1 Tag #2 Tag #3 Parent 2: Tag #1 Tag #5 Tag #7 Example of disallowed logic: Parent 1: Tag #1 Tag #1 - Must be unique per Parent Tag #3 Parent 2: Tag #1 Tag #5 - Must be unique per Parent Tag #5 Now I am quite advanced with Deluge and I could simply grab all
Issue on select a picklist in a subform
Hello, I have a form with a subform. In both of them y have a dropdown. I need to select an option by code. For example: In form I have the Dropdown whith values a,b,c. on add, on load I use the code Dropdown.select("a"); to select the value "a" . It works. In subform I have the Dropdown whith values d,e,f. On subform, on Add Row the code row.Dropdown.select("d"); to select to select the value "d". Id does not work. Zoho creator say: Error at line number : 1 'Dropdown' does not exist in this form
Variable Defination in page URL
Hello There I have a page created and I wanted to define a variable value in URL here my example report url in zoho creator https://app.zohocreator.com/saldo/appname/#Page:Report_Page_Q1?Date_Selected = Year_Q1; but his does not work since I have to declare Date_Selected in the page some how Like this Date_Selected =""; so this decleration re-write my URL parameter so paramater would eliminate. so I decided not to declate variable in coding but in that case I can not use the URL variable Any
Relations in API calls
Hi, How can you fill in values for relation fills when manipulating records from the API? The GET value you get from the API is the display value of the form, not an ID or anything. So, what to fill in there from the API? Will it just work if I put the related element ID? I'm using the XML-RPC API. marc
Find records with matching time/date and other criteria
I have a travel booking application. I wish to check all future bookings to see whether any journeys on the same day also are either starting or ending in the same place. I can use the post code field to establish where journeys are starting from and ending - UK post codes are split into two parts and I wish to use the first part only which specifies the general area. I want to identify all bookings where the journey times are within an hour of each other and where either the origin or the destination
Page Link URL paramater
Hello There in zoho createor we have created a page. Page uses different variables in it but we need to change one of variable value as url parameter. for example there is a user_var variable contains all data realted to this user. and all page values connected to this variable. We dont want to create different pages for eac user but different url address for each of them. for example if the original page adress is https://app.zohocreator.com/salesdoc/aplicationname#Zom_Page we need to create
maximum function in page
Email_List = max(1,2); /returns 2 Email_List = max(1,2,3); /returns and error message Error at line number : 1010 Number of arguments mismatches how can we find the max of more than 2 numbers? in zoho creator page creation
Getting URL of a current HTML page or Form through deluge?
Is it possible to get the URL of a current HTML page or Form through deluge? Sriram_sierez
Can't duplicate main application
Hello- I cannot seem to duplicate my application titled "Operations". Support editing privs are enabled for you.
Fractions vs decimals
I need to program a form where if a user enters a decimal number a fraction is displayed, and vice versa. How can this be programmed? There does not seem to be generic support for fractions. Thanks!
Zoho Cretor Getting error {"message":"Invalid Ticket Id","code":"4834"} when trying to insert records in Zoho CRM
Hi Gurus, I created a sample application to integrate Zoho Creator and Zoho CRM. I followed the instructions here: https://www.zoho.com/creator/help/script/creating-a-record-in-zoho-crm.html. Didn't work. I'm getting {"message":"Invalid Ticket Id","code":"4834"} when I submit the record and click "View Log Details" afterwards. Which Ticket? what is that and how to I fix this? thank you very much.
Upload file on Custom Action
Hi all, I am working on a report for which I created a custom action button to change a status of a record and send an email notification. Ideally I'd need one more step - a prompt to a user to upload a file. Is there any way to accomplish this via custom action? Thank you in advance!
Parent-child (foreign key) relationship between forms - just can't figure it out in Creator
Hello Zoho support - would someone be able to look at my application to tell me what I'm doing wrong? I am modifying the Order Management app in Creator. I have a subform in Product called Add/Edit Items.. this is where I scan in individual serial numbers of the products. There is a lookup field in the subform, but for some reason it is just pulling all of the IDs of all the Products, not just the one in the parent form. I'd like to use this relationship and show the parent Product's part # in the
How to Add to Fetched Records?
I have a function that checks to see if an issue is overdue. If it finds any, it sends an email to a fetched set of people who indicated they want such emails. I would like to add the person to whom the issue was assigned to this list, even if s/he did not so designate. I tried fetchedUsers:ui.add(Users[Name == violation.Assigned_To]); but I get an error saying I can only try this in [ON-LOAD].
Access zoho people data!?!?
Is there any way for creator to access zoho people information??? It's a very common use case in any business to access the organization data, user's manager information, etc. Why is this not a thing yet? Very disappointed!!!
Iterating lookup values
I have the following code which iterates the results of a search. I then want to display the results. The field Species is a multi value lookup field... <%{ SpeciesCV = Studies [ID != 0];%> Species<%for each RowV in Studies [ID != 0] {%> <table > <tbody> <tr> <td><%=RowV.Title%></td> <td><%=Species[ID = RowV.Species].Species%></td> </tr> </tbody> </table> <%} }%> The problem is RowV.Species only returns the list of IDs. I found a suggestion to use <%=Species[ID = RowV.Species].Species%>
Fractions vs decimals
I need to have a user enter a fraction and display a decimal, and vice versa. How can this be programmed? Thanks!
Fetching records via Lookup field query - "In Criteria left expression is of type BIGINT and right expression is of type STRING" Deluge error
Hello, I've been having some difficulty working with fetching records from a form based on a lookup field value in that form. This is for a simple inventory system app for tracking sticks of RAM in our inventory by the RAM Model and Quantity. Types of RAM models are stored in their own "RAM_Models" form. The "RAM_Inventory" form has a RAM Model lookup field which allows you to select any model from the RAM_Models form and also a Quantity field for tracking total quantity. (There are other fields,
Redirect after paypal payment not working
I created a form for donations and after the payment goes through I want PayPal to redirect back to our website. I'm not sure what's going wrong, but after the PayPal payment is made it gets hung up on the redirection back and just sits on that screen. I've thought I had it set up correctly, but perhaps not. I also have an email that is automatically sent on success and that works fine.
Update Inventory of different Warehouses and different product
I have two forms Form "Warehouse" having fields WH_Code WH_Description Form "Products" having fields Product_ID Product_Description Now I have made a form "Stock_Status" having fields: Lookup field WH_Code Lookup field Product_ID Stock_In_Hand I have two more forms named "Arrival" and "Despatch" which contains information of Material arrived and despatched. I understand that I have to create a function to update Stock_In_Hand field in "Stock_Status" form "on success" of form "Arrival" and "Despatch"
Can I pass parameters to Reports before viewing
Hi, I want to create a stateless form for passing desired filter parameters to a Report. The user can decide the values and pass these as per their requirement. I also want that the applied filters are visible on the top of the report so that person viewing the report knows the filters applied. Please help. Thanks, Milind
Validate multiple fields On Add
I have a form with 3 fields. I want to validate the when submittng the form, that the record does not contain either field. For example: if (count(team_member[name == input.name]) > 0) { alert "Name already exists"; cancel submit; } will only check if the if name is used. I want to check both name and another field. Tried this but no luck. if (count(team_member[firstname == input.firstname]) > 0) && (count(team_member[lastname == input.lastname]) > 0) { alert "We found a potentially duplicate record";
How can I reorder a Report's Custom Actions / Functions for a more user-friendly iOS app display order?
Quick question. Is anyone aware of a way to change the order of custom actions for a report? It appears that the order in which they're displayed on the Zoho Creator iOS app is the same order in which they're added as custom actions in Report Settings>>Custom Actions. Every new custom action is added at the bottom of the list and I don't see a way to reorder these custom actions, for the purpose of a more user-friendly display order on the Creator iOS app. Any ideas? Thanks so much.
Zoho Page Drop Down Filter (or simple month filter)
Hello There I have created a zoho page in zoho creator fetching some recors from a basic zoho form. I am showing this values in a simple zoho page (in html table) I want to add a simple drop down month filter to this page view. (or add a month paramater to that report) how can I add specific month paramater to my html page (By this way I will have kind of dynamic report page ( users can be able change month and see previous months in same page)
FedEx web services SOAP integration - how to display XML with markup / tags?
Hi all - having issues with this integration. I'm in contact with FedEx tech support and they need the XML generated by my script, however whenever I email or print xmlString all of the xml markup is removed and only the data contained within the tags is shown. Anyone know how I can do this? I'll be happy to share what I'm doing wrong with FedEx SOAP integration when I figure it out with them. xmlString = ""; xmlString = xmlString + "<soapenv:Envelope "; xmlString = xmlString + "xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\"
Problem in attachment in Mail API
Using Mail API I can send a mail but, when I upload a file attachment, it doesn't work. This is the format that I tried, { "fromAddress": "josephabdulla@gmail.com", "toAddress": "skyclub12@zoho.com", "subject": "Email - Always and Forever", "content": "QWERTYUIO", "attachments":[{ "storeName": "646740840", "attachmentName": "Rating of Udhaya kumar.png", "attachmentPath": "/Mail/6467408401512740745391000_642421486-Rating of Udhaya kumar.png" }] } Please,
Zoho creator reports view
I have created a form for example class form and added a subform(eg. subjects) inside the form now when i click on class reports i can see my subjects field with name of the subject and on clicking that name it gives me the full information about that subject i.e fetches the row, is there any button/action so that i can get all the records of subform that are related to my form in a single view. Thanks
Zapier with shared apps
Hi! I'm trying to figure out if Zoho Creator can help me create my app. It is an app for lead management, with a three level user tier. - I am the app owner. - I share the app with my client. - He will use it for followup with his client. - He will need to set up Zapier to transfer the leads into the app he is using. - He can not have access through Zapier to the other apps I have. The question is, is that possible at all? I tried to do it, but it gave some error, specified ownername is not valid,
Subform´s Multi Line fields display issue
Hi, I´ll try my best to explain the problem I need to solve, I have a Form with a Subform as a field, this subform has a Multi Line field inside. when Adding everything works fine, but when I´m in the On Edit view, if that Multi Line field already has 2 or more lines of text, it will display only the 1st line and provide a little icon to drag and expand the field, This little icon is the problem, Its "collision box" or "clickable area" is pretty unintuitive and does not correspont to the icon's area
API call to zoho books from creator problem
Hi, there is a problem with API calls from creator to books that manifested today... did you do any changes/updates? this is causing delays and other issues for me... The code below I have used it for more than a year without any problems. but today it did not behave as expected. The objective is to pull today's invoices from books. Nomally we have 5 to 10 invoices per day, today it returned 200 records! and many of them repeated... then I use these reply to call one by one to create production
Stock Location If Statement
I have two forms, Inventory and Parts Used. In the Inventory form, I have 12 stock location for each Part. That form is updated when Parts are received from Purchase orders. When my Technicians use a part (From the Parts Used Form), the quantity is reduced in the Inventory Form for their location, there for maintaining a stock level. I am trying to create a script, that when they select the part, enter a quantity, their location, it checks to insure they have inventory in their location. I have listed
Next Page