Telephone Number Field Bug
When using deluge to add a telephone number to another telephone number field it appears a bug. The telephone field text goes behind the country code and cannot be seen very well. It also appears the field hasn't been filled in correctly. In this instance I am automatically inputting the telephone number based on the lookup of another form.
Creator New Help Pages are showing up empty
When I try to search for some strings on the new help pages and click on a url of the resulting query then a page does show up but its contents is empty. I was having this problem since a long time but couldn't exactly pinpoint the reason. Right now I need to find out some certain guides and can't find them on the help guides. For example the "Import Records into Report" page also doesn't exist on the instruction sections which can be selected from the left menu of the "Reports" home page. The sub
Creating my own pivot table using For Each Record
I would like to know how to group items and summarize the amount, based on a certain field. This code in my page (below) works just fine to get all the expenses that meet the criteria and produce the total of all the expenses. What would be cool though would be to have sub-totals of each category, as well as the grand total (like a pivot table) What I can't figure out is how to get just the records that are of a similar type, in this case all record with the same category (Home Expenses), then sum
Add organisation name to a Record Template (under Extensions > Settings)
I want to be able to add to a project template a field which is the name of the organisation. I have a Form where the user inputs this when setting up their business in the application. However, I am setting up the Record Template based on another Form, and I'm trying to work out how to pull in the name of the organisation into the Record Template. I have thought about creating a field on the Form to which the organisation name is added every time a record is created, but this seems a bit long-winded.
Auto Populating Multiline with values appearing on separate lines
While autopopulating a multiline filed using deluge, I want different data to appear one below the other as different lines and not on the same line. When i use " ", it appears with one space between two values. So, how to make them appear one below the other?
How to work with this exchange rate data
Hey everyone, My question is more of a personal head scratcher. In my finance app, I want to do a some exchange rate conversion. I found this site, https://api.exchangeratesapi.io/latest, which provide basic csv type data of the current rates of the day (adequate for my needs, and free :-). I was able to make a workflow using the invoke url deluge task to bring the data into a text field. Great. Problem is, now I can't seem to figure out what to DO with the data. In the text field, it's not
RegEx in Creator using replaceAll function
I am having trouble wrapping my head around the use of replaceAll and RegEx in Zoho Creator. It's my understanding I can't capture groups like I would with JS or Python. Can anyone provide guidance on how I could accomplish the following? str = "abcdefgh Record Date: 2020-04-05\n. abcdefghijklmnop" I'm trying to capture the word after Record Date:, and between \n. In other words, I'm trying to use the function to return only 2020-04-05.
Revieve error {"code":1002,"message":"Statement of Accounts does not exist."} when creating invoice in Books from Creator.
I receive the following error message when trying to create an invoice in Zoho Books from Creator: {"code":1002,"message":"Statement of Accounts does not exist."} Here is the statement i'm using to create the invoice: response = zoho.books.createRecord("Invoices","6699999999",values); Here are the contents of the 'values' variable being inserted into the zoho.books.createRecord statement: Values{"customer_id":62944600000011xxxx,"reference_number":"afa","date":"03-Apr-2020","line_items":[{"item_id":"125789400000155xxxx","name":"210XGD","quantity":1,"description":"blah
I want the "Approve" button to update current record
I thought this was as simple as using the criteria Zoho offers but I cannot seem to get the record to update. I just want to click the "Approve" button and update the record to Post. The only two options in the dropdown of BA are "For Approval" and "Post" I have attached images so you can easily see how I am trying to perform this action.
zoho pos bulk import
I've tried all different combinations to bulk import data into Zoho point of sale but it doesnt get the product. What am I doing wrong?
Using REST API insert to subform !
i have a main form call as Employee in this form has subform with Name: Employee Adress is a Subform fo Adress now i using REST API ................... <input type="text" name="Employee Adress[City]" value=""/> but did not work ! so how to format a subform data to work with ReST APi thanks for support !
Passing URL query string to embedded form
Hi there, I have an embedded (Iframe) Zoho Creator form on my external website which I am trying to pre-populate via a URL query string. The query is populated from merge tags, meaning the value changes depending on who clicks the link. I'm having trouble getting the web page to pass on the parameters to the embedded Iframe.... Example as a link from an email (where the name values would change given the merge tags: <mywebsite>/edm-enquiry/?fname=Emily&lname=Smith Iframe embedded into my website:
Mobile APP Jobs
Am new on zoho. If i get a mobile app design jobs from a client eg Restaurant, Church ,Hotel, School Mobile APP, what are the step by steps procedures I should take using zoho creator and how much can i charge.
[IMPORTANT] Addition of numbers using single textbox?
in Signle Input text /number field when i enter 5+5 or any number it will automatically get addiontin and display 10 replace with 5+5
Converting single line field to time sheet
Is it even possible to convert a single line field to calculate start time and end time in zoho? I would also like to add a time for lunch as well.. Example 30 minutes or 1 hour lunch to subtract from start and end time. I have found a few resources online like https://app.zohocreator.com/martryl/date-time-functions#DateTime but I cannot figure out how to do this without implementing the date-time field. Is this possible in Zoho Creator? I'm working on building a timesheet application that my employees
Zoho Creator XML RPC API - Add Record NOT WORKING - returns 200 success with empty response object
Hi, I am trying to add a new record to a form using the Zoho Creator XML RPC API and it's not working. The API always returns a 200 success code with and empty <response /> object, but no data gets inserted/added, nothing happens. (If I use the REST API, it works but REST doesn't support adding data to subforms) Here's an example request to a basic form that has only 1 field : XML RPC API (Not working) : REST API (working but cannot add subforms) : Si essentially I have 2 questions : 1) Can someone
Fetching Data from Lookup Field of a form.
Dear Sir / Madam, I have a form name Item which have multiple lookup field including one mane field named Item name , Lookup fields are Item category from category form and Item unit from Unit form. Now I wan't to create another form where I will setup a look up field for Item Name from item form and have two single line field which will show Category and unit of the item i select in lookup form. Could you please help me telling how to do this in zoho creator. I have searched but could not find
Hide fields based on input of lookup field
Hi all, I have tried different scripts but i keep getting errors. All i am trying to do is simply hide two fields when a certain input is chosen in the lookup field. Lookup field name is: Job_Name Other two fields i want to hide are: Cost_Class and Cost_Codes So, IF "No Job" is chosen in the lookup field Job_Name, I simply want to hide Cost_Class and Cost_Codes ELSE, show fields I have the code as follows: if(Job_Name.Job_Description == "No Job") { hide Cost_Class; hide Cost_Codes; } I keep getting
Sorting Values based on a certain Field Name and then Rendering to Table
I have a table that is getting all the correct values, and the only thing I want to do is sort this table when rendered by the Date_of_Invoice. I cannot figure out for the life of me how to do this or where to begin. Any help would be appreciated. Here is the code: <div class="divTableHeading3">Section C: Trust Distribution Payments</div> <div class="divTable1"> <div class="divTableBody"> <div class="divTableRow"> <div class="divTableCellB">Trust</div> <div class="divTableCellB">Amount from Trust</div>
Send Attachments via SendGrid
We have implemented a SendGrid integration with Creator, we have had to use SendGrid so that we can send from more than one email address. The integration works fine but we wish to extend it to include Attachments. We could do this using the SendMail function in Creator however in doing this we loose the ability to control who the email comes from. Has anyone implemented a SendGrid integration to include attachments. Thanks Gordon
Passing a variable value in a Permalink to a Form
I want to send a user a customized permalink to take him to a form. When he click on the link, I want to pass his username or ID to the form so that the Form can show only information relevant to him. For example, when a call desk captures a new "fault" based on a telephone call received from a client, I want to send an email to the client with a permalink that includes his TicketNumber. If the client clicks on the link, he will be able to seen progress on that specific fault and he would not
Select a value provided by the user into an "Add new" looked up value
I have a Main form called "Progress". Within "Progress" I have a lookup value that refers to a value in the form "Expected Outputs". This lookup value has the add new action enabled. In the "Progress" form, the user selects a project from a drop-down list. I would like that this input.Project could be automatically selected when the user adds a new "Expected Output" from the looked up value. I have been trying but I cannot find the way.
Creator 5 Migration Experiences w/ Portal and Paypal??
I have a large app that I am thinking of migrating to Creator 5. However, given past experiences with Zoho upgrades and the rather nebulous Zoho list of "degraded functionality" in Creator 5, I am nervous about changing anything. I would appreciate hearing other users' experiences in migrating to Creator 5. I am particularly interested in the following functionality that is used heavily in my app: 1. We have over 1,000 active Portal users, with a steady stream of new adds (about 200 a year) 2.
Redirect Customer Portal to external domain
Hi, I posted another question but perhaps this a better explanation. I have a domain say https://www.mydomain.com . I want customers that go to that domain will be redirected to my Zoho Customer Portal. I verified the domain that works but this just seems to concern mail. I really want a redirect, My hostingcompany asks for ipadres and such for a dns redirection. Where do i find this ? Please help i'm on a deadline and dns resolves will take long. Thanks !!!
Append code to Sign-up handler (insert into) not working
I added/appended this (default) code to the Helper on signup handler, but it doesn't seem to work when I test on a newly created Stage account. Is is extremely simple code. Any ideas on why this is not working? LIST_avdelning is a Form TXT_avdelning is a text field void signup(string customerEmail, map customerInfo) { insert into LIST_avdelning [ TXT_Avdelningsnamn="Ekonomi avd" Added_User=zoho.loginuser ] }
Print out a report page ?
Hello, In Creator I build a page with multiple panel and reports. I'm asked to have a PDF version of it, or at least the information. How can I acheive this ? There is apparently no way to print this page. Thanks
Unable to access production environment
I'm using custom solutions, and just in the last hour I've been unable to access Production. I have customers in there so is mission critical for my business. I have tried 2 different prod environments and 2 different browsers. Is anyone else have issues? Does anyone know where I can look to find the 'health' status of the environment in general so I can check without bothering technical support.
Email embedded link for non-user
I'm looking for a way for a non-user (not logged in or a Zoho User) can view a report record (Summary) sent via a link in an email and be able to click a decision box or other check box to reply (in the form). I need this record to be separate and independent from other records (views). After the non-user "checked-the-record" that record would then become unavailable for view again. Can this be done?
Delete Subform record when row deleted in parent form
I have a Parent form with a subform (which is an actual form, not created from Blank). The Parent form is "Parent Companies", while the subform is "Locations". Each parent company may have multiple locations. If I delete a "Location" (row from subform) while editing a record in the parent form, the data still remains in the subform. I would like to also delete the data in the subform form. Is there a way to accomplish this?
Circumvent "Get input before the form is displayed" field
For our mobile users, we have: a single-line field with QR and barcode scanner enabled, and "Get input before the form is displayed" enabled. This works as expected when users enter the form "the normal way". Now, I'd like to enter the form with a URL parameter that's passed to this QR/barcode/"Get input..." field and bypass the scanner, but this isn't happening. Basically, "Get input before the form is displayed" trumps "on Load". My "on Load" scripts fire when I enter the form (I tested this with
Only returning ID. How to get the field values?
I am populating choices for a radio button. Problem is that it only returns the ID of the row, while I want the actual value for the field (size_groups). How do I extract this so it list the actuall values, rather than the ID? My code: avail_size = f_sizes [ID>0] ; clear input.f_size; input.f_size:UI.add(avail_size.size_groups.getall(size_groups));
Dynamically add subform recorda on Form A to Lookup on Form B
Hi, I have tried the following script to dynamically populate a Lookup on Form B with subform records on Form A. I see the IDs are fetched bu the ui.add does not work here: sob = FormA[ID == fet.ID.toString()].subForm; input.FormBLookup:ui.add(sob.ID.getall()); Could you please help with the script that can fetch records from a Subform on Form A and dynamically add those records to a Lookup on Form B? Thank you
Functionality issue in Zoho Creator - Unicode in mail message
Namaskaram Zoho Creator team, we have tried to use the unicode symbols within the message of send mail. It shows the error and after showing that error message, the code has been deleted automatically. Please fix this as soon as possible. Refer following images. Crafted with ❤️ Zoho Gurus | Zoho Creator Practice Team @ CubeYogi Zoho Authorised Partner | 8+ Yrs | 200+ Projects | 100+ Customers
Why is the Zoho Creator team such a joke?
Over 23 days now and the Zoho Creator team refuses to give me any information as to why Twilio and Clockwork SMS Integrations don't work at all. I've been patient for over 3 weeks and they refuse to give me any information at all. No timeline, no nothing. Very unprofessional to treat a paying customer like this. Really sick of the terrible support here at Zoho. Did you know that we paid for premium support in full last week to only be told yesterday that we don't have a premium support account? The
Development Work during Lock-Down
Good day I have been developing our own internal apps for a non-profit for the past 4 years, for no income. Now, with the worldwide pandemic I suddenly find myself in lock-down, with no options of income for at least the next month. I am not yet a certified developer, but I would appreciate it if there is any development work available and if someone would be willing to give me a chance. This is my only hope at this stage. Please contact me at hendrikfsmit[at]gmail[dot]com
Hide / unhide custom action button with conditional statement
I have a custom action (to call a function) on a view. Is there a way to hide / unhide or enable / disable the custom action button based on a conditional statement (ex. IF statement)?
Zoho Creator - Unable to include form as SubForm
I'm currently using Zoho Creator trial and trying to include a form as a Subform in another form. However when I drag the subform item into the form there is no option to use an existing form. Instead I can only add new fields. Is it possible to link an existing form as a subform?
Drop down field for State and District in Zoho Creator
Namaskaram Zoho Creator Team, As of now, there is no possibility for changing District and State field from Single line to Drop down. It will be a good feature if the users can able to choose their Country followed by State and followed by district automatically using Drop down. When a user choose a Country based on the Country name the State field must be sorted with values related to that chosen Country. Crafted with ❤️ Zoho Gurus | Zoho Creator Practice Team @ CubeYogi Zoho Authorised
Zoho Creator
how can i seperate my consultants emails those are not submitted timesheets before 5th of the every month??
Customer Portal and Optional Login
Hi, Zoho Creator looks like amazing product in many ways, with clear and properly written guides and tutorials, well done! However, I have studied the eBooks, looked into this community, watched YouTube videos and browsed the Internet, but unfortunately I didn't find a solution for my need. I would like to create Event Management portal, where customers could browse the events and also create them. Browsing events and buying tickets should be possible without signing-up, because if sign-up is required,
Next Page